Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2010

    Unanswered: Postgres database speed


    I am using postgesql 8.1.9 version on Linux and 64 bit platform. My database size is around 25 GB. Lot of updates, inserted and views transactions are happening through my application. After few days database query execution taking lot of times. Its affect my application.

    If I take a DB dump and drop the db and restore it back then for a few days database speed has increases but then after some days database query execution speed is going down.

    Is any other way to fix the problem.


  2. #2
    Join Date
    Nov 2003
    Provided Answers: 23
    Make sure autovaccum is turned on and configured properly

    Check out this page:

    But you should upgrade to a supported release (e.g. 8.4) as soon as possible. 8.1 will no longer be supported as of November

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts