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

Re: JOIN performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dean Gibson (DB Administrator)" <postgresql3(at)ultimeth(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: JOIN performance
Date: 2004-09-21 05:19:33
Message-ID: 25938.1095743973@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-sql
"Dean Gibson (DB Administrator)" <postgresql3(at)ultimeth(dot)com> writes:
> It turns out that even when I removed the CASE statement from the VIEW, the 
> performance problem remained.  I had to remove the conditional as well from 
> the VIEW.

> cancel_date < expire_date AS canceled,

Yuck :-(

> Do you know why?  I'm running 7.3.4, by the way.

7.3 is even stupider than 7.4, is why ...

In 7.3 only a view whose targetlist consists of simple column references
can be pulled up into the nullable side of an outer join.

			regards, tom lane

In response to

Responses

pgsql-sql by date

Next:From: birdy edwardsDate: 2004-09-21 05:55:56
Subject: [ocpfree] Info Needed about OCA
Previous:From: Joe ConwayDate: 2004-09-21 04:44:02
Subject: Re: PL/pgSQL multidimension (matrix) array in function

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