Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cnXh7-0005fz-NE for pgsql-hackers@arkaria.postgresql.org; Mon, 13 Mar 2017 21:39:57 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cnXh6-0006xB-I6 for pgsql-hackers@arkaria.postgresql.org; Mon, 13 Mar 2017 21:39:56 +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 1cnXfc-0004Gr-RH for pgsql-hackers@postgresql.org; Mon, 13 Mar 2017 21:38:24 +0000 Received: from mail-wr0-x232.google.com ([2a00:1450:400c:c0c::232]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cnXfZ-000289-Kq for pgsql-hackers@postgresql.org; Mon, 13 Mar 2017 21:38:24 +0000 Received: by mail-wr0-x232.google.com with SMTP id g10so112397713wrg.2 for ; Mon, 13 Mar 2017 14:38:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=subject:to:references:cc:from:message-id:date:user-agent :mime-version:in-reply-to:content-transfer-encoding; bh=MwNIyUH4A7BlFZ0Tx47+xt48a+++jnHM5wGMwozZjUk=; b=UdNRTIaQiUkbt+aHiaOyGf0PkYk0AdJaLkD3eC0z8YAOnG6hU/gEEiIACxpmcVfiYB bU1LbdFOmIPXB9lDRYfm8mgDEQg7ieTeiNSF8MgaiAdiGEvIeGqoK4GkpDNtsJfRZBkU 8Sc6dTyXM/F6BQRI9fUxLNXBmGDqqxQwW/18+aUb6/s8ojK+ZCs35yvJv4LrcDkygIz6 dtxsrYULN1ou78+j2ZwH0k1ONvjwmX3ZAnd7tbp8AyKwX4FAbf+vSLM74jMxhEZUSKd/ e1erARmrw9zaKJEidGRbFB9IgtideC2+vr4mEMcCzRKQaIZY7RSbyFGBtZ95Vu0RObQr 6M5Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:cc:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding; bh=MwNIyUH4A7BlFZ0Tx47+xt48a+++jnHM5wGMwozZjUk=; b=MwkIH9wA7cUS+tcteCYN9rV8SIfkeEKkhJWtJf7XK3g+5t2SsCFgJmT3gPNk2qybsg fmoUkiEzddA9LGwEvUPvEHdpkSkflvCHmDuyTJzJscsuE/x6ABgFD4K+LQhEtn6m0Uup 3xhZdoBY1oCVyb42h0xZsam8TQgWM/yt4sK1ziT6Np3Ia3tDClPd4fRRTTCMrfAEQOAq 0ASHnfyBHVgycPTOeORIk1OGwtwBZ8gr7GmOaRok92N//O4crRtlKJziM5li8irutU1L M8PBfCnrzhKBwgiM0+YeEyWg53FJ5Nga/lAHJFIcgKJ1XDsSsClPEmErF05qgcZLGunr ZS4A== X-Gm-Message-State: AMke39nPkUzyJy2SbZK5Xx0kCslSyqh5vaUvYDgh1Aot8ALFq2mN3eCYYEDjjnFsF9EcvwgTzhqNS8mbduPq9IwKQo/uQrQG84Z4IkaI6ZFswV7s8Rbb5qvOpLPdw243tw+xdHWY7ZJEvUISB9LZUpOHY00NFPLFORCejaN6wAtJJEVXf9YcuXisFyhZgO/59+pfeyFtkasM X-Received: by 10.223.176.217 with SMTP id j25mr32104194wra.8.1489441098710; Mon, 13 Mar 2017 14:38:18 -0700 (PDT) Received: from [10.137.2.17] (ip-89-177-46-65.net.upcbroadband.cz. [89.177.46.65]) by smtp.gmail.com with ESMTPSA id o15sm12831011wmd.10.2017.03.13.14.38.17 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 13 Mar 2017 14:38:17 -0700 (PDT) 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> <2090fd00-4dec-7b42-f700-64308958504c@2ndquadrant.com> <20170313080351.4g5oubxcj4xj5y7t@alap3.anarazel.de> Cc: pgsql-hackers@postgresql.org From: Tomas Vondra Message-ID: Date: Mon, 13 Mar 2017 22:37:51 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.4.0 MIME-Version: 1.0 In-Reply-To: <20170313080351.4g5oubxcj4xj5y7t@alap3.anarazel.de> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) 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 03/13/2017 09:03 AM, Andres Freund wrote: > Hi, > > On 2017-03-12 05:40:51 +0100, Tomas Vondra wrote: >> I wanted to do a bit of testing and benchmarking on this, but 0004 seems to >> be a bit broken. > > Well, "broken" in the sense that it's already outdated, because other > stuff that got merged. > Yes, that's what I meant. Sorry for not being quite clear. > >> The patch does not apply anymore - there are some conflicts >> in execQual.c, but I think I fixed those. But then I ran into a bunch of >> compile-time errors, because some of the executor nodes still reference bits >> that were moved elsewhere. > > Updated patch attached. Note that this patch has two changes I've not > yet evaluated performance-wise. > And which are those? I plan to do a bit of testing / benchmarking on this later this week, depending on other testing already happening on my machine. regards -- Tomas Vondra 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