pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: sparikh <sparikh@ecotality.com>
To: pgsql-performance@postgresql.org
Subject: Re: Hot Standby performance issue
Date: Mon, 28 Oct 2013 13:57:00 -0700 (PDT)
Message-ID: <1382993820312-5776160.post@n5.nabble.com> (raw)
In-Reply-To: <1382991814055-5776156.post@n5.nabble.com>
References: <1382396377294-5775349.post@n5.nabble.com>
	<5265B562.3040407@fuzzy.cz>
	<1382400045239-5775361.post@n5.nabble.com>
	<5266BD42.2030303@fuzzy.cz>
	<1382478627757-5775529.post@n5.nabble.com>
	<52670702.3030201@fuzzy.cz>
	<1382491400068-5775550.post@n5.nabble.com>
	<1382736171070-5775972.post@n5.nabble.com>
	<526BCEBA.3010102@fuzzy.cz>
	<1382991814055-5776156.post@n5.nabble.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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.


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



view thread (31+ messages)  latest in thread

Message-ID: <1382993820312-5776160.post@n5.nabble.com>
Permalink:  ../1382993820312-5776160.post@n5.nabble.com/
Also on:    postgresql.org/message-id/1382993820312-5776160.post@n5.nabble.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: sparikh@ecotality.com
  Subject: Re: Hot Standby performance issue
  In-Reply-To: <1382993820312-5776160.post@n5.nabble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox