relid | relname | n_tup_ins | n_tup_upd | n_tup_hot_upd | n_dead_tup -------+----------------+-----------+-----------+---------------+------------ 16461 | table1 | 0 | 8352496 | 5389 | 8351242
On Wed, Apr 30, 2008 at 11:07 AM, Pavan Deolasee <[EMAIL PROTECTED]> wrote: > On Wed, Apr 30, 2008 at 10:59 AM, Gauri Kanekar > <[EMAIL PROTECTED]> wrote: > > HOT doesn't seems to be working in our case. > > > > Can you please post output of the following query ? > > SELECT relid, relname, n_tup_ins, n_tup_upd, n_tup_hot_upd, n_dead_tup > from pg_stat_user_tables WHERE relname = 'table1'; > > > Thanks, > Pavan > > -- > Pavan Deolasee > EnterpriseDB http://www.enterprisedb.com > -- Regards Gauri
