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
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq