Re: [7.0.2] INDEX' TUPLES != HEAP' ..

Поиск
Список
Период
Сортировка
От The Hermit Hacker
Тема Re: [7.0.2] INDEX' TUPLES != HEAP' ..
Дата
Msg-id Pine.BSF.4.21.0007122016520.1325-100000@thelab.hub.org
обсуждение исходный текст
Ответ на Re: [7.0.2] INDEX' TUPLES != HEAP' ..  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [7.0.2] INDEX' TUPLES != HEAP' ..  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Wed, 12 Jul 2000, Tom Lane wrote:

> The Hermit Hacker <scrappy@hub.org> writes:
> > Odd .. why is heap reporting 5899, when count() only reports 2951?
> 
> Open transactions preventing recently-dead tuples from being reaped?

nope ... I've tried recreating the indices, no change ... and no change in
number of tuples ... actually, since this database is up, there would have
been zero additions or deletions, as that ability is yet to be re-written,
so other then SELECTs, that table is static/read-only





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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [7.0.2] INDEX' TUPLES != HEAP' ..
Следующее
От: Tim Perdue
Дата:
Сообщение: Some Improvement