| From: | Wayne Cuddy <lists-pgsql(at)useunix(dot)net> |
|---|---|
| To: | PostgreSQL <pgsql-sql(at)postgresql(dot)org> |
| Subject: | autovacuum processes not spawning |
| Date: | 2020-06-02 00:43:25 |
| Message-ID: | 20200602004325.GL20190@ln-1.useunix.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Bannister | 2020-06-03 13:52:40 | Recursive CTE with a function |
| Previous Message | Gary Stainburn | 2020-05-30 19:40:32 | Re: left outer join with count |