On Wed, Apr 30, 2008 at 11:09 AM, Gauri Kanekar <[EMAIL PROTECTED]> wrote: > relid | relname | n_tup_ins | n_tup_upd | n_tup_hot_upd | n_dead_tup > -------+----------------+-----------+-----------+---------------+------------ > 16461 | table1 | 0 | 8352496 | 5389 | 8351242 >
Hmm.. So indeed there are very few HOT updates. What is the fillfactor you are using for these tests ? If its much less than 100, the very low percentage of HOT updates would make me guess that you are updating one of the index columns. Otherwise at least the initial updates until you fill up the free space should be HOT. Thanks, Pavan -- Pavan Deolasee EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
