Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lPDtA-00020u-16 for pgsql-hackers@arkaria.postgresql.org; Thu, 25 Mar 2021 00:30:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lPDt7-0006Iq-2E for pgsql-hackers@arkaria.postgresql.org; Thu, 25 Mar 2021 00:30:13 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lPDt6-0006Ih-Li for pgsql-hackers@lists.postgresql.org; Thu, 25 Mar 2021 00:30:12 +0000 Received: from mail-il1-x12b.google.com ([2607:f8b0:4864:20::12b]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lPDt3-0002Y5-Um for pgsql-hackers@postgresql.org; Thu, 25 Mar 2021 00:30:11 +0000 Received: by mail-il1-x12b.google.com with SMTP id d2so662189ilm.10 for ; Wed, 24 Mar 2021 17:30:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=BMxvIayExACvKHSo3/Vr5+LbqOUQj9eyduvkAzv7ZhU=; b=abpZh6WSID6YYZLtRMOHBeiG3lJC9Dw4jvoXYuzlrS03wu6Q+Vjp3uAz4Pv88L44tI PhLr5aztR+z3dQK55eLq/Lxl5NCcxZrOAqTyjLssyXRF+6lVxeW6fZg7pAi1EaJGwJ0S jl9TcoA4uwvb/YbfYqyTxvgYWwtS3beX98agT5jmO9m944e4rt4BAaNgzOXQYiL6El/X R/iLFS+k9p4zRF+n/fTdrG2RjDKRuKu2jP5fvaIti3FR9+tH6axH/iCBn+co96Z1+bgO kzssAJs7gowxaMwpg02iosAbtZdRYLwer8DJDLW3EalyRVbjkE3ZF2yQqBCs8ofAsrH0 h31g== 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:references :mime-version:content-disposition:in-reply-to:user-agent; bh=BMxvIayExACvKHSo3/Vr5+LbqOUQj9eyduvkAzv7ZhU=; b=XGdQX09an5E4hnB1BsnwxpTlcXcNlpjrwn+Ijgr+15u44c14U78MHJC6s9sIESp0WR k9WaSrSl7G0UkYJIiYa2y7bmrQrk2gSRSUQI2WUs1VzwN3mTJZJnsrQGgD4WzVMiJBsI lj42dXJkj7QdNHV57RZy4Iix5j7dnGil+NC+litZFU3iiKfTYJfHIuEumvyig+vUhAt6 yIxP14uDxU/dW1IR4dUfOY23JVr/q0IST+9ATYaNQhdIDtKOiCufaxwxD1d2RJMshzPk cCnjGUU0mxv3BiGXIDy7313vQKaLtPJYHcmO1pjeaYt8hxL6QfZbcxMGMLlNhi4RGVe2 OGJw== X-Gm-Message-State: AOAM5307lWutcWIhbDuA499/wsFgYmn7Tmk7lQTWzHJXKJuD0do8EuNF 35G8l30IUgUcVudAntYiUf4vLQ== X-Google-Smtp-Source: ABdhPJyUzmYQzWCpe74vZv7Zp4bQZRerol1NOZgLoDM+/WQxDEC0oITKd/3JMz2oaIjSciWRA227Hg== X-Received: by 2002:a05:6e02:1564:: with SMTP id k4mr4596194ilu.65.1616632208666; Wed, 24 Mar 2021 17:30:08 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id e2sm1427008ilu.56.2021.03.24.17.30.07 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Wed, 24 Mar 2021 17:30:08 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id CCA8C800A3C; Wed, 24 Mar 2021 19:30:06 -0500 (CDT) Date: Wed, 24 Mar 2021 19:30:06 -0500 From: Justin Pryzby To: Tomas Vondra Cc: Dean Rasheed , pgsql-hackers@postgresql.org Subject: Re: PoC/WIP: Extended statistics on expressions Message-ID: <20210325003006.GI15100@telsasoft.com> References: <9f6654b1-ca31-f979-0fe8-137683818273@enterprisedb.com> <20210324081402.GB28335@telsasoft.com> <20210324091708.GC28335@telsasoft.com> <1ff3fc47-8f6e-7839-c3ff-6b694956f92e@enterprisedb.com> <1ed534fb-b42b-f008-35ee-4eb930b0088f@enterprisedb.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1ed534fb-b42b-f008-35ee-4eb930b0088f@enterprisedb.com> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Mar 25, 2021 at 01:05:37AM +0100, Tomas Vondra wrote: > here's an updated patch. 0001 should address most of the today's review > items regarding comments etc. This is still an issue: postgres=# CREATE STATISTICS xt ON a FROM t JOIN t ON true; ERROR: schema "i" does not exist -- Justin