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 1ofztt-0004dH-5G for pgsql-hackers@arkaria.postgresql.org; Wed, 05 Oct 2022 08:37:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ofztr-0001Z2-Vj for pgsql-hackers@arkaria.postgresql.org; Wed, 05 Oct 2022 08:37:07 +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 1ofztr-0001Wm-Ib for pgsql-hackers@lists.postgresql.org; Wed, 05 Oct 2022 08:37:07 +0000 Received: from mail-ed1-x532.google.com ([2a00:1450:4864:20::532]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ofzto-0005sk-Fh for pgsql-hackers@postgresql.org; Wed, 05 Oct 2022 08:37:06 +0000 Received: by mail-ed1-x532.google.com with SMTP id m15so21969081edb.13 for ; Wed, 05 Oct 2022 01:37:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; h=mime-version:user-agent:references:in-reply-to:date:cc:to:from :subject:message-id:from:to:cc:subject:date; bh=WLHX87ILfxkjdhvu9HpFxq8ZN6Kx7pP64CBXcc3Yx0k=; b=ndfZntGdm88ullIhtf42xu/Z5jjyz9Kqcf3jVai44BgRgYBWlGKUumzW/AFmj3cLt7 HkQwSqMEmRoN5bjgL+2dudyoS1M5NYv7aUv46X/SzNQnf/Zu1tem+MgFSwYGD+OmWzzN uOufEnOX9wIHlNinNK/EE+W6kpTn2A/i9GdBANBYjNMRLJa+BLTbOo7t7avazxuBXpZX BTw2Ijjfy1TAk34ubpaKMyqhXcWNP0RWwv25ZSTH5UN4FFXIo442w9qv6W8dVCKequ7F bwAMaTJ+4aZIPQgj6lI4YSK5E0UsShimfgmsWt9sLVaEXSXjywcARbtfQ02dqKuhCA5K /d5w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=mime-version:user-agent:references:in-reply-to:date:cc:to:from :subject:message-id:x-gm-message-state:from:to:cc:subject:date; bh=WLHX87ILfxkjdhvu9HpFxq8ZN6Kx7pP64CBXcc3Yx0k=; b=j5kME6sY2y8zUvv7Jv2t83hgzKruhV14TGN4Uxt4RRfofCLMHj4u5C1sKnyYW+Ym+A q+SSphtOt9J3HvopkkS8GuFNhdmhe9eU4MYdYmSfH8xgbp+Tujt1+0mSM6d5ht/kxEKq MsCjuVe96sOA/z/iJtls80hEUWwMjNPHHfkgzA8lrF0RzDDEh1ZROJX88idKIKnALokA W7moBBEYQhBCaWUJlh9C6UdzROdFbKAw8ZAWWLYqe/FXkmyBDYk5/EN5c6LxzLfNrsUU lbdbpeuVitANdt1jV9l/blZS1GmPglraoHiVioOuPIyajp85vxGLLSE9v92owfKngXpR NNtA== X-Gm-Message-State: ACrzQf0asqA9qUgX8xYtdaPoy6djTQ7PKyB48IdEYMp6FKDJFMxkq9JG pJ0kWwyJacW9PSoF7gy62/bKHg== X-Google-Smtp-Source: AMsMyM5zDJ73N2KhWru64t1l2u7viVJPF9TsyoDlC5nJY3Wxh9gV6MdcWsuX+ziXBnNEQ4P/IKrBkQ== X-Received: by 2002:a05:6402:3550:b0:451:473a:5ca3 with SMTP id f16-20020a056402355000b00451473a5ca3mr27554797edd.48.1664959022951; Wed, 05 Oct 2022 01:37:02 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:341d:c223:a8b:69e0:f1f8]) by smtp.gmail.com with ESMTPSA id t26-20020a170906179a00b0078082f95e5csm8097390eje.204.2022.10.05.01.37.02 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 05 Oct 2022 01:37:02 -0700 (PDT) Message-ID: <1fd81ddc7710a154834030133c6fea41e55c8efb.camel@cybertec.at> Subject: Re: document the need to analyze partitioned tables From: Laurenz Albe To: Tomas Vondra , Justin Pryzby , Robert Haas Cc: =?ISO-8859-1?Q?=C1lvaro?= Herrera , yuzuko , pgsql-hackers@postgresql.org Date: Wed, 05 Oct 2022 10:37:01 +0200 In-Reply-To: <88903179-5ce2-3d4d-af43-7830372bdcb6@enterprisedb.com> References: <20210913035409.GA10647@telsasoft.com> <20211008125822.GJ27491@telsasoft.com> <681e76ad-3a7b-ea3c-b6b0-55946239c49b@enterprisedb.com> <20220121180200.GM23027@telsasoft.com> <19c248d9-3687-9e0f-0b1a-2adad1de6fbe@enterprisedb.com> <20220315230011.GZ28503@telsasoft.com> <88903179-5ce2-3d4d-af43-7830372bdcb6@enterprisedb.com> Content-Type: multipart/mixed; boundary="=-CHkxMtd4zRyBIddKmE5D" User-Agent: Evolution 3.42.4 (3.42.4-2.fc35) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-CHkxMtd4zRyBIddKmE5D Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit On Mon, 2022-03-28 at 15:05 +0200, Tomas Vondra wrote: > I've pushed the last version, and backpatched it to 10 (not sure I'd > call it a bugfix, but I certainly agree with Justin it's worth > mentioning in the docs, even on older branches). I'd like to suggest an improvement to this. The current wording could be read to mean that dead tuples won't get cleaned up in partitioned tables. By the way, where are the statistics of a partitioned tables used? The actual tables scanned are always the partitions, and in the execution plans that I have seen, the optimizer always used the statistics of the partitions. Yours, Laurenz Albe --=-CHkxMtd4zRyBIddKmE5D Content-Disposition: attachment; filename="0001-Improve-autovacuum-doc-on-partitioned-tables.patch" Content-Transfer-Encoding: base64 Content-Type: text/x-patch; name="0001-Improve-autovacuum-doc-on-partitioned-tables.patch"; charset="UTF-8" RnJvbSA1MjA5ZjIyOGYwOWU1Mjc4MDUzNWVkYWNmZWU1ZjdlZmQyYzI1MDgxIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h dD4KRGF0ZTogV2VkLCA1IE9jdCAyMDIyIDEwOjMxOjQ3ICswMjAwClN1YmplY3Q6IFtQQVRDSF0g SW1wcm92ZSBhdXRvdmFjdXVtIGRvYyBvbiBwYXJ0aXRpb25lZCB0YWJsZXMKClRoZSBkb2N1bWVu dGF0aW9uIG1lbnRpb25lZCB0aGF0IGF1dG92YWN1dW0gZG9lc24ndCBwcm9jZXNzCnBhcnRpdGlv bmVkIHRhYmxlcywgYnV0IGl0IHdhcyB1bmNsZWFyIGFib3V0IHRoZSBpbXBhY3QuClRoZSBvbGQg d29yZGluZyBjb3VsZCBiZSBpbnRlcnByZXRlZCB0byBtZWFuIHRoYXQgdGhlcmUgYXJlCnByb2Js ZW1zIHdpdGggZGVhZCB0dXBsZSBjbGVhbnVwIG9uIHBhcnRpdGlvbmVkIHRhYmxlcy4KQ2xhcmlm eSB0aGF0IHRoZSBvbmx5IHBvdGVudGlhbCBwcm9ibGVtIGlzIGF1dG9hbmFseXplLCBhbmQKdGhh dCBzdGF0aXN0aWNzIGZvciB0aGUgcGFydGl0aW9ucyB3aWxsIGJlIGdhdGhlcmVkLgotLS0KIGRv Yy9zcmMvc2dtbC9tYWludGVuYW5jZS5zZ21sIHwgMTMgKysrKysrKysrLS0tLQogMSBmaWxlIGNo YW5nZWQsIDkgaW5zZXJ0aW9ucygrKSwgNCBkZWxldGlvbnMoLSkKCmRpZmYgLS1naXQgYS9kb2Mv c3JjL3NnbWwvbWFpbnRlbmFuY2Uuc2dtbCBiL2RvYy9zcmMvc2dtbC9tYWludGVuYW5jZS5zZ21s CmluZGV4IDc1OWVhNWFjOWMuLjUzZTNmYWRiYWYgMTAwNjQ0Ci0tLSBhL2RvYy9zcmMvc2dtbC9t YWludGVuYW5jZS5zZ21sCisrKyBiL2RvYy9zcmMvc2dtbC9tYWludGVuYW5jZS5zZ21sCkBAIC04 NjAsMTAgKzg2MCwxNSBAQCBhbmFseXplIHRocmVzaG9sZCA9IGFuYWx5emUgYmFzZSB0aHJlc2hv bGQgKyBhbmFseXplIHNjYWxlIGZhY3RvciAqIG51bWJlciBvZiB0dQogICAgPC9wYXJhPgogCiAg ICA8cGFyYT4KLSAgICBQYXJ0aXRpb25lZCB0YWJsZXMgYXJlIG5vdCBwcm9jZXNzZWQgYnkgYXV0 b3ZhY3V1bS4gIFN0YXRpc3RpY3MKLSAgICBzaG91bGQgYmUgY29sbGVjdGVkIGJ5IHJ1bm5pbmcg YSBtYW51YWwgPGNvbW1hbmQ+QU5BTFlaRTwvY29tbWFuZD4gd2hlbiBpdCBpcwotICAgIGZpcnN0 IHBvcHVsYXRlZCwgYW5kIGFnYWluIHdoZW5ldmVyIHRoZSBkaXN0cmlidXRpb24gb2YgZGF0YSBp biBpdHMKLSAgICBwYXJ0aXRpb25zIGNoYW5nZXMgc2lnbmlmaWNhbnRseS4KKyAgICBQYXJ0aXRp b25lZCB0YWJsZXMgYXJlIG5vdCBwcm9jZXNzZWQgYnkgYXV0b3ZhY3V1bS4gIFRoaXMgaXMgbm8g cHJvYmxlbQorICAgIGFzIGZhciBhcyA8Y29tbWFuZD5WQUNVVU08L2NvbW1hbmQ+IGlzIGNvbmNl cm5lZCwgc2luY2UgYXV0b3ZhY3V1bSB3aWxsIHByb2Nlc3MKKyAgICB0aGUgcGFydGl0aW9ucy4g IEJ1dCwgYXMgbWVudGlvbmVkIGluIDx4cmVmIGxpbmtlbmQ9InZhY3V1bS1mb3Itc3RhdGlzdGlj cyIvPiwKKyAgICBpdCBhbHNvIG1lYW5zIHRoYXQgYXV0b3ZhY3V1bSB3b24ndCBydW4gPGNvbW1h bmQ+QU5BTFlaRTwvY29tbWFuZD4gb24gdGhlCisgICAgcGFydGl0aW9uZWQgdGFibGUgaXRzZWxm LiAgV2hpbGUgc3RhdGlzdGljcyBhcmUgZ2F0aGVyZWQgZm9yIHRoZSBwYXJ0aXRpb25zLAorICAg IHNvbWUgcXVlcmllcyBtYXkgcmVseSBvbiB0aGUgc3RhdGlzdGljcyBmb3IgdGhlIHBhcnRpdGlv bmVkIHRhYmxlLiAgWW91IHNob3VsZAorICAgIGNvbGxlY3Qgc3RhdGlzdGljcyBieSBydW5uaW5n IGEgbWFudWFsIDxjb21tYW5kPkFOQUxZWkU8L2NvbW1hbmQ+IHdoZW4gdGhlCisgICAgcGFydGl0 aW9uZWQgdGFibGUgaXMgZmlyc3QgcG9wdWxhdGVkLCBhbmQgYWdhaW4gd2hlbmV2ZXIgdGhlIGRp c3RyaWJ1dGlvbgorICAgIG9mIGRhdGEgaW4gaXRzIHBhcnRpdGlvbnMgY2hhbmdlcyBzaWduaWZp Y2FudGx5LgogICAgPC9wYXJhPgogCiAgICA8cGFyYT4KLS0gCjIuMzcuMwoK --=-CHkxMtd4zRyBIddKmE5D--