Postgres Pro
Downloads
Home   >   mailing lists

Re: VACUUM FULL for performance - Mailing list pgsql-general

From Leonardo Francalanci
Subject Re: VACUUM FULL for performance
Date
Msg-id 298310.22048.qm@web29013.mail.ird.yahoo.com
Whole thread Raw
In response to Re: VACUUM FULL for performance  (Bill Moran <wmoran@potentialtech.com>)
Responses Re: VACUUM FULL for performance  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
> I also  recommend reindexing any table that has been VACUUM FULLed.


Mmmh, from the docs I get that in 9.0 a "vacuum full" rewrites the whole table,
so I expect the indexes to be re-created anyway... so a reindexing would
be totally useless.

Am I wrong?

pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Tutorials on high availability Postgresql setup?
Next
From: Peter Geoghegan
Date:
Subject: Re: PostgreSQL 7.4.16 is creating strange files under /var/lib/pgsql