On 8 April 2018 at 15:02, David Rowley <david.row...@2ndquadrant.com> wrote: > On 8 April 2018 at 14:56, David Rowley <david.row...@2ndquadrant.com> wrote: >> It happens 12 or 13 times on my machine, then does not happen again >> for 60 seconds, then happens again. > > Setting autovacuum_naptime to 10 seconds makes it occur in 10 second > intervals...
Ok, I thought it might have been some concurrent vacuum on the table but the only tables I see being vacuumed are system tables. I tried performing a manual vacuum of each of these and could not get it to trigger, but then I did: select * from pg_class; from another session and then the script starts spitting out some errors. -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services