[ZODB-Dev] RelStorage and PostgreSQL's VACUUM

[Noe Misael Nieto Arroyo]

Thanks for the tip!

--
Noe

2010/10/20 David Blewett <david at dawninglight.net>

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