VACUUM and index

DANTE Alexandra · *nix forums beginner Joined: 07 Jul 2006 Posts: 9

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 B-tree index be scanned,
space reclaimed and made available for re-use ?
Does this action only do by a VACUUM FULL ?
Or is it necessary to do a REINDEX on the index to retrieve a
well-balanced tree ?

Thank you for your help.

Regards,
Alexandra DANTE

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Martijn van Oosterhout · *nix forums Guru Joined: 02 Mar 2005 Posts: 674

On Wed, Jul 19, 2006 at 03:03:43PM +0200, DANTE Alexandra wrote:

DANTE Alexandra · *nix forums beginner Joined: 07 Jul 2006 Posts: 9

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:

Martijn van Oosterhout · *nix forums Guru Joined: 02 Mar 2005 Posts: 674

On Wed, Jul 19, 2006 at 03:23:08PM +0200, DANTE Alexandra wrote:

Google