| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>, John Naylor <john(dot)naylor(at)enterprisedb(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Yura Sokolov <y(dot)sokolov(at)postgrespro(dot)ru>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Michael Paquier <michael(at)paquier(dot)xyz> |
| Subject: | Re: PG15 beta1 sort performance regression due to Generation context change |
| Date: | 2022-07-15 22:52:11 |
| Message-ID: | 20220715225211.gdnbe42oidmlbjvb@awork3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
On 2022-07-15 18:40:11 -0400, Jonathan S. Katz wrote:
> What I find interesting is the resistance to adding any documentation around
> this feature to guide users in case they hit the regression. I understand it
> can be difficult to provide guidance on issues related to adjusting
> work_mem, but even just a hint in the release notes to say "if you see a
> performance regression you may need to adjust work_mem" would be helpful.
> This would help people who are planning upgrades to at least know what to
> watch out for.
If we want to add that as boilerplate for every major release - ok, although
it's not really actionable. What I'm against is adding it specifically for
this release - we have stuff like this *all the time*, we just often don't
bother to carefully find the specific point at which an optimization might
hurt.
Honestly, if this thread teaches anything, it's to hide relatively minor
corner case regressions. Which isn't good.
Greetings,
Andres Freund
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2022-07-15 23:12:07 | Re: PG15 beta1 sort performance regression due to Generation context change |
| Previous Message | Jonathan S. Katz | 2022-07-15 22:41:49 | Re: PG15 beta1 sort performance regression due to Generation context change |