Re: autoanalyze did not run

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Kristjan Mustkivi <sonicmonkey(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: autoanalyze did not run
Date: 2026-01-27 17:09:12
Message-ID: 80206a0ce9fccc0515c9d8f60a038a04cc37e65c.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, 2026-01-27 at 14:10 +0200, Kristjan Mustkivi wrote:
> I do apologize if I mix something up now, but I would expect COPY to
> have an effect on "n_ins_since_vacuum" but not "n_mod_since_analyze".
> COPY inserts rows, it does not update them.

Rows added by COPY must definitely count for "n_mod_since_analyze".

Yours,
Laurenz Albe

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2026-01-27 17:13:01 Re: autoanalyze did not run
Previous Message Ibrahim Shaame 2026-01-27 14:31:12 Re: Unable to compile postgresql-18.1