X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id F312C5E46EC for ; Mon, 30 Aug 2004 04:38:47 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79559-10 for ; Mon, 30 Aug 2004 07:38:38 +0000 (GMT) Received: from web41108.mail.yahoo.com (web41108.mail.yahoo.com [66.218.93.24]) by svr1.postgresql.org (Postfix) with SMTP id 75B475E46D2 for ; Mon, 30 Aug 2004 04:38:40 -0300 (ADT) Message-ID: <20040830073841.30957.qmail@web41108.mail.yahoo.com> Received: from [210.230.185.241] by web41108.mail.yahoo.com via HTTP; Mon, 30 Aug 2004 00:38:41 PDT Date: Mon, 30 Aug 2004 00:38:41 -0700 (PDT) From: Mr Pink Subject: Re: Why does a simple query not use an obvious index? To: Tom Lane Cc: pgsql-performance@postgresql.org In-Reply-To: <18966.1093832636@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/439 X-Sequence-Number: 8075 Yeah! Bind variable peeking is great news. I did actually read the guff, but forgot about that. Version 8 is looking great on paper, I hope I'll get a chance to play wth it soon. I can kind of appreciate your point about peeking stable functions, however, I would have thought that if it was possible to do for bind variables (which could change many times in a transaction) then it would make even more sense for a stable function which doesn't change for the life of the transaction. No doubt this is an oversimplification the situation. regards Mr Pink _______________________________ Do you Yahoo!? Win 1 of 4,000 free domain names from Yahoo! Enter now. http://promotions.yahoo.com/goldrush