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 1m6ZYm-0003GO-RD for pgsql-performance@arkaria.postgresql.org; Thu, 22 Jul 2021 14:20:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m6ZYl-0007UC-8P for pgsql-performance@arkaria.postgresql.org; Thu, 22 Jul 2021 14:20:23 +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 1m6ZYk-0007U4-Ul for pgsql-performance@lists.postgresql.org; Thu, 22 Jul 2021 14:20:23 +0000 Received: from mail-lf1-x12c.google.com ([2a00:1450:4864:20::12c]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1m6ZYi-0004ml-1L for pgsql-performance@lists.postgresql.org; Thu, 22 Jul 2021 14:20:21 +0000 Received: by mail-lf1-x12c.google.com with SMTP id g22so8866254lfu.0 for ; Thu, 22 Jul 2021 07:20:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-language:content-transfer-encoding; bh=fe0/NwWqX/pbU99CusKG3Qolg0FrIB/uJuUsJzhxsVw=; b=C7ruwbfy4xIBvwI5FwTGENMc8HalIkWWHsUq/NN2g8v7SLOUWP2nUo4A69QKzzoqvg IvTy0r15CW/CJ/pT3C5Db278rtmQRPyZ4b86d7S2zjUDwtcrtDg1yB9lqe7bXCnnyEGr ofMzz8MMyypJahJAgzkZTYw0GaegNugHqpAGUgQFS0ZK3dupx8kZb11MopENR+bT91a9 zmbs4HYzPAfzwZjGA4qb/OfKp1k2o0b4IVx7DCPUtsM4SVY5fbDhla7dUJtE7ITRO84V 7UI0Fo1AIZAOUnSMEVONi+7rB6Nm29XVhWPXpKzHxLVrE5+bG5HgBD6m9xHx1ps7Vi/I 233A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=fe0/NwWqX/pbU99CusKG3Qolg0FrIB/uJuUsJzhxsVw=; b=ASjIHH30QuAdWVtpm2yh3bJ88dcwE8yNoyZ8aGpRCoLJWiv1WcChloA8kFCdsN74r+ XFWqVc7O0wlgE1OCF3ZGqVyiGWMCslEogTvWfhq4ZtF+d6DeyZx+B9tI0KGra3PlJp0V xkoS7SPtjscA7zBPQyCpv4uo5tEHyMMtGNz/EBNNpYtYM7aSYj5r8rLcIsJtUeBOPqXM wYuh+eHV0tusjYSBrDfo2thvnNJ5+V5S7E6CsHjm6n9RUeDfe7URkH9RkQ5LTBE5/6YY Egr6tRhMjx7HbtUcnGfIFIKRKBVBA/DWjwKBGQLOXwce+6fzWFoGlj2mefe7BOf8wkDc zm7w== X-Gm-Message-State: AOAM533jqNH9ivWM/hJ4gtVwK0/a9ACyjnrFn2ivvubsTEyf88ocrqDi Yr7X6I1Cpzp3Ke8mgjggf3Gch1pxRekSBw== X-Google-Smtp-Source: ABdhPJwjDxwJ96OmDXCzYMSHC6mMUwGWDMX71iw5cj4Gh7rqaXYzDw8CZUBpWDdxevIqI36IN9DTvQ== X-Received: by 2002:a05:6512:314c:: with SMTP id s12mr31535411lfi.627.1626963618066; Thu, 22 Jul 2021 07:20:18 -0700 (PDT) Received: from [192.168.144.101] (185.234.209.103.r.toneticgroup.pl. [185.234.209.103]) by smtp.googlemail.com with ESMTPSA id o22sm2003640lfl.6.2021.07.22.07.20.17 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 22 Jul 2021 07:20:17 -0700 (PDT) Subject: Re: Partitioned table statistics vs autoanalyze To: Justin Pryzby Cc: pgsql-performance@lists.postgresql.org References: <0d1b394b-bec9-8a71-a336-44df7078b295@gmail.com> <20210722121559.GE19620@telsasoft.com> From: Kamil Frydel Message-ID: Date: Thu, 22 Jul 2021 16:20:16 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.11.0 MIME-Version: 1.0 In-Reply-To: <20210722121559.GE19620@telsasoft.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > In v14 (which is currently in beta), autoanalyze will process the partitioned > table automatically: > https://www.postgresql.org/docs/14/release-14.html > |Autovacuum now analyzes partitioned tables (Yuzuko Hosoya, Álvaro Herrera) > |Insert, update, and delete tuple counts from partitions are now propagated to their parent tables so autovacuum knows when to process them. > Thank you for the prompt reply! Changes in v14 sound promising. -- Best regards Kamil Frydel