> we have performance problems running several queries pon postgres 8.4 .
> Using the previous version (8.3) our queries performs well
> (The queries are quite complex, consisting of several sub-queries and
> various spatial functions).
> Are there some major changes from 8.3 to 8.4 that cause this bad
Have you checked the release notes?
If you can, I'd also suggest that you show the execution plans on
8.3/8.4 on the list.
One more thing: did you also check the server configuration (work_mem, ...)?
In response to
pgsql-general by date
|Next:||From: Merlin Moncure||Date: 2011-03-14 13:25:03|
|Subject: Re: Values larger than 1/3 of a buffer page cannot be indexed.|
|Previous:||From: Jo||Date: 2011-03-14 10:39:13|
|Subject: Postgres 8.3 vs. 8.4 - Query plans and performance|