[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] JOIN performance
From:       Greg Stark <gsstark () mit ! edu>
Date:       2004-09-21 18:26:37
Message-ID: 87oejzeaw2.fsf () stark ! xeocode ! com
[Download RAW message or body]


Tom Lane <tgl@sss.pgh.pa.us> writes:

> Fixing this properly is a research project, and I haven't thought of any
> quick-and-dirty hacks that aren't too ugly to consider :-(

Just thinking out loud here. Instead of trying to peek inside the CASE
couldn't the optimizer just wrap the non-strict expression in a conditional
that tests whether the row was found?


-- 
greg


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
[prev in list] [next in list] [prev in thread] [next in thread]