Re: [GENERAL] VACUUM and index

2006-07-19 Thread Martijn van Oosterhout
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). H

Re: [GENERAL] VACUUM and index

2006-07-19 Thread DANTE Alexandra
Thank you Martijn for your answer ! I use the 8.1.3 release of PostgreSQL. Will it be sensible to launch an ANALYZE after the VACUUM to update statistics ? Regards, Alexandra Martijn van Oosterhout wrote: On Wed, Jul 19, 2006 at 03:03:43PM +0200, DANTE Alexandra wrote: Imagine you have a

Re: [GENERAL] VACUUM and index

2006-07-19 Thread Martijn van Oosterhout
On Wed, Jul 19, 2006 at 03:03:43PM +0200, DANTE Alexandra wrote: > Imagine you have a database on which a lot of transactions are done > daily : the tables will contain a lot of dead tuples and the B-tree > index too. > > If I do a VACUUM on this database, will the B-tree index be scanned, > sp