Re: Should the optimizer see this?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Should the optimizer see this?
Date: 2005-01-27 02:31:20
Message-ID: 2522.1106793080@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com> writes:
> Should the optimizer have found this optimization?

I can't get excited about it. Joining on a column that's mostly nulls
doesn't seem like a common thing to do.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2005-01-27 02:49:14 Re: Ideal disk setup for Postgresql 7.4?
Previous Message Ken Egervari 2005-01-27 02:17:23 Performance problem with semi-large tables