Re: 15,000 tables

me@alternize.com wrote:

> what i noticed is autovacuum not working properly as it should. i had 8.1
> running with autovacuum for just 2 days or so and got warnings in pgadmin
> that my tables would need an vacuum.

Hum, so how is autovacuum's documentation lacking?  Please read it
critically and let us know so we can improve it.

http://www.postgresql.org/docs/8.1/static/maintenance.html#AUTOVACUUM

Maybe what you need is to lower the "vacuum base threshold" for tables
that are small.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support