Re: Statistics Import and Export

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Corey Huinker <corey(dot)huinker(at)gmail(dot)com>, Jeff Davis <pgsql(at)j-davis(dot)com>, jian he <jian(dot)universality(at)gmail(dot)com>, Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Nathan Bossart <nathandbossart(at)gmail(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, alvherre(at)alvh(dot)no-ip(dot)org
Subject: Re: Statistics Import and Export
Date: 2024-11-27 13:44:01
Message-ID: CABUevEzo_gz4o0W-grWdZvxP-hHRfgzJB8DPAy4GyvTUoWBCDg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Nov 19, 2024 at 1:50 PM Bruce Momjian <bruce(at)momjian(dot)us> wrote:

> On Mon, Nov 18, 2024 at 08:42:35PM -0500, Bruce Momjian wrote:
> > On Mon, Nov 18, 2024 at 08:29:10PM -0500, Corey Huinker wrote:
> > > That's not a great surprise for group 6, but I have to believe that
> group is
> > > smaller than group 5, and it's definitely smaller than the group of
> users that
> > > need to upgrade.
> >
> > Again, a clean API is the goal, not surprise calculus.
>
> Maybe I was too harsh. "Surprise calculus" is fine, but only after we
> have an API that will be clearly understood by new users. We have to
> assume that in the long run new users will use this API more than
> existing users.
>

If you want to avoid both the surprise and confusion factor mentioned
before, maybe what's needed is to *remove* --analyze-in-stages, and replace
it with --analyze-missing-in-stages and --analyze-all-in-stages (with the
clear warning about what --analyze-all-in-stages can do to your system if
you already have statistics).

That goes with the "immediate breakage that you see right away is better
than silently doing the unexpected where you might not notice the problem
until much later".

That might trade some of that surprise and confusion for annoyance instead,
but going forward that might be a clearer path?

--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Matheus Alcantara 2024-11-27 13:50:29 Re: Using read stream in autoprewarm
Previous Message Matthias van de Meent 2024-11-27 13:36:11 Re: Showing primitive index scan count in EXPLAIN ANALYZE (for skip scan and SAOP scans)