Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cmUhZ-0005Bk-Jh for pgsql-hackers@arkaria.postgresql.org; Sat, 11 Mar 2017 00:16:05 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cmUhZ-0004iT-6D for pgsql-hackers@arkaria.postgresql.org; Sat, 11 Mar 2017 00:16:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cmUhX-0004eC-Ne for pgsql-hackers@postgresql.org; Sat, 11 Mar 2017 00:16:03 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cmUhV-0002Yo-Lx for pgsql-hackers@postgresql.org; Sat, 11 Mar 2017 00:16:03 +0000 Received: from compute7.internal (compute7.nyi.internal [10.202.2.47]) by mailout.nyi.internal (Postfix) with ESMTP id 658F9209D3; Fri, 10 Mar 2017 19:16:00 -0500 (EST) Received: from frontend1 ([10.202.2.160]) by compute7.internal (MEProxy); Fri, 10 Mar 2017 19:16:00 -0500 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-sender:x-me-sender:x-sasl-enc:x-sasl-enc; s= smtpout; bh=Pqbcu22pbqu0bwgDOahryPba5LA=; b=C/M3Ti0DNZRoC3sxO0OJ ZrNmijTsWW+GnA0kLZJ3vHKadwM1ZkGI8f275wKuLeJDpoSdunRFY5i9IwOoEuNT N6iMlbl+1V0XEm8d8sv8zG+T9/buUfUFQJWfZI0SWd0xTA3t8IHMWdlTobmRIEFt CTMrzTw3OEc+FkYzUpNHw38= X-ME-Sender: X-Sasl-enc: a7MwUXGGlmssHLBVwizHb/HahqJ/MUSF/Ysp+/QlaJB/ 1489191360 Received: from april.local (c-73-13-66-39.hsd1.pa.comcast.net [73.13.66.39]) by mail.messagingengine.com (Postfix) with ESMTPA id 09BEE7E807; Fri, 10 Mar 2017 19:15:59 -0500 (EST) Subject: Re: WIP: Faster Expression Processing v4 To: Andres Freund References: <20161206034955.bh33paeralxbtluv@alap3.anarazel.de> <20170209003312.rr7atqepgbrf4xqe@alap3.anarazel.de> <20170307030137.lpo4japv5oqgbqpz@alap3.anarazel.de> <2950633b-f0f5-aba1-fb97-99d096f29da0@2ndquadrant.com> <20170310194021.ek4bs4bl2khxkmll@alap3.anarazel.de> Cc: pgsql-hackers@postgresql.org, Heikki Linnakangas , Doug Doole From: Peter Eisentraut Organization: 2ndQuadrant Message-ID: Date: Fri, 10 Mar 2017 19:15:59 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:45.0) Gecko/20100101 Thunderbird/45.7.1 MIME-Version: 1.0 In-Reply-To: <20170310194021.ek4bs4bl2khxkmll@alap3.anarazel.de> Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 3/10/17 14:40, Andres Freund wrote: > I'd really like to get it in. The performance improvements on its own > are significant, and it provides the basis for significantly larger > improvements again (JIT) - those followup improvements are large patches > again though, so I'd rather not do all of that next cycle. > > My next step (over the weekend) is to add tests to execQual.c to get it > a good chunk closer to 100% test coverage, and then do the same for the > new implementation (there's probably very little additional tests needed > after the conversion). Given all tests pass before/after, and there's a > lot of them, I think we can have a reasonable confidence of a low bug > density. That seems like a plan, but now would probably be a good time for some other hackers to take note of this proposal. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers