From: Kevin Grittner <kgrittn@ymail.com>
To: sparikh <sparikh@ecotality.com>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Hot Standby performance issue
Date: Sun, 20 Oct 2013 09:03:19 -0700 (PDT)
Message-ID: <1382284999.20481.YahooMailNeo@web162904.mail.bf1.yahoo.com> (raw)
In-Reply-To: <1382144016561-5775123.post@n5.nabble.com>
References: <1381869626548-5774673.post@n5.nabble.com>
<5261C20D.1020003@fuzzy.cz>
<1382144016561-5775123.post@n5.nabble.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
sparikh <sparikh@ecotality.com> wrote:
> PostgreSQL 9.1.1
You really should apply the fixes for bugs and security
vulnerabilities which are available. Some of those may address a
relevant performance problem.
http://www.postgresql.org/support/versioning/> the performance was good in September and somewhere in October it
> started slowing down. I guess it was gradual. There were no code
> change in the application or major change in the data volume.
We really need to see your configuration, along with a description
of the machine. One common cause for such a slowdown is not having
autovacuum configured to be aggressive enough. Another possible
cause is a transaction which has been left open for too long. Look
at pg_stat_activity and pg_prepared_xacts for xact_start or
prepared more than an hour old.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
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: kgrittn@ymail.com, sparikh@ecotality.com
Subject: Re: Hot Standby performance issue
In-Reply-To: <1382284999.20481.YahooMailNeo@web162904.mail.bf1.yahoo.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