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/>
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) |