Re: Hot Standby performance issue

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

 



Table statistics I sent before were from primary. Following are from standby.

Index Tuples Fetched	25910277	
Tuples Inserted	0	
Tuples Updated	0	
Tuples Deleted	0	
Tuples HOT Updated	0	
Live Tuples	0	
Dead Tuples	0	
Heap Blocks Read	138482386	
Heap Blocks Hit	1059169445	
Index Blocks Read	4730561	
Index Blocks Hit	9702556	
Toast Blocks Read	1165	
Toast Blocks Hit	82	
Toast Index Blocks Read	85	
Toast Index Blocks Hit	3055	
Last Vacuum		
Last Autovacuum		
Last Analyze		
Last Autoanalyze		
Vacuum counter	0	
Autovacuum counter	0	
Analyze counter	0	
Autoanalyze counter	0	
Table Size	46 GB	
Toast Table Size	615 MB	
Indexes Size	20 GB



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Hot-Standby-performance-issue-tp5774673p5776160.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.


-- 
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