From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | "mascarm(at)mascari(dot)com" <mascarm(at)mascari(dot)com> |
Cc: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Any optimizations to the join code in 7.1? |
Date: | 2001-04-27 17:42:05 |
Message-ID: | 200104271742.f3RHg5A17580@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
> speed....until I actually used the explicit JOIN syntax described in
> 11.2. Instanteous results! Instantaneous.....
>
> Thanks a bunch,
> (still in shock)
>
> Mike Mascari
> mascarm(at)mascari(dot)com
>
> -----Original Message-----
> From: Tom Lane [SMTP:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Wednesday, April 25, 2001 12:42 PM
> To: mascarm(at)mascari(dot)com
> Cc: 'pgsql-hackers(at)postgresql(dot)org'
> Subject: Re: [HACKERS] Any optimizations to the join code in 7.1?
>
> Mike Mascari <mascarm(at)mascari(dot)com> 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 majordomo(at)postgresql(dot)org)
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-04-27 17:44:46 | Re: The new, the improved ... FTS Searching of Mailing List Archives |
Previous Message | Bruce Momjian | 2001-04-27 17:41:13 | Re: Patch to include PAM support... |