Postgres Pro
Downloads
Home   >   mailing lists

Re: Should the optimizer see this? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Should the optimizer see this?
Date
Msg-id 2522.1106793080@sss.pgh.pa.us
Whole thread Raw
In response to Should the optimizer see this?  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
List pgsql-performance
Tree view 
Ron Mayer <rm_pg@cheapcomplexdevices.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

pgsql-performance by date:

Previous
From: Ron Mayer
Date:
Subject: Should the optimizer see this?
Next
From: Josh Berkus
Date:
Subject: Re: Ideal disk setup for Postgresql 7.4?