Re: 8.1 - pg_autovacuum question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux