From: | Kenneth Marshall <ktm(at)rice(dot)edu> |
---|---|
To: | akp geek <akpgeek(at)gmail(dot)com> |
Cc: | Thomas Kellerer <spam_eater(at)gmx(dot)net>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: autovacuum strategy / parameters |
Date: | 2010-04-28 14:45:36 |
Message-ID: | 20100428144536.GC1610@aart.is.rice.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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_eater(at)gmx(dot)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(at)postgresql(dot)org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-performance
> >
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2010-04-28 14:45:57 | Re: autovacuum strategy / parameters |
Previous Message | akp geek | 2010-04-28 14:37:35 | Re: autovacuum strategy / parameters |