Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group