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.92) (envelope-from ) id 1jD8c8-0002sU-Ey for pgsql-hackers@arkaria.postgresql.org; Sat, 14 Mar 2020 15:22:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jD8c7-00072b-9Y for pgsql-hackers@arkaria.postgresql.org; Sat, 14 Mar 2020 15:22:11 +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 1jD8c6-00072U-QU for pgsql-hackers@lists.postgresql.org; Sat, 14 Mar 2020 15:22:11 +0000 Received: from mail-wm1-x342.google.com ([2a00:1450:4864:20::342]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jD8bz-0006b8-1p for pgsql-hackers@lists.postgresql.org; Sat, 14 Mar 2020 15:22:10 +0000 Received: by mail-wm1-x342.google.com with SMTP id f7so13351833wml.4 for ; Sat, 14 Mar 2020 08:22:02 -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:references:mime-version :content-disposition:in-reply-to; bh=Odonq3uBUHlDkvtxyAelFegLoFidVf5bhoeRqWvam6I=; b=NMcw700xissgWZYJRQrEahE6p+fRJw+U9Bolo6KFAikfOfviGqrYFxwcZbuIWzypc2 /5krNFo/iwQrR0IpHnvbVSFcvHeQXjLviwIL7VxbqCgAdPPfc1KBThrOqaeptSJ9VzoM wm9GiUuBo+RiFjD+vCFboN0XIIfSB4c7NGQmGWRGSBoirgaiXIjlr/lJPUD/O7zbPXbk mz7yJpJ9QeYN8MT3BvFsr0fCLRXy6vFKo1hbpvN79D7MTTBlS7HDiyCnCcl6SPqJhBQ8 gKII6sERmwyZP7E5QRo95z7N0D33YcwRqRKHNvFxY+SoIlX3ZZtDO9pd6T6tqQXMt6gf AWOg== 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; bh=Odonq3uBUHlDkvtxyAelFegLoFidVf5bhoeRqWvam6I=; b=ssGqaYm0ZOg7atLDnl+qADaWRznGWs9CVHU2L1qLB79+QAaoG6VCw19vVF9ZrMp3nA Q7YrfBA3tRK822lu//9vfDSHPYv+jjJsxlMBDNwy9/pHV1sPAKc6n5d7XAryfuJ+/lXb T2xIaUvHCMtJUhiyMwrVgwFSCDgDSm1tAf4jxNTKXs5ZyLn6hH0OpM3OmQctmN8GPZqC wDgsMnx93D8ry/Ffat4RLwisJm40VIIUECFqN9Mlcbs9tkF9jZFmopl4H9frPPAdS0n7 OHqycTUlDaB/0IMGjtm8QdjmcO27kJO+hlhr7Fb4IQacpJqmVAAi4DCZ1ZfmggUgfDXV QbSw== X-Gm-Message-State: ANhLgQ3rrep9umfbQSkdgoaAaAb/jzByVoIRYLITVGXW756VxOZBjFEy xLgg0tY76kKS4I3t80pbZVA0Jg== X-Google-Smtp-Source: ADFU+vvqB/uknRVHMjJzMmf1l9uTIH6u2EKJVQuuDrGAczz9xAAedt2tMfYESoBfaD6Cdb4bOIsQLQ== X-Received: by 2002:a7b:c20c:: with SMTP id x12mr17271486wmi.80.1584199321345; Sat, 14 Mar 2020 08:22:01 -0700 (PDT) Received: from localhost (ip-86-49-253-92.net.upcbroadband.cz. [86.49.253.92]) by smtp.gmail.com with ESMTPSA id m21sm20801976wmi.27.2020.03.14.08.22.00 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 14 Mar 2020 08:22:00 -0700 (PDT) Date: Sat, 14 Mar 2020 16:21:59 +0100 From: Tomas Vondra To: Dean Rasheed Cc: Pierre Ducroquet , PostgreSQL Hackers Subject: Re: PATCH: add support for IN and @> in functional-dependency statistics use Message-ID: <20200314152159.5webesf6pfluatqj@development> References: <13902317.Eha0YfKkKy@pierred-pdoc> <20200201142446.aq5zf3gawj3ynrc2@development> <3937607.jCdSCb7NGl@pierred-pdoc> <20200202184134.swoqkqlqorqolrqv@development> <20200312173047.stp55sxoj4sipn7q@development> <20200313160944.aqrbkyf7tkasoxfk@development> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Disposition: inline In-Reply-To: <20200313160944.aqrbkyf7tkasoxfk@development> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, I've pushed the first part of the patch, adding ScalarArrayOpExpr as supported clause for functional dependencies, and then also doing the same for MCV lists. As discussed, I'm not going to do anything about the array containment clauses for PG13, that needs more discussion. I have a bunch of additional improvements for extended stats, discussed in [1]. I'll wait a bit for buildfarm and maybe some feedback before pushing those. [1] https://www.postgresql.org/message-id/flat/20200113230008.g67iyk4cs3xbnjju@development regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services