Re: Hot Standby performance issue

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