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

RE: Any optimizations to the join code in 7.1?

From: Mike Mascari <mascarm(at)mascari(dot)com>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "'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 15:46:47
Message-ID: 01C0CF0F.BE00DAC0.mascarm@mascari.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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



Responses

pgsql-hackers by date

Next:From: Matthew KirkwoodDate: 2001-04-27 16:03:00
Subject: Archived redo logs / Managed recovery mode?
Previous:From: Dominic J. EidsonDate: 2001-04-27 15:39:10
Subject: Patch to include PAM support...

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