We also have in our postgresql.conf file
autovaccum = on
default_statistics_target = 100
Do you recommend any changes?
This partitioned table doti_sensor_report contains in total approximately 15 billion rows, autovaccum current has three processes that are running continuously on the box and specifically targeting this table to keep up.
What does the upgrade to 9.3.5 buy us in terms of performance improvements?
thanks Victor
Freddie
From: Victor Yegorov [vyegorov@gmail.com]
Sent: Friday, September 26, 2014 4:25 PM
To: Burgess, Freddie
Subject: Re: [PERFORM] Very slow postgreSQL 9.3.4 query