Re: Autovacuum behavior with rapid insert/delete 9.6

2018-03-29 Thread Peter Geoghegan
On Thu, Mar 29, 2018 at 4:01 PM, Ted Filmore 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

Autovacuum behavior with rapid insert/delete 9.6

2018-03-29 Thread Ted Filmore
Using mostly default parameters with 9.3 we are seeing reasonable performance with our heavy transaction-based application. However, when we are upgraded to 9.6 we are seeing horrible performance with the same loads using the same hardware. Gathering the configuration details, but I think I've sp