Re: VACUUM and index - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: VACUUM and index
Date
Msg-id 20060719132837.GB6893@svana.org
Whole thread Raw
In response to Re: VACUUM and index  (DANTE Alexandra <Alexandra.Dante@bull.net>)
List pgsql-general
On Wed, Jul 19, 2006 at 03:23:08PM +0200, DANTE Alexandra wrote:
> Thank you Martijn for your answer !
> I use the 8.1.3 release of PostgreSQL.

You'll be fine...

> Will it be sensible to launch an ANALYZE after the VACUUM to update
> statistics ?

Or do both at the same time (VACUUM ANALYZE).

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: DANTE Alexandra
Date:
Subject: Re: VACUUM and index
Next
From: Q
Date:
Subject: Re: Performance problem with query