Re: Tupple statistics function

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Tupple statistics function
Дата
Msg-id 200109220526.f8M5Q2p00630@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Tupple statistics function  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Tupple statistics function
Список pgsql-hackers
> Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> > I have written a small function that show how many tuples are dead
> > etc. in a specified table.
> 
> Dead according to whose viewpoint?  Under MVCC this seems to be
> in the eye of the beholder...

You can know if the tuple is visible to other backends, or at least take
a good guess like VACUUM does.  Maybe he has coded that in there.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Tupple statistics function
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Tupple statistics function