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 1j5omF-0001aR-3i for pgsql-performance@arkaria.postgresql.org; Sun, 23 Feb 2020 10:46:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j5omC-0007v9-M8 for pgsql-performance@arkaria.postgresql.org; Sun, 23 Feb 2020 10:46:20 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j5omC-0007qo-57 for pgsql-performance@lists.postgresql.org; Sun, 23 Feb 2020 10:46:20 +0000 Received: from mail-yw1-xc43.google.com ([2607:f8b0:4864:20::c43]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1j5om4-0004Nx-Sd for pgsql-performance@lists.postgresql.org; Sun, 23 Feb 2020 10:46:18 +0000 Received: by mail-yw1-xc43.google.com with SMTP id f204so3848414ywc.10 for ; Sun, 23 Feb 2020 02:46:12 -0800 (PST) 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=grYzFaeKPrriPN5fsRY/TZz7hhcJkUvCf4OlJ36a8ZU=; b=m22bktMHEpdLvUZGDSVomizIO6FeO3vtng7aX4ha2B7VUfbFFmkO+vNraSWIFdL81H miQbMInLGAXaJ8x2LdFJCXI+c/vRzohNrTKN3hQL7rdi56NUkK4cZeSHUIczAegj9+uL x+hi8dxxuCIkyOSnAbnFFyu0EFk8rLti+LOoJG0VOuSKHdYlnQDl1vfSaFAARpkji5dF s8eK+kV2aoFT1TQmSsOPbgyFxN6mW1COBzQMMWbd9PZwctNO3nyMPbggQq8Ciz5PXn3c n6KX/KBa+xpCCf15Oel5Iu+uaW50Or7Gy0z1+yHAwA1Y8rY6qOtkDe/4c6vl2GVbe+qV Ol4g== 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=grYzFaeKPrriPN5fsRY/TZz7hhcJkUvCf4OlJ36a8ZU=; b=LN57+sIpuUAX9DEuxTkTwMHIGSZTn+z7z9SaER7Gl/W1ce+LMPdhQ/px7ZRpHvkwLI j1a8UW8Rt0Ay3P+ub+/udbO8NkKoFaoePcEqhUeJ286ox9bUWdJ+V2BECEWXP5g9hM4g hasoHhsd67LKlLAKjDh1eHGkekjchb2mhex68vfKecJBQh37rKsK0lK5xZuYjyweOCYr IllXmh+kCruTmEMimcHjrF77WIxo7oMGCkDj7ymUQchZE3GncMBv9SZsIQVCzgMa7d15 GoubSdtY+eNcDpmJrX02n+XGzjV6jByatxWtzjLVNvWz51VGPiIqLYa1gU5rqB7GoIA/ Yngg== X-Gm-Message-State: APjAAAVudzBFs53ZP+F5qxasFx5NgnE3YuUqqU3AeZ+OJVDtIbJ4SqbI jB1C6IR+YdCf+nTeXJc8tLDfi7U3neI= X-Google-Smtp-Source: APXvYqzco58FVqsNXGK2JGeg2iAHQACWCT3jjwz1cmjWBCQA3vdIcJj4/gs0smvg2kY6v+TZkOKybA== X-Received: by 2002:a81:ad44:: with SMTP id l4mr37250182ywk.53.1582454771717; Sun, 23 Feb 2020 02:46:11 -0800 (PST) Received: from pryzbyj (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id w5sm3867860yww.106.2020.02.23.02.46.10 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sun, 23 Feb 2020 02:46:10 -0800 (PST) Received: by pryzbyj (Postfix, from userid 1000) id 956B5800897; Sun, 23 Feb 2020 04:46:09 -0600 (CST) Date: Sun, 23 Feb 2020 04:46:09 -0600 From: Justin Pryzby To: Ravi Garg Cc: pgsql-performance@lists.postgresql.org Subject: Re: PostgreSQL 11 higher Planning time on Partitioned table Message-ID: <20200223104609.GA27688@telsasoft.com> References: <1789489940.5008704.1582451790367.ref@mail.yahoo.com> <1789489940.5008704.1582451790367@mail.yahoo.com> <20200223101209.GU31889@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20200223101209.GU31889@telsasoft.com> User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Sun, Feb 23, 2020 at 04:12:09AM -0600, Justin Pryzby wrote: > How large are the partitions and how many indexes each, and how large are they? > Each partition will be stat()ed ... for every query. I should have said that's every 1GB "segment" is stat()ed for every query. > This was resolved in pg12: > https://commitfest.postgresql.org/21/1778/ + https://www.postgresql.org/about/featurematrix/detail/320/ -- Justin