Re: pgstattuple output?

Поиск
Список
Период
Сортировка
От John D. Burger
Тема Re: pgstattuple output?
Дата
Msg-id 8877cfcaf598ac5691496170fb28b561@mitre.org
обсуждение исходный текст
Ответ на Re: pgstattuple output?  (Michael Crozier <crozierm@conducivetech.com>)
Ответы Re: pgstattuple output?  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general
Michael Crozier wrote:

> I think I see now, "dead" tuples are the tuples that have yet to be
> reclaimed
> by vacuum, not tuples that are ready to be used. I'm still rather
> confused,
> as this table is only modified via inserts.  No deletes or update
> operations
> are ever performed.  Logically (ie "I don't really know the truth")
> this
> table should have no free tuples or free space except for the
> remainder of
> the last allocated page.

I suspect that if a transaction rolls back, any inserts done in the
interim turn into dead tuples.

- John Burger
   MITRE


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

Предыдущее
От: Dick Kniep
Дата:
Сообщение: Re: Connected user in a triggerfunction
Следующее
От: Patrick Hatcher
Дата:
Сообщение: Re: Trigger question: ROW or STATEMENT?