Hello List,
Sorry to send an other e-mail on this subject but it is become a little
bit vague for me.
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
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
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
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