Benjamin Krajmalnik wrote: > Rajesh, > > I had a similar situation a few weeks ago whereby performance all of a > sudden decreased. > The one tunable which resolved the problem in my case was increasing the > number of checkpoint segments. > After increasing them, everything went back to its normal state.
Did you get a db server log message suggesting in increasing that setting? I hope so. -- Bruce Momjian <[email protected]> http://momjian.us EnterpriseDB http://enterprisedb.com + None of us is going to be here forever. + -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
