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 1mPmrn-0005jp-V9 for pgsql-performance@arkaria.postgresql.org; Mon, 13 Sep 2021 14:23:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mPmrH-0004lG-C8 for pgsql-performance@arkaria.postgresql.org; Mon, 13 Sep 2021 14:22:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mPmrG-0004l4-Uy for pgsql-performance@lists.postgresql.org; Mon, 13 Sep 2021 14:22:55 +0000 Received: from mail-il1-x130.google.com ([2607:f8b0:4864:20::130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mPmrE-0000xI-Nd for pgsql-performance@lists.postgresql.org; Mon, 13 Sep 2021 14:22:54 +0000 Received: by mail-il1-x130.google.com with SMTP id h29so10250450ila.2 for ; Mon, 13 Sep 2021 07:22:52 -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=bpgEn7v7hUzX2CbfcwzSu/cIKQxPSDlU9wUZgGFQf5s=; b=YV3cQLnpdb53YJA54vQusnsYrPRyRfpRyxdAWGg7EaeVYxj4FAqtsIVL+YcLiVN3aC oQsdomRzIgX8l4f8BkRP3ReluaJYEF3MM7wZXPHS/JOeBQgYffGyntxQttqTsx43qs9M OWg5y2Pke0qlYdjiu2Z077FlY2rOEA9KbUTxZjJldUU9auGCMbVPZ7a83jT4eqi0hnRq F3D8Rx5Fl5a6EgfwV3U8Uluokn9KuthltXmVURsAk+BXQ2d+KK+/V9P/6FR/dV7Bx0hL GSibwR+nuCSw7w1OyFMfmyvSqL13OyMQa1WlxfpL9ZoRXlTPLPi6UnuMcqUsbl529/9x dWYA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=bpgEn7v7hUzX2CbfcwzSu/cIKQxPSDlU9wUZgGFQf5s=; b=VEcKO6HSLMllLQyKocg19AQJUeTaC5fUvmaybdtcsu+SLaftAau5wdjRMYoL8Q4+Je 7fJucsH6sZ8FBlUUgdMZS59p4qPLk5mXj6nAUP+lq55Ea3qm7JMl+em7NfmNvCPRCnAt wKVaCRiMM/B/xvG7L3skV5V/a2z3GLNSFLK4K0NjQGwrwD0Ff5jUoiA4K2zV36/qnyJd ESff6wozb6Y3xcAw4CslynpYnZNGGy7/xhS63MT0cqu3JWwgJSFR+GWF28wrX16mquqw jCdoe8GLMYrH/Cypk4eTXa0UZcdfvqgb0/cDjbpwo/7uwrFvtMwHHwEmOGyrrn8GhSba LzgA== X-Gm-Message-State: AOAM532sQ3fMygC+W9tJ0vn5Yru7XSZlkhBO9ePtY+AwCiQR/GTc0vwP DV3cATKLIEx+b0j34qaqJbbfIw== X-Google-Smtp-Source: ABdhPJwLQoPexRZNZZf/XBgVpw3n/gp8ihcx6dJTc1VNqbYxgqwOQdW9ECy1qjtVHDFucRfdgGgt9g== X-Received: by 2002:a05:6e02:1bc5:: with SMTP id x5mr8175110ilv.83.1631542970954; Mon, 13 Sep 2021 07:22:50 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id x8sm4864554ilc.40.2021.09.13.07.22.50 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 13 Sep 2021 07:22:50 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id A9552800BCE; Mon, 13 Sep 2021 09:22:49 -0500 (CDT) Date: Mon, 13 Sep 2021 09:22:49 -0500 From: Justin Pryzby To: Michael Lewis Cc: Tomas Vondra , Kristjan Mustkivi , pgsql-performance@lists.postgresql.org Subject: Re: Postgres chooses slow query plan from time to time Message-ID: <20210913142249.GP26465@telsasoft.com> References: <31c01752-c4d6-7751-9d25-b1fac8f3a7aa@enterprisedb.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: 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 Mon, Sep 13, 2021 at 08:19:40AM -0600, Michael Lewis wrote: > Autovacuum will only run for freezing, right? Insert only tables don't get > autovacuumed/analyzed until PG13 if I remember right. Tomas is talking about autovacuum running *analyze*, not vacuum. It runs for analyze, except on partitioned tables and (empty) inheritence parents. -- Justin