Skip site navigation (1) Skip section navigation (2)

Re: Any optimizations to the join code in 7.1?

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 (view raw or flat)
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

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2001-04-27 17:44:46
Subject: Re: The new, the improved ... FTS Searching of Mailing List Archives
Previous:From: Bruce MomjianDate: 2001-04-27 17:41:13
Subject: Re: Patch to include PAM support...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group