Re: JOIN performance - Mailing list pgsql-sql

From Greg Stark
Subject Re: JOIN performance
Date
Msg-id 87oejzeaw2.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: JOIN performance  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: raise is not working
Next
From: Tom Lane
Date:
Subject: Re: raise is not working