Re: Replication Syatem

Поиск
Список
Период
Сортировка
От Gauri Kanekar
Тема Re: Replication Syatem
Дата
Msg-id 7e4ba9550804292239n668b1f01v59ad7ac6ca9e092b@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Replication Syatem  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
Ответы Re: Replication Syatem
Список 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.deolasee@gmail.com> wrote:
On Wed, Apr 30, 2008 at 10:59 AM, Gauri Kanekar
<meetgaurikanekar@gmail.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

В списке pgsql-performance по дате отправления: