Postgres Pro
Downloads
Home   >   mailing lists

Re: Autovacuum behavior with rapid insert/delete 9.6 - Mailing list pgsql-general

From Peter Geoghegan
Subject Re: Autovacuum behavior with rapid insert/delete 9.6
Date
Msg-id CAH2-WzmXEUV5MjQ+iuMVe1Fh7_b9SaQ+uwdGGoe74xiU-OhY-g@mail.gmail.com
Whole thread Raw
In response to Autovacuum behavior with rapid insert/delete 9.6  (Ted Filmore <pilepiper@gmail.com>)
List pgsql-general
Tree view 
On Thu, Mar 29, 2018 at 4:01 PM, Ted Filmore <pilepiper@gmail.com> wrote:
> What I am really asking to confirm is after describing the situation is it
> reasonable to focus on (in the short term) tuning autovacuum to increase
> performance or does this not make sense given the workload and I should look
> elsewhere?

I would look into this suspected 9.5 regression, if that's possible:

https://postgr.es/m/CAH2-Wz=SfAKVMv1x9Jh19EJ8am8TZn9f-yECipS9HrrRqSswnA@mail.gmail.com

-- 
Peter Geoghegan

pgsql-general by date:

Previous
From: Ted Filmore
Date:
Subject: Autovacuum behavior with rapid insert/delete 9.6
Next
From: Laurenz Albe
Date:
Subject: Re: dblink: could not send query: another command is already inprogress