Sachchida Ojha wrote:
> vacuum_cost_delay = 200
That is absurdly high. A setting of 10 is more likely to be useful.
> autovacuum_naptime = 3600
That is too high probably as well; particularly so if you have "updates
and deletes every second".
> #autovacuum_vacuum_scale_factor = 0.4
> #autovacuum_analyze_scale_factor = 0.2
These too. Try 0.1 for both and see how it goes.
In short, you need autovacuum to run _way more often_ than you are.
--
Alvaro Herrera http://www.advogato.org/person/alvherre
"Un poeta es un mundo encerrado en un hombre" (Victor Hugo)