[ZODB-Dev] RelStorage and PostgreSQL's VACUUM

[Noe Misael Nieto Arroyo]

Thanks.

---
Noe

2010/10/19 Shane Hathaway <shane at hathawaymix.org>

> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zodb-dev/attachments/20101019/f91b4ffb/attachment.html