Re: [ZODB-Dev] RelStorage and PostgreSQL's VACUUM

2011-02-24 Thread Maurits van Rees
Op 23-02-11 12:41, Maurits van Rees schreef: CLUSTER does not do anything unless you first tell it which index to use for clustering a table. Using postgres 8.4 I have done this for the four tables for which I think this is useful (the other tables had no content): cluster blob_chunk using

Re: [ZODB-Dev] RelStorage and PostgreSQL's VACUUM

2011-02-23 Thread Maurits van Rees
Hi all, Reviving a thread from October 2010 about vacuuming in postgres. Op 20-10-10 17:35, David Blewett schreef: On Tue, Oct 19, 2010 at 1:05 AM, Noe Misael Nieto Arroyo n...@iservices.com.mx wrote: And if yes, What kind of VACUUM is good? FULL, CLUSTER? VACUUM FULL is almost never a

Re: [ZODB-Dev] RelStorage and PostgreSQL's VACUUM

2010-10-20 Thread David Blewett
On Tue, Oct 19, 2010 at 1:05 AM, Noe Misael Nieto Arroyo n...@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

Re: [ZODB-Dev] RelStorage and PostgreSQL's VACUUM

2010-10-20 Thread Noe Misael Nieto Arroyo
Thanks for the tip! -- Noe 2010/10/20 David Blewett da...@dawninglight.net On Tue, Oct 19, 2010 at 1:05 AM, Noe Misael Nieto Arroyo n...@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

Re: [ZODB-Dev] RelStorage and PostgreSQL's VACUUM

2010-10-19 Thread 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

Re: [ZODB-Dev] RelStorage and PostgreSQL's VACUUM

2010-10-19 Thread Noe Misael Nieto Arroyo
Thanks. --- Noe 2010/10/19 Shane Hathaway sh...@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