[ZODB-Dev] RelStorage and PostgreSQL's VACUUM

[David Blewett]

On Tue, Oct 19, 2010 at 1:05 AM, Noe Misael Nieto Arroyo
<noe at iservices.com.mx> wrote:
> And if yes, What kind of VACUUM is good? FULL, CLUSTER?

VACUUM FULL is almost never a good idea; autovac should be sufficient
for most needs, and can be tweaked to meet particular performance
issues. I have had very good results doing a CLUSTER after an initial
zodbconvert run to significantly reduce the size of the database. I
highly recommend doing CLUSTER after any large data loads.

David Blewett