| From: | sparikh <sparikh(at)ecotality(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Hot Standby performance issue |
| Date: | 2013-10-28 20:57:00 |
| Message-ID: | 1382993820312-5776160.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2013-10-28 21:58:15 | Problems with hash join over nested loop |
| Previous Message | sparikh | 2013-10-28 20:23:34 | Re: Hot Standby performance issue |