Re: managing database with thousands of tables - Mailing list pgsql-performance

From Tom Lane
Subject Re: managing database with thousands of tables
Date
Msg-id 2955.1152106771@sss.pgh.pa.us
Whole thread Raw
In response to managing database with thousands of tables  (Eugeny N Dzhurinsky <bofh@redwerk.com>)
Responses Re: managing database with thousands of tables  (Eugeny N Dzhurinsky <bofh@redwerk.com>)
List pgsql-performance
Eugeny N Dzhurinsky <bofh@redwerk.com> writes:
> but it seems pg_autovacuum does not do vacuuming on system tables.

There was a bug awhile back whereby autovac failed to notice temp table
cleanup at connection end --- maybe you need to update?

            regards, tom lane

pgsql-performance by date:

Previous
From: Eugeny N Dzhurinsky
Date:
Subject: managing database with thousands of tables
Next
From: andy rost
Date:
Subject: Opteron/FreeBSD/PostgreSQL performance poor