From: Tomas Vondra <tv@fuzzy.cz>
To: pgsql-performance@postgresql.org
Subject: Re: Hot Standby performance issue
Date: Sat, 02 Nov 2013 20:33:53 +0100
Message-ID: <527553A1.6080006@fuzzy.cz> (raw)
In-Reply-To: <1382993820312-5776160.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>
<1382993820312-5776160.post@n5.nabble.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
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
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: tv@fuzzy.cz
Subject: Re: Hot Standby performance issue
In-Reply-To: <527553A1.6080006@fuzzy.cz>
* 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