Postgres Pro
Downloads
Home   >   mailing lists

Re: Large databases, performance - Mailing list pgsql-hackers

From Manfred Koizar
Subject Re: Large databases, performance
Date
Msg-id latopug1vl51769nkn3rj2ltdhjvqrbfof@4ax.com
Whole thread Raw
In response to Re: Large databases, performance  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Responses Re: Large databases, performance
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Trigger regression test output
Next
From: "scott.marlowe"
Date:
Subject: Re: Correlation in cost_index()