On Fri, Oct 14, 2011 at 2:35 AM, Svetlin Manavski <svetlin.manavski@xxxxxxxxx> wrote: > Thank you guys for spotting the problem immediately. > The reason for such autovacuum thresholds is that these tables are designed > for very high rate of inserts and I have a specific routine to analyze them > in a more controlled way. Infact the stats target of some of the fields is > also high. However that routine was failing to perform analyze on > appqosdata.icmptraffic and its children due to another issue... Note that it's possible to set many of the autovacuum values per table so you don't have to do a brainyectomy on the whole autovac system. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance