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