Re: Postgres becoming slow, only full vacuum fixes it

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(dot)ivanic(at)gmail(dot)com)