Search Postgresql Archives

Query Slowdown after upgrade from 9.1.1 to 9.1.2

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I upgraded to v9.1.2 a couple of days ago.

Some of my queries are taking noticeably longer.  Some of the slower ones would max out at about 45 seconds before.  Now they are maxing out at almost 2 minutes.

The only change I made to postgresql.conf was geqo_effort = 10 and this was long before this upgrade.

I can provide more info if necessary.  The queries involve join quite a few tables and views together and also a window query for totals.

Any ideas?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux