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

From Chris
Subject Re: managing database with thousands of tables
Date
Msg-id 44AC5A50.9000503@gmail.com
Whole thread Raw
In response to Re: managing database with thousands of tables  (Eugeny N Dzhurinsky <bofh@redwerk.com>)
List pgsql-performance
Eugeny N Dzhurinsky wrote:
> On Wed, Jul 05, 2006 at 09:39:31AM -0400, Tom Lane wrote:
>> 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?
>
> May be. So should I update to newer postgres 8.1 or just upgrade
> pg_autovacuum somehow (I don't know how btw ;) )?

Update the whole lot. You should be able to do the upgrade "in place"
but take a backup "just in case".

http://www.postgresql.org/docs/8.1/interactive/release.html

will list all changes between versions.

--
Postgresql & php tutorials
http://www.designmagick.com/

pgsql-performance by date:

Previous
From: Kenji Morishige
Date:
Subject: suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1
Next
From: Mark Kirkwood
Date:
Subject: Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL