On Fri, Oct 14, 2011 at 2:35 AM, Svetlin Manavski
> 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.
In response to
pgsql-performance by date
|Next:||From: Arjen van der Meijden||Date: 2011-10-14 10:41:34|
|Subject: Re: SSD options, small database, ZFS|
|Previous:||From: Svetlin Manavski||Date: 2011-10-14 08:35:57|
|Subject: Re: Join over two tables of 50K records takes 2 hours|