Check out the manual: http://www.postgresql.org/docs/8.4/static/routine-vacuuming.html#AUTOVACUUM
Cheers, Ken On Wed, Apr 28, 2010 at 10:37:35AM -0400, akp geek wrote: > Hi - > don't want to side track the discussion. We have 8.4, which of > AUTOVACUUM PARAMETERS can be set to handle individual table? I ran into > bloat with small table only. Now the issue is being resolved. > > Regards > On Wed, Apr 28, 2010 at 10:20 AM, Thomas Kellerer <spam_ea...@gmx.net>wrote: > > > Rick, 22.04.2010 22:42: > > > > > >> So, in a large table, the scale_factor is the dominant term. In a > >> small table, the threshold is the dominant term. But both are taken into > >> account. > >> > >> The default values are set for small tables; it is not being run for > >> large tables. > >> > > > > With 8.4 you can adjust the autovacuum settings per table... > > > > > > > > > > > > -- > > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-performance > > -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
