X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 9E0F59FB1F2 for ; Wed, 20 Sep 2006 15:10:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 15262-02 for ; Wed, 20 Sep 2006 18:10:44 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web37901.mail.mud.yahoo.com (web37901.mail.mud.yahoo.com [209.191.91.163]) by postgresql.org (Postfix) with SMTP id 157C09FA612 for ; Wed, 20 Sep 2006 15:10:43 -0300 (ADT) Received: (qmail 41073 invoked by uid 60001); 20 Sep 2006 18:10:42 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=OKnYR5NqckiufCAY/QNI8I5KDQLwdxow9mEoNvl9ztuqBO28NCwpetx5Io3Jd/HlPJDXfh+DA9gGROvv2ZzUMjK+e6iic5ks9RB/30fX5QgMdJtcM4wW+GFleHwadAbEPGVqvwAeUJpnoxuzFaC7U66EQ6HFq/isQRi3uf+cFqk= ; Message-ID: <20060920181042.41071.qmail@web37901.mail.mud.yahoo.com> Received: from [216.173.173.66] by web37901.mail.mud.yahoo.com via HTTP; Wed, 20 Sep 2006 11:10:42 PDT Date: Wed, 20 Sep 2006 11:10:42 -0700 (PDT) From: CG Reply-To: CG Subject: Re: Nested loops are killing throughput To: Tom Lane Cc: pgsql-sql@postgresql.org In-Reply-To: <15725.1158693309@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.355 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: *** X-Archive-Number: 200609/140 X-Sequence-Number: 26351 >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!