Jo,


> 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
> performance?

Have you checked the release notes?
http://www.postgresql.org/docs/8.4/static/release-8-4.html

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, ...)?


-hannes

In response to

• Postgres 8.3 vs. 8.4 - Query plans and performance at 2011-03-14 10:39:13 from Jo

Responses

• Re: Postgres 8.3 vs. 8.4 - Query plans and performance at 2011-03-14 14:48:03 from Jo
• Re: Postgres 8.3 vs. 8.4 - Query plans and performance at 2011-03-14 15:09:39 from Tom Lane

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