From: | Bryan Henderson <bryanh(at)giraffe-data(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Why threads every 30 seconds? |
Date: | 2016-06-09 02:39:30 |
Message-ID: | 67122.bryanh@giraffe-data.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>>> Looking at audit logs, I see that my Postgresql server generates a new thread
>>> precisely every 30 seconds, in two series (so 4 threads every minute). This
>>> is an otherwise idle server.
>
>>> Does anyone know what these threads are for? Just curious.
>
>Autovacuum, likely. The rate would depend on your autovacuum_naptime
>and how many active databases you have.
Yep, that was it, thanks.
I had the default autovacuum_naptime of 1 minute, and had two Postgresql
clusters runing. I turned off autovacuum and these threads disappeared.
Still not sure how it comes to twice a minute per cluster. There are 5
databases, and as far as I know, a client connection to one of them, not
doing anything, while this was happening.
--
Bryan Henderson San Jose, California
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Sargent | 2016-06-09 03:05:22 | Re: Automate copy - Postgres 9.2 |
Previous Message | Patrick B | 2016-06-09 02:04:14 | Re: Automate copy - Postgres 9.2 |