From: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
---|---|
To: | sparikh <sparikh(at)ecotality(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Hot Standby performance issue |
Date: | 2013-10-20 16:03:19 |
Message-ID: | 1382284999.20481.YahooMailNeo@web162904.mail.bf1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
sparikh <sparikh(at)ecotality(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | sparikh | 2013-10-20 17:58:21 | Re: Hot Standby performance issue |
Previous Message | Tomas Vondra | 2013-10-20 00:20:52 | Re: Hot Standby performance issue |