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) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
