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