Re: managing database with thousands of tables

Поиск
Список
Период
Сортировка
От Eugeny N Dzhurinsky
Тема Re: managing database with thousands of tables
Дата
Msg-id 20060705155727.GC15232@office.redwerk.com
обсуждение исходный текст
Ответ на Re: managing database with thousands of tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: managing database with thousands of tables  (Chris <dmagick@gmail.com>)
Список pgsql-performance
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 ;) )?

--
Eugene N Dzhurinsky

В списке pgsql-performance по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: Opteron/FreeBSD/PostgreSQL performance poor
Следующее
От: Vivek Khera
Дата:
Сообщение: Re: Opteron/FreeBSD/PostgreSQL performance poor