Bastian Voigt wrote:
>
> OK, I'll give that a try. What about pg_autovacuum then? Is it a problem
> when two processes try to vacuum the same table in parallel? Or do I
> need to deactivate autovacuum altogether?
I was about to say that you can tune pg_autovacuum, but I just checked
your original post and you're running 8.0.x - not sure about that one.
You'll have to check the documentation for that version to see if you
can either:
1. exclude that table from pg_autovacuum
2. increase pg_autovacuum's sensitivity
If not, and this table is the most active, it might be simpler just to
run your own vacuum-ing from a cron job.
--
Richard Huxton
Archonet Ltd