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

Re: OUTER JOIN performance regression remains in 8.3beta4

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: OUTER JOIN performance regression remains in 8.3beta4
Date: 2008-01-04 22:29:32
Message-ID: 23789.1199485772@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
> There was a serious performance regression in OUTER JOIN planning
> going from 8.2.4 to 8.2.5.  I know Tom came up with some patches to
> mitigate the issues in 8.2.5, but my testing shows that problems
> remain in 8.3beta4.

Can't do much with this without seeing the table and view definitions
involved.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2008-01-04 22:40:22
Subject: Re: OUTER JOIN performance regression remains in 8.3beta4
Previous:From: Kevin GrittnerDate: 2008-01-04 22:16:53
Subject: Re: OUTER JOIN performance regression remains in8.3beta4

pgsql-patches by date

Next:From: Tom LaneDate: 2008-01-04 22:40:22
Subject: Re: OUTER JOIN performance regression remains in 8.3beta4
Previous:From: Kevin GrittnerDate: 2008-01-04 22:16:53
Subject: Re: OUTER JOIN performance regression remains in8.3beta4

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