Hi, Suggestion noted. Nevertheless, I cannot imagine what it would help. Actually, the cost_delay makes autovacuum freeze when it takes more time than expected, therefore, having it enabled should help the system.
I may try it as a last possible resolution (remember that I have to wait for a couple of days for the problem to appear, so any test I perform will be taking days to figure out if it helped !!!) > > I had similar issue and I disabled cost based auto vacuum: > autovacuum_vacuum_cost_delay = -1 > > -1 says that vacuum_cost_delay will be used and default value for > vacuum_cost_delay is 0 (ie. off) > > Of couse you need to change other autovacuum settings but you did that. > > -- > Ondrej Ivanic > (ondrej.iva...@gmail.com) -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
