pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Thomas Kellerer <spam_eater@gmx.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: autovacuum strategy / parameters
Date: Sat, 1 May 2010 10:08:36 -0600
Message-ID: <r2ydcc563d11005010908u4e08ed56q46932333310e260b@mail.gmail.com> (raw)
In-Reply-To: <hr9g84$at8$1@dough.gmane.org>
References: <c2d2b6cf-895f-4a4b-aa8b-3adaac33c794@z3g2000yqz.googlegroups.com>
	<y2g603c8f071004221155h3874a3c0ybbe2c790e3c1bf80@mail.gmail.com>
	<65d9d15d-41d2-4bfa-8cc3-6148b4fb9022@z3g2000yqz.googlegroups.com>
	<hr9g84$at8$1@dough.gmane.org>

On Wed, Apr 28, 2010 at 8:20 AM, Thomas Kellerer <spam_eater@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...

You can as well with 8.3, but it's not made by alter table but by
pg_autovacuum table entries.



view thread (21+ messages)  latest in thread

Message-ID: <r2ydcc563d11005010908u4e08ed56q46932333310e260b@mail.gmail.com>
Permalink:  ../r2ydcc563d11005010908u4e08ed56q46932333310e260b@mail.gmail.com/
Also on:    postgresql.org/message-id/r2ydcc563d11005010908u4e08ed56q46932333310e260b@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: scott.marlowe@gmail.com, spam_eater@gmx.net
  Subject: Re: autovacuum strategy / parameters
  In-Reply-To: <r2ydcc563d11005010908u4e08ed56q46932333310e260b@mail.gmail.com>
  References: <c2d2b6cf-895f-4a4b-aa8b-3adaac33c794@z3g2000yqz.googlegroups.com> <y2g603c8f071004221155h3874a3c0ybbe2c790e3c1bf80@mail.gmail.com> <65d9d15d-41d2-4bfa-8cc3-6148b4fb9022@z3g2000yqz.googlegroups.com> <hr9g84$at8$1@dough.gmane.org> <r2ydcc563d11005010908u4e08ed56q46932333310e260b@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox