Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2011
    Posts
    2

    Unhappy Unanswered: Performance degradation after upgrading to 9.0.2

    We have seen a 50% performance hit after upgrading to Postgres 9.0.2

    Are we missing any new configuration changes with 9.0.2 or does the new version need special performance tuning?

    Appreciate your time.

  2. #2
    Join Date
    Nov 2006
    Posts
    82
    And the previous version was?

  3. #3
    Join Date
    Apr 2011
    Posts
    2
    Previous version was Postgres 8.4.3

  4. #4
    Join Date
    Nov 2006
    Posts
    82
    So not so far away version.

    How did you recreate database after upgrade? Did you rebuild indexes and gather statistics?

  5. #5
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    Please show us the query, the tables involved and the corresponding execution plans from the 8.4 and 9.0 version.

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
  •