Postgres Pro
Downloads
Home   >   mailing lists

Re: Is there any other way to do this? - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: Is there any other way to do this?
Date
Msg-id 428AA493.4000806@familyhealth.com.au
Whole thread Raw
In response to Is there any other way to do this?  (Wei Weng <wweng@kencast.com>)
List pgsql-performance
Tree view 
> This time it worked! But VACUUM FULL requires an exclusive lock on the
> table which I don't really want to grant. So my question is: why is
> VACUUM ANALYZE didn't do the job? Is there any setting I can tweak to
> make a VACUUM without granting a exclusive lock?

You need to run normal vacuum analyze every few minutes or so, to stop
it growing.  I suggest pg_autovacuum.

Chris

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Tuning planner cost estimates
Next
From: Szűcs Gábor
Date:
Subject: where+orderby+limit not (always) using appropriate index?