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
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
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
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
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
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