Performance degradation after upgrading to 9.0.2

vivekb · #1 (**permalink**) 04-21-11, 08:36

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.

rski · #2 (**permalink**) 04-28-11, 03:35

And the previous version was?

vivekb · #3 (**permalink**) 04-29-11, 09:56

Previous version was Postgres 8.4.3

rski · #4 (**permalink**) 05-01-11, 16:59

So not so far away version.

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

shammat · #5 (**permalink**) 05-01-11, 17:15

Please show us the query, the tables involved and the corresponding execution plans from the 8.4 and 9.0 version.

Internet Services

Web Development

Digital Marketing

Consumer Tech