[ZODB-Dev] RelStorage and PostgreSQL's VACUUM

[Shane Hathaway]

On 10/18/2010 11:05 PM, Noe Misael Nieto Arroyo wrote:
> Hi all,
>
> I am moving a site to another server and took the oportunity to upgrade
> to Plone 3.3.5 and RelStorage 1.4.0. PostgreSQL is 8.3.  I'm writing a
> couple of scripts to automate maintenance and backup of the ZODB.
>
> PostgreSQL documentation says that the autovacuum process should be
> enough for most use cases, so:
>
> Does RelStorage really need VACUUM ?
>
> And if yes, What kind of VACUUM is good? FULL, CLUSTER?

Recent versions of PostgreSQL have autovacuum, which should be 
sufficient.  I would probably use the default vacuum mode.

Shane