Re: Replication Syatem

------=_Part_6282_26736668.1209533996196
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

 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.deolasee@[EMAIL PROTECTED]
>
wrote:

> On Wed, Apr 30, 2008 at 10:59 AM, Gauri Kanekar
> <meetgaurikanekar@[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

------=_Part_6282_26736668.1209533996196
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

&nbsp;relid |&nbsp;&nbsp;&nbsp; relname&nbsp;&nbsp;&nbsp;&nbsp; |
n_tup_ins | n_tup_upd | n_tup_hot_upd |
n_dead_tup<br>-------+----------------+-----------+-----------+---------------+------------<br>&nbsp;16461
| table1 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;
8352496 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5389
|&nbsp;&nbsp;&nbsp; 8351242<br>
<br><br><div class="gmail_quote">On Wed, Apr 30, 2008 at 11:07 AM, Pavan
Deolasee &lt;<a
href="mailto:pavan.deolasee@[EMAIL PROTECTED]
">pavan.deolasee@[EMAIL PROTECTED]
>&gt;
wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid
rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">On Wed, Apr 30, 2008 at 10:59 AM, Gauri Kanekar<br>
&lt;<a
href="mailto:meetgaurikanekar@[EMAIL PROTECTED]
">meetgaurikanekar@[EMAIL PROTECTED]
>&gt;
wrote:<br>
&gt; HOT doesn&#39;t seems to be working in our case.<br>
&gt;<br>
<br>
</div>Can you please post output of the following query ?<br>
<br>
SELECT relid, relname, n_tup_ins, n_tup_upd, n_tup_hot_upd, n_dead_tup<br>
from pg_stat_user_tables WHERE relname = &#39;table1&#39;;<br>
<br>
<br>
Thanks,<br>
Pavan<br>
<br>
--<br>
<font color="#888888">Pavan Deolasee<br>
</font><div><div></div><div class="Wj3C7c">EnterpriseDB &nbsp; &nbsp; <a
href="http://www.enterprisedb.com"
target="_blank">http://www.enterprisedb.com</a><br>
</div></div></blockquote></div><br><br clear="all"><br>--
<br>Regards<br>Gauri

------=_Part_6282_26736668.1209533996196--