Re: How to know detailed information about HOT(Heap-Only Tuples)?

Поиск
Список
Период
Сортировка
От 高健
Тема Re: How to know detailed information about HOT(Heap-Only Tuples)?
Дата
Msg-id CAL454F2b+mqhJrEJZgHhZcLr6V1UmJ=JUCwh0POWPtRh_YSMRg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to know detailed information about HOT(Heap-Only Tuples)?  (Adrian Klaver <adrian.klaver@gmail.com>)
Список pgsql-general
Hi:

Thank you  all for kindly replying.

I think that I need this:   pg_stat_user_tables.n_tup_hot_upd 

And  Adrian's information is a pretty good material  for me to understand the internal.


Best regards



2013/8/22 Adrian Klaver <adrian.klaver@gmail.com>
On 08/21/2013 07:20 PM, 高健 wrote:
Hi:

I have heard that Heap-Only Tuples is introduce from 8.3.
And I  am searching information for it.

How can I get a  detailed information of HOT?

http://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/access/heap/README.HOT;hb=HEAD


For example:
according to  a table, How many tuples are heap only tuples , and how
many are not?

And also , Is there any options which can influence HOT occurrance?

Best Regards


--
Adrian Klaver
adrian.klaver@gmail.com

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

Предыдущее
От: Don Parris
Дата:
Сообщение: Re: Locale Issue
Следующее
От: 高健
Дата:
Сообщение: What is the relationship between checkpoint and wal