sparikh <sparikh@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
