Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VcgxO-0006a4-3g for pgsql-performance@arkaria.postgresql.org; Sat, 02 Nov 2013 19:34:02 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VcgxN-0001yX-Ek for pgsql-performance@arkaria.postgresql.org; Sat, 02 Nov 2013 19:34:01 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VcgxM-0001yR-Ju for pgsql-performance@postgresql.org; Sat, 02 Nov 2013 19:34:00 +0000 Received: from mail.gransy.com ([2001:1528:137::f1]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VcgxJ-0001Mg-EE for pgsql-performance@postgresql.org; Sat, 02 Nov 2013 19:34:00 +0000 Received: from antispam.gransy.com (antispam.gransy.com [77.78.104.124]) by mail.gransy.com (Postfix) with ESMTP id 16D28508C47 for ; Sat, 2 Nov 2013 20:33:54 +0100 (CET) X-Virus-Scanned: G-Hosting.cz + Station.cz + Klenot.cz + Subreg.cz amavisd-new at antispam.gransy.com Received: from mail.gransy.com ([82.208.44.189]) by antispam.gransy.com (antispam.gransy.com [77.78.104.124]) (amavisd-new, port 10024) with ESMTP id ybnFnKvXegQm for ; Sat, 2 Nov 2013 20:34:05 +0100 (CET) Received: by mail.gransy.com (Postfix, from userid 5000) id D5BB5508C4A; Sat, 2 Nov 2013 20:33:53 +0100 (CET) Received: from [192.168.1.227] (ip-78-45-139-138.net.upcbroadband.cz [78.45.139.138]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.gransy.com (Postfix) with ESMTPSA id C1385508C45 for ; Sat, 2 Nov 2013 20:33:53 +0100 (CET) Message-ID: <527553A1.6080006@fuzzy.cz> Date: Sat, 02 Nov 2013 20:33:53 +0100 From: Tomas Vondra User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.0 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Hot Standby performance issue 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> <1382993820312-5776160.post@n5.nabble.com> In-Reply-To: <1382993820312-5776160.post@n5.nabble.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) 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 On 28.10.2013 21:57, sparikh wrote: > 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 Why have you skipped some of the rows posted for primary? E.g. the sequential scans info? Anyway, I think new data are not going to help us as the issue resolved somehow, so the current data are unlikely to show the original cause. You can either wait whether it happens again, or dig in the logs to see if / why the autovacuum was not running on this table. Tomas -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance