Horton
Menu

Re: Postgres chooses slow query plan from time to time

Justin Pryzby <pryzby@telsasoft.com>

View thread
From: Justin Pryzby <pryzby@telsasoft.com>
To: Michael Lewis <mlewis@entrata.com>
Cc: Tomas Vondra <tomas.vondra@enterprisedb.com>, Kristjan Mustkivi <sonicmonkey@gmail.com>, pgsql-performance@lists.postgresql.org
Date: 2021-09-13T14:22:49Z
Lists: pgsql-performance 
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