Re: managing database with thousands of tables

From: Eugeny N Dzhurinsky <bofh(at)redwerk(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: managing database with thousands of tables
Date: 2006-07-05 15:57:27
Message-ID: 20060705155727.GC15232@office.redwerk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Jul 05, 2006 at 09:39:31AM -0400, Tom Lane wrote:
> 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?

May be. So should I update to newer postgres 8.1 or just upgrade
pg_autovacuum somehow (I don't know how btw ;) )?

--
Eugene N Dzhurinsky

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Vivek Khera 2006-07-05 17:55:28 Re: Opteron/FreeBSD/PostgreSQL performance poor
Previous Message Stephen Frost 2006-07-05 15:46:56 Re: Opteron/FreeBSD/PostgreSQL performance poor