vacuum

From: "Guillaume Houssay" <ghoussay(at)noos(dot)fr>
To: <pgsql-general(at)postgresql(dot)org>
Subject: vacuum
Date: 2004-01-08 21:42:40
Message-ID: 019d01c3d630$57b2b650$8600a8c0@camille
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

  • Re: vacuum at 2004-01-08 22:30:58 from scott.marlowe

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2004-01-08 21:48:25 Re: MVCC for massively parallel inserts
Previous Message Tom Lane 2004-01-08 21:26:32 Re: 7.3.3 drop table takes very long time