> Can "b" be null in any of these tables? If not, then you can > rewrite your query to us NOT EXISTS and have the same semantics. > That will often be much faster.
Thanks, Kevin. No NULLs. It looks like it's a good deal slower than the LOJ version, but a good deal faster than the original. Since the equivalence of semantics is much easier to verify here, we may go with this (at least for the moment). --- Maciek Sakrejda | System Architect | Truviso 1065 E. Hillsdale Blvd., Suite 230 Foster City, CA 94404 (650) 242-3500 Main www.truviso.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
