Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id F3B8364FD64 for ; Wed, 19 Nov 2008 09:11:54 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 53261-05 for ; Wed, 19 Nov 2008 09:11:51 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by mail.postgresql.org (Postfix) with ESMTP id B4B7164FCC9 for ; Wed, 19 Nov 2008 09:11:51 -0400 (AST) Received: from perhan.alvh.no-ip.org (200-126-106-210.bk7-dsl.surnet.cl [200.126.106.210]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id mAJDGMEe027742 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 19 Nov 2008 05:16:25 -0800 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id E5D9447CC6; Wed, 19 Nov 2008 10:11:43 -0300 (CLST) Date: Wed, 19 Nov 2008 10:11:43 -0300 From: Alvaro Herrera To: =?utf-8?B?0JLRltGC0LDQu9GW0Lkg0KLQuNC80YfQuNGI0LjQvQ==?= Cc: pgsql-performance@postgresql.org Subject: Re: PostgreSQL NOT IN performance Message-ID: <20081119131143.GD3764@alvh.no-ip.org> References: <331e40660811190351n6bde6caic5fd8cc3a0f777d2@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <331e40660811190351n6bde6caic5fd8cc3a0f777d2@mail.gmail.com> User-Agent: Mutt/1.5.18 (2008-05-17) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Wed, 19 Nov 2008 05:16:26 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200811/162 X-Sequence-Number: 31893 Віталій Тимчишин escribió: > So the question is: I am willing to participate in postgresql development > because it may be easier to fix planner then to rewrite all my queries :). > How can I? (I mean to work on query planner enhancements by providing new > options of query rewrite, not to work on other thing nor on enhancing > planner in other ways, like better estimations of known plans). http://wiki.postgresql.org/wiki/Submitting_a_Patch http://wiki.postgresql.org/wiki/Developer_FAQ -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support