On Tue, May 17, 2005 at 06:58:20PM -0400, Wei Weng wrote: > 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 just didn't vacuum often enough. Plain VACUUM (with ANALYZE or not) only deletes dead rows, it does not reclaim the space used for them (and thus does not compress the remaining ones into fewer pages, so they take less time to scan). If you simply VACUUM regularily (try autovacuum from contrib, it will probably be useful) the problem simply will never be as bad as you describe here, and you won't need to VACUUM FULL. /* Steinar */ -- Homepage: http://www.sesse.net/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
