Re: Replication Syatem

["Gauri Kanekar" <meetgaurikanekar(at)gmail(dot)com>]

 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 <pavan(dot)deolasee(at)gmail(dot)com> wrote:

On Wed, Apr 30, 2008 at 10:59 AM, Gauri Kanekar
<meetgaurikanekar(at)gmail(dot)com> 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