Any optimizations to the join code in 7.1? - Mailing list pgsql-hackers

From Mike Mascari
Subject Any optimizations to the join code in 7.1?
Date
Msg-id 01C0CD51.BF740270.mascarm@mascari.com
Whole thread Raw
Responses Re: Any optimizations to the join code in 7.1?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hello.

I have a particular query which performs a 15-way join; I believe in 
normalization ;-). Under 7.0.3, using the defaults where GEQO is 
enabled after 11, the query (which returns 1 row) takes 10 seconds. 
With GEQO turned off, it takes 18 seconds. Naturally I intend to 
upgrade as soon as possible, but I looked through the change log and 
didn't see anything specific WRT large joins. I was wondering if any 
work had been done in that area for 7.1. I realize you can only 
squeeze so much blood from stone, but....

Thanks for any info,

Mike Mascari
mascarm@mascari.com



pgsql-hackers by date:

Previous
From: ncm@zembu.com (Nathan Myers)
Date:
Subject: Re: refusing connections based on load ...
Next
From: Alessio Bragadini
Date:
Subject: Comment about PostgreSQL on Epinions.com