On Thu, Aug 22, 2013 at 4:20 AM, 高健 <luckyjackgao@gmail.com> wrote:
> according to a table, How many tuples are heap only tuples , and how many
> are not?
>
I believe there are not "hot tuples", a tuple is updated using HOT
depending on the indexes defined and the type of update itself.
Anyway, you can get an information of how many tuples have been
hot-touched via pg_stat_user_tables.n_tup_hot_upd
> And also , Is there any options which can influence HOT occurrance?
The storage setting (fillfactor) will change the hotness of your
tables, but of course this depends on the workload.
Luca