Re: Nested loops are killing throughput

From: CG <cgg007(at)yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Nested loops are killing throughput
Date: 2006-09-20 18:10:42
Message-ID: 20060920181042.41071.qmail@web37901.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>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!

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Aaron Bono 2006-09-20 18:38:05 Re: Need a SQL to create sets of hobbies
Previous Message Aaron Bono 2006-09-20 17:24:09 Re: Dividing results from two tables with different time frames