Re: Hot Standby performance issue

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