> 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.
In response to
pgsql-performance by date
|Next:||From: Szűcs Gábor||Date: 2005-05-18 14:30:17|
|Subject: where+orderby+limit not (always) using appropriate index?|
|Previous:||From: Jim C. Nasby||Date: 2005-05-18 00:22:36|
|Subject: Tuning planner cost estimates|