> 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