Re: managing database with thousands of tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Eugeny N Dzhurinsky <bofh(at)redwerk(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: managing database with thousands of tables
Date: 2006-07-05 13:39:31
Message-ID: 2955.1152106771@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Eugeny N Dzhurinsky <bofh(at)redwerk(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message andy rost 2006-07-05 14:43:00 Opteron/FreeBSD/PostgreSQL performance poor
Previous Message Eugeny N Dzhurinsky 2006-07-05 13:07:03 managing database with thousands of tables