Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vats3-0002DT-Rp for pgsql-performance@arkaria.postgresql.org; Mon, 28 Oct 2013 20:57:08 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Vats3-0003aT-BM for pgsql-performance@arkaria.postgresql.org; Mon, 28 Oct 2013 20:57:07 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vats2-0003YT-0j for pgsql-performance@postgresql.org; Mon, 28 Oct 2013 20:57:06 +0000 Received: from sam.nabble.com ([216.139.236.26]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vatrx-0000fI-LL for pgsql-performance@postgresql.org; Mon, 28 Oct 2013 20:57:04 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1Vatrw-0005K0-AK for pgsql-performance@postgresql.org; Mon, 28 Oct 2013 13:57:00 -0700 Date: Mon, 28 Oct 2013 13:57:00 -0700 (PDT) From: sparikh To: pgsql-performance@postgresql.org Message-ID: <1382993820312-5776160.post@n5.nabble.com> 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> Subject: Re: Hot Standby performance issue MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: 1.1 (+) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org 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