Обсуждение: 8.1 - pg_autovacuum question

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.

Thanks,

Chris

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.