Re: 8.1 - pg_autovacuum question

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Chris Hoover <revoohc(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: 8.1 - pg_autovacuum question
Date: 2005-12-16 20:26:55
Message-ID: 20051216202655.GF27602@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Chris Hoover wrote:
> In PostgreSQL 8.1, is the pg_autovacuum daemon affected by the
> vacuum_cost_* variables? I need to make sure that if we turn
> autovacuuming on when we upgrade to 8.1, we don't cause any i/o
> issues.

What pg_autovacuum daemon? The contrib one? I don't know. The
integrated one? Yes it is; and you can set autovacuum-specific values
in postgresql.conf and table-specific values (used for autovacuum only)
in pg_autovacuum.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Kirkwood 2005-12-16 21:11:19 Re: Simple Join
Previous Message Chris Hoover 2005-12-16 19:40:22 8.1 - pg_autovacuum question