Re: Postgres chooses slow query plan from time to time

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Michael Lewis <mlewis(at)entrata(dot)com>
Cc: Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, Kristjan Mustkivi <sonicmonkey(at)gmail(dot)com>, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Postgres chooses slow query plan from time to time
Date: 2021-09-13 14:22:49
Message-ID: 20210913142249.GP26465@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message ldh@laurent-hasson.com 2021-09-13 14:32:30 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
Previous Message Michael Lewis 2021-09-13 14:19:40 Re: Postgres chooses slow query plan from time to time