RE: [HACKERS] Any optimizations to the join code in 7.1?
Sorry for the delay in the response. It took be a day to get everything upgraded to 7.1. To restate the problem - in 7.0 with GEQO enabled, a 15-way join took 10 seconds. With GEQO disabled it took 18 seconds. 7.1 out of the box took only 2 seconds! I was amazed and shocked at this damned impressive improvement in planning speeduntil I actually used the explicit JOIN syntax described in 11.2. Instanteous results! Instantaneous. Thanks a bunch, (still in shock) Mike Mascari [EMAIL PROTECTED] -Original Message- From: Tom Lane [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 12:42 PM To: [EMAIL PROTECTED] Cc: '[EMAIL PROTECTED]' Subject:Re: [HACKERS] Any optimizations to the join code in 7.1? Mike Mascari [EMAIL PROTECTED] writes: I have a particular query which performs a 15-way join; You should read http://www.postgresql.org/devel-corner/docs/postgres/explicit-join s.html regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Any optimizations to the join code in 7.1?
You can thank Tom Lane for most/all of our optimization improvements. Sorry for the delay in the response. It took be a day to get everything upgraded to 7.1. To restate the problem - in 7.0 with GEQO enabled, a 15-way join took 10 seconds. With GEQO disabled it took 18 seconds. 7.1 out of the box took only 2 seconds! I was amazed and shocked at this damned impressive improvement in planning speeduntil I actually used the explicit JOIN syntax described in 11.2. Instanteous results! Instantaneous. Thanks a bunch, (still in shock) Mike Mascari [EMAIL PROTECTED] -Original Message- From: Tom Lane [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 12:42 PM To: [EMAIL PROTECTED] Cc: '[EMAIL PROTECTED]' Subject: Re: [HACKERS] Any optimizations to the join code in 7.1? Mike Mascari [EMAIL PROTECTED] writes: I have a particular query which performs a 15-way join; You should read http://www.postgresql.org/devel-corner/docs/postgres/explicit-join s.html regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] Any optimizations to the join code in 7.1?
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 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Any optimizations to the join code in 7.1?
Mike Mascari [EMAIL PROTECTED] writes: I have a particular query which performs a 15-way join; You should read http://www.postgresql.org/devel-corner/docs/postgres/explicit-joins.html regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])