Re: server space increasing very fast but transaction are very low

Поиск
Список
Период
Сортировка
Искать
От
Guillaume Cottenceau
Тема
Re: server space increasing very fast but transaction are very low
Дата
Msg-id
8763n1jcdm.fsf@mnc.ch
Ответ на
Список
Дерево обсуждения
server space increasing very fast but transaction are very low brahma tiwari <prakashr2n5@yahoo.com>
Re: server space increasing very fast but transaction are very low Richard Huxton <dev@archonet.com>
Re: server space increasing very fast but transaction are very low Guillaume Cottenceau <gc@mnc.ch>
Richard Huxton  writes:

> I'm guessing what you've got is a table that's not being vacuumed
> because you've had a transaction that's been open for weeks.

Or because no vacuuming at all is performed on this table (no
autovacuum and no explicit VACUUM on database or table).

-- 
Guillaume Cottenceau
В списке pgsql-performance по дате отправления
От: Richard Huxton
Дата:
От: Helio Campos Mello de Andrade
Дата:
Сообщение: Re: PostgreSQL OR performance
FAQ