Re: JOIN performance

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Dean Gibson (DB Administrator)" <postgresql3(at)ultimeth(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: JOIN performance
Date: 2004-09-21 18:26:37
Message-ID: 87oejzeaw2.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Mischa Sandberg 2004-09-21 22:16:24 Re: COUNT(*) to find records which have a certain number of dependencies
Previous Message Josh Berkus 2004-09-21 17:53:27 Re: raise is not working