Re: Hot Standby performance issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux