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:46:59
Message-ID: 24033.1199486819@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
> On Fri, Jan 4, 2008 at  4:29 PM, in message <23789(dot)1199485772(at)sss(dot)pgh(dot)pa(dot)us>,
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote: 
>> Can't do much with this without seeing the table and view definitions
>> involved.
 
> Understood.  It was while I was putting that together that it
> struck me as familiar.  They are the same as in this thread.
> http://archives.postgresql.org/pgsql-performance/2007-10/msg00087.php

I don't see anything in that thread that shows the view definition
nor mentions the data types involved.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Kevin GrittnerDate: 2008-01-04 22:51:27
Subject: Re: OUTER JOIN performance regression remains in8.3beta4
Previous:From: Kevin GrittnerDate: 2008-01-04 22:44:27
Subject: Re: OUTER JOIN performance regression remains in8.3beta4

pgsql-patches by date

Next:From: Kevin GrittnerDate: 2008-01-04 22:51:27
Subject: Re: OUTER JOIN performance regression remains in8.3beta4
Previous:From: Kevin GrittnerDate: 2008-01-04 22:44:27
Subject: Re: OUTER JOIN performance regression remains in8.3beta4

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