Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iAmov-0008RJ-I8 for pgsql-hackers@arkaria.postgresql.org; Thu, 19 Sep 2019 03:09:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iAmot-0003aL-Vo for pgsql-hackers@arkaria.postgresql.org; Thu, 19 Sep 2019 03:09:23 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1iAmot-0003a7-IB for pgsql-hackers@lists.postgresql.org; Thu, 19 Sep 2019 03:09:23 +0000 Received: from mail-qk1-x744.google.com ([2607:f8b0:4864:20::744]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iAmoh-0003PQ-RG for pgsql-hackers@postgresql.org; Thu, 19 Sep 2019 03:09:22 +0000 Received: by mail-qk1-x744.google.com with SMTP id w2so1829399qkf.2 for ; Wed, 18 Sep 2019 20:09:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=TitDk0G3DHHY3wX+No6Sg8j95pSP3vx2g2tB+CKNJZw=; b=kJwMVnIozYQWoUT6+Q4GCokQz4XCyNfIoPav5Hd0FcpJ0EyLrhrZDF6S8vbDuUQDC1 +9eErQZGm02pqlJ66b2sjR9JJMk8Gw9dyTajEO4nWksIv3HeuWIIiOp3AkazRCiGtMfE HtP1TLs4OFDl995RtVNwI9PqnaUSddRo/CXGCrbfcL1/yta+OEzvHYtOl1Ez/vkkoCDG IQmM8K2ISgu7HW7Eh9n2vu35q0PjrxiGri+Mt2iefAIHwh4pe5QYLf6C2Hka0Ul52nPQ t91eWTXDmTK4G8UpBKfbh1HGDCgzwIkZX1GMOwqPgrmDef86a3VGjayWHixOAx5solnp T8Sw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=TitDk0G3DHHY3wX+No6Sg8j95pSP3vx2g2tB+CKNJZw=; b=aWqPl4FyoNrn9NQmp3NPhokF78C8AM/QYV0Lf6Gg3bHPkHV390QCLMKrmmFipBwO2w GeOucSw34CRZSd81wbMUYMHlhYBX34SeYTisLHc5tu6LeSOX9XS/BlHBmJl7IpRvumJN sD3UPknDIdrdJRqwZGjCqmmAN2y5RSUrEUyGOFdLeFB5ieIjxdahatSc76bBKUsbvyyN Rxxy2nNzdLOxEBjjeZ8IiFeOOzg8yd7eARzXgWZ7ygfcLLVR7RMDMJjmxJH/0PiHQHqx omZHbcprdz2sy4ZYf9AjzwRHzhnhb40XXXpV2IcO3jbgTI8ESE1Z021Pq6kG3T47myOy VQIQ== X-Gm-Message-State: APjAAAXREYZG7uI66JJKNMexLYsBQwyS2NvRPPvg4uV0PFAcOpRxCdOV 8742q/R/Wgh52VrJKvO1Lrt/Sg== X-Google-Smtp-Source: APXvYqwB+X7qdWR9ouIsU3nrjnVYjzXtSUVdUgJwwnwH+boEy8YxuzqW4AynhWp3KhUM9bvyZO0+aw== X-Received: by 2002:a37:4ca:: with SMTP id 193mr720732qke.21.1568862549848; Wed, 18 Sep 2019 20:09:09 -0700 (PDT) Received: from nimloth.alvh.no-ip.org ([179.56.51.60]) by smtp.gmail.com with ESMTPSA id r4sm3436309qkb.25.2019.09.18.20.09.08 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 18 Sep 2019 20:09:09 -0700 (PDT) Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000) id C2A8C120D2B; Thu, 19 Sep 2019 00:09:06 -0300 (-03) Date: Thu, 19 Sep 2019 00:09:06 -0300 From: Alvaro Herrera To: Joe Nelson Cc: Thomas Munro , David Steele , Andrew Dunstan , Nikita Glukhov , PostgreSQL mailing lists Subject: Re: Optimization of some jsonb functions Message-ID: <20190919030906.GA7043@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20190918221813.GA18650@alvherre.pgsql> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2019-Sep-18, Alvaro Herrera wrote: > Well, I think that was useless, so I rebased again -- attached. ... which is how you find out that 0001 as an independent patch is not really a valid one, since it depends on an API change that does not happen until 0005. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services