From: | Tomas Vondra <tv(at)fuzzy(dot)cz> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Hot Standby performance issue |
Date: | 2013-10-22 23:09:51 |
Message-ID: | 526705BF.2080506@fuzzy.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On 22.10.2013 23:41, sparikh wrote:
>>From Primary:
>
> relname relpages
> pg_toast_17673 1812819
> pg_toast_17594 161660
> pg_toast_17972 121902
> pg_toast_17587 77190
> pg_toast_18537 29108
> pg_toast_17578 26638
> pg_toast_17673_index 19984
> pg_toast_17868 14911
> pg_toast_17594_index 2208
> pg_toast_1072246 1922
> pg_toast_17587_index 1510
> pg_toast_17972_index 1399
> pg_statistic 911
> pg_toast_18694 883
> pg_toast_17578_index 375
> pg_attribute 336
> pg_toast_16475 332
> pg_toast_18537_index 321
> pg_proc 233
> pg_depend_depender_index 176
>
>>From Secondary :
> ============
> relname relpages
> pg_toast_17673 1812819
> pg_toast_17594 161660
> pg_toast_17972 121902
> pg_toast_17587 77190
> pg_toast_18537 29108
> pg_toast_17578 26638
> pg_toast_17673_index 19984
> pg_toast_17868 14911
> pg_toast_17594_index 2208
> pg_toast_1072246 1922
> pg_toast_17587_index 1510
> pg_toast_17972_index 1399
> pg_statistic 911
> pg_toast_18694 883
> pg_toast_17578_index 375
> pg_attribute 336
> pg_toast_16475 332
> pg_toast_18537_index 321
> pg_proc 233
> pg_depend_depender_index 176
>
> Yes, result looks same both on primary and standby.
Yes. And it also shows that the really interesting tables (e.g.
pg_class) are not bloated.
Tomas
From | Date | Subject | |
---|---|---|---|
Next Message | Tomas Vondra | 2013-10-22 23:15:14 | Re: Hot Standby performance issue |
Previous Message | sparikh | 2013-10-22 21:50:27 | Re: Hot Standby performance issue |