| From: | "Gauri Kanekar" <meetgaurikanekar(at)gmail(dot)com> |
|---|---|
| To: | "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com> |
| Cc: | "Shane Ambler" <pgsql(at)sheeky(dot)biz>, "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "Greg Smith" <gsmith(at)gregsmith(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Replication Syatem |
| Date: | 2008-04-30 05:39:56 |
| Message-ID: | 7e4ba9550804292239n668b1f01v59ad7ac6ca9e092b@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Len Shapiro | 2008-04-30 06:32:18 | Re: Understanding histograms |
| Previous Message | Pavan Deolasee | 2008-04-30 05:37:35 | Re: Replication Syatem |