From: CG <cgg007@yahoo.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: Nested loops are killing throughput
Date: Wed, 20 Sep 2006 11:10:42 -0700 (PDT)
Message-ID: <20060920181042.41071.qmail@web37901.mail.mud.yahoo.com> (raw)
In-Reply-To: <15725.1158693309@sss.pgh.pa.us>
>Is that the one off gborg? It's broken because the equality function is
>marked volatile, and so the planner is afraid to try to use it for
>merging or hashing. (It's also not marked strict, which means you can
>trivially crash the backend by passing it a null ...)
Tom, you are a genius. I changed the supporting functions and started getting what I expected.
You were right on the money and saved my bacon.
I don't say it often enough: Thanks!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: cgg007@yahoo.com, tgl@sss.pgh.pa.us
Subject: Re: Nested loops are killing throughput
In-Reply-To: <20060920181042.41071.qmail@web37901.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox