Postgres Pro
Downloads
Home   >   mailing lists

vacuum - Mailing list pgsql-general

From Guillaume Houssay
Subject vacuum
Date
Msg-id 019d01c3d630$57b2b650$8600a8c0@camille
Whole thread Raw
Responses Re: vacuum  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
Tree view
I am using a 7.3.4.
 
just simple questions ;=)
 
1.when I launch a vacuum verbose analyze on my database. Does it re-cretae all the indexes of each table ?
 
2.In addition to the vacuum, do I have to re-index my database using REINDEX
 
3.Is REINDEX only used for created corrupt indexes (as I understood from 7.3 documentation) or can it be used to re-index a database or a table (as I understood from documentation for 7.4)
 
Thank you for your help.
 
 

pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: 7.3.3 drop table takes very long time
Next
From: Tom Lane
Date:
Subject: Re: 7.3.3 drop table takes very long time