Hi,
I've got an 8.4.11 system that I am relatively new to and I am seeing multiple
autovac processes kick off on several of the largest tables at once and it is
causing pain.
Are there any suggestions to
a) quickly relieve the immediate pain
and
b) prevent such issues in the future
Greg Williamson gwilliamso...@yahoo.com wrote:
I've got an 8.4.11 system that I am relatively new to and I am
seeing multiple autovac processes kick off on several of the
largest tables at once and it is causing pain.
Are there any suggestions to
a) quickly relieve the immediate pain
Kevin --
...
a) quickly relieve the immediate pain
Set autovacuum_cost_limit to a smaller value. (Change the
postgresql.conf file and do a reload.) I would start by cutting the
current value in half.
Thanks -- would not have known how to start. But for now, in
observance of your
Could you please help with this peculiar problem?
In PostgreSQL log occurred this message:
2012-06-13 12:58:45.876 MDT [17536]: [1-1] FATAL: terminating
autovacuum process due to administrator command
The server worked for 48 minutes after and then it started refuse
non-superuser connections,