Re: pg_class.reltuples not reset by VACUUM?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_class.reltuples not reset by VACUUM?
Дата
Msg-id 19573.1049829599@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_class.reltuples not reset by VACUUM?  (Jeff Boes <jboes@nexcerpt.com>)
Ответы Re: pg_class.reltuples not reset by VACUUM?  (Jeff Boes <jboes@nexcerpt.com>)
Список pgsql-admin
Jeff Boes <jboes@nexcerpt.com> writes:
> On Tue, 2003-04-08 at 15:10, Tom Lane wrote:
>> Yup, you definitely have a big problem with dead-but-unreclaimed tuples.
>> Look for some client that's holding an open transaction for long
>> periods.

> It's even weirder than that:  note in the following how VACUUM sets the
> tuple count high, and ANALYZE sets it low.

That doesn't surprise me, given what they count.

> This appears to happen even if there are no transactions open.

You have open transactions.  Go find 'em...

            regards, tom lane


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

Предыдущее
От: SHOBHA HALDONKAR
Дата:
Сообщение: deadlock detection
Следующее
От: CoL
Дата:
Сообщение: Re: Duplicate primary key and also the OID !!!!