autovacuum processes not spawning
От | Wayne Cuddy |
---|---|
Тема | autovacuum processes not spawning |
Дата | |
Msg-id | 20200602004325.GL20190@ln-1.useunix.net обсуждение исходный текст |
Список | pgsql-sql |
Version: PGSQL-TimescaleDB 9.6 OS: Debian Linux, Kernel 4.9.0 Been running happily on a fairly busy server for quite some time. Aside from the occasional hardware issues it's been very stable. Last Friday we noticed we had performance issues with tables that are usually never a problem. Nothing changed WRT our application with is quite predictable. We determined that on Thursday night autovacuum processes were no longer starting. Our server is configured to log whenever AV runs start as well as log all durations. The autovacuum launcher process was still running and there were no errors in the log. We could manually initially vacuums and they would run to completion without error. Today we bounced the database process and it's now running autovacuums at regular intervals and performance is what we expect. Has anyone else had autovacuums just stop launching? Is there a way to restart the autovacuum launcher without restarting the entire database? I'm not positive it's the launcher but I have nothing else to blame at this point. Wayne
В списке pgsql-sql по дате отправления: