On Thu, Aug 22, 2013 at 4:20 AM, 高健 <luckyjackgao@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
