Re: Hot Standby performance issue - Mailing list pgsql-performance

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.