Horton

Re: [HACKERS] Large databases, performance

Manfred Koizar <mkoi-pg@aon.at>

View thread
From: Manfred Koizar <mkoi-pg@aon.at>
To: shridhar_daithankar@persistent.co.in
Cc: pgsql-performance@postgresql.org, pgsql-hackers@postgresql.org, pgsql-general <pgsql-general@postgresql.org>, "pankaj M. Tolani" <pankaj@pspl.co.in>
Date: 2002-10-03T16:53:32Z
Lists: pgsql-hackers, pgsql-performance 
On Thu, 03 Oct 2002 21:47:03 +0530, "Shridhar Daithankar"
<shridhar_daithankar@persistent.co.in> wrote:
>I believe that was vacuum analyze only.

Well there is

	VACUUM [tablename]; 

and there is

	ANALYZE [tablename];

And

	VACUUM ANALYZE [tablename];

is VACUUM followed by ANALYZE.

Servus
 Manfred