I just upgraded with pg_dump/restore from PostgreSQL 8.3.11 to 8.4.4 but
I'm having major performance problems with a query with many left joins.
Problem is that costs are now very, very, very high (was ok in 8.3).
Analyze has been done. Indexes are of course there.
-> Merge Left Join
Merge Cond: (l.id = d2000903.fk_id)
Details with execution plan can be found at:
I know that the data model is key/value pairs but it worked well in 8.3. I
need this flexibility.
pgsql-performance by date
|Next:||From: Scott Marlowe||Date: 2010-08-30 07:00:28|
|Subject: Re: Major performance problem after upgrade from 8.3 to 8.4|
|Previous:||From: Greg Smith||Date: 2010-08-30 05:01:10|
|Subject: Re: Performance on new 64bit server compared to my 32bit