Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Performance > Re: Replication...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 41 of 48 Topic 4027 of 4296
Post > Topic >>

Re: Replication Syatem

by meetgaurikanekar@[EMAIL PROTECTED] ("Gauri Kanekar") Apr 30, 2008 at 11:09 AM

------=_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--
 




 48 Posts in Topic:
Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-28 19:08:56 
Re: Replication Syatem
peterachilds@[EMAIL PROTE  2008-04-28 14:58:14 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-28 19:35:37 
Re: Replication Syatem
salmanb@[EMAIL PROTECTED]  2008-04-28 10:16:44 
Re: Replication Syatem
ajs@[EMAIL PROTECTED] (A  2008-04-28 12:22:43 
Re: Replication Syatem
bnichols@[EMAIL PROTECTED  2008-04-28 10:13:20 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-28 19:47:22 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-28 19:48:48 
Re: Replication Syatem
ajs@[EMAIL PROTECTED] (A  2008-04-28 12:23:45 
Re: Replication Syatem
gsmith@[EMAIL PROTECTED]   2008-04-28 13:39:39 
Re: Replication Syatem
radhika.sambamurti@[EMAIL  2008-04-28 16:58:59 
Re: Replication Syatem
Chris Browne <cbbrowne  2008-04-28 17:43:57 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-29 10:25:10 
Re: Replication Syatem
tgl@[EMAIL PROTECTED] (T  2008-04-29 01:20:04 
Re: Replication Syatem
Chris Browne <cbbrowne  2008-04-29 10:48:28 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-29 10:41:33 
Re: Replication Syatem
gsmith@[EMAIL PROTECTED]   2008-04-29 01:08:09 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-29 11:16:57 
Re: Replication Syatem
pgsql@[EMAIL PROTECTED]   2008-04-29 20:49:38 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-29 11:17:05 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-29 11:25:27 
Re: Replication Syatem
gsmith@[EMAIL PROTECTED]   2008-04-29 04:37:07 
Re: Replication Syatem
tgl@[EMAIL PROTECTED] (T  2008-04-29 10:16:02 
Re: Replication Syatem
vivek@[EMAIL PROTECTED]   2008-04-29 11:00:57 
Re: Replication Syatem
tgl@[EMAIL PROTECTED] (T  2008-04-30 11:02:39 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-29 16:35:40 
Re: Replication Syatem
alvherre@[EMAIL PROTECTED  2008-04-29 09:02:04 
Re: Replication Syatem
pgsql@[EMAIL PROTECTED]   2008-04-30 02:18:10 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-29 16:55:38 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-29 18:29:43 
Re: Replication Syatem
alvherre@[EMAIL PROTECTED  2008-04-29 09:03:14 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-29 18:39:39 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-29 18:42:40 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-29 18:46:00 
Re: Replication Syatem
stark@[EMAIL PROTECTED]   2008-04-29 09:48:31 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-30 10:59:53 
Re: Replication Syatem
heikki@[EMAIL PROTECTED]   2008-04-30 11:26:18 
Re: Replication Syatem
craig@[EMAIL PROTECTED]   2008-04-30 20:16:21 
Re: Replication Syatem
heikki@[EMAIL PROTECTED]   2008-04-30 14:35:29 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-30 11:07:35 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-30 11:09:56 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-30 12:13:11 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-30 12:19:04 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-30 12:55:30 
Re: Replication Syatem
tgl@[EMAIL PROTECTED] (T  2008-04-30 10:46:28 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-30 19:06:12 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-30 21:45:05 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-30 22:17:46 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Sep 8 2:39:14 CDT 2008.