Postgres Pro
Downloads
Home   >   mailing lists

Re: loading data, creating indexes, clustering, vacuum... - Mailing list pgsql-general

From Angva
Subject Re: loading data, creating indexes, clustering, vacuum...
Date
Msg-id 1165599211.622120.148270@l12g2000cwl.googlegroups.com
Whole thread Raw
In response to loading data, creating indexes, clustering, vacuum...  ("Angva" <angvaw@gmail.com>)
Responses Re: loading data, creating indexes, clustering, vacuum...  (Bill Moran <wmoran@collaborativefusion.com>)
Re: loading data, creating indexes, clustering, vacuum...  ("Shoaib Mir" <shoaibmir@gmail.com>)
List pgsql-general
Tree view 
> clustering also removes the dead tuples.

I have a followup question. What if the set of dead tuples is too big
and I need to VACUUM FULL, as opposed to VACUUM. (The update size
varies greatly from day to day.) Will the clustering effectively do a
VACUUM FULL, or just a VACUUM?

Thanks again for your help,
Mark

pgsql-general by date:

Previous
From: Luca Ferrari
Date:
Subject: help understanding analyze
Next
From: ptjm@interlog.com (Patrick TJ McPhee)
Date:
Subject: Re: Restore database from files (not dump files)?