Re: Possible regression in PG18 beta1

Maciek Sakrejda <m.sakrejda@gmail.com>

From: Maciek Sakrejda <m.sakrejda@gmail.com>

To: Sadeq Dousti <msdousti@gmail.com>

Cc: Christophe Courtois <christophe.courtois@dalibo.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2025-05-17T17:29:53Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

EXPLAIN: Always use two fractional digits for row counts.
- 95dbd827f2ed 18.0 cited

On Sat, May 17, 2025 at 9:38 AM Sadeq Dousti <msdousti@gmail.com> wrote:

> So, one mystery solved (no planner regression), still three questions:
> * Somewhat slower execution in PG18
> * Planner differences in TEMP vs. UNLOGGED
> * Actual rows with decimal (1.00) vs. integer (1)
>

Regarding the last one, I believe that's intentional, due to a change to
EXPLAIN output [1]. No comment on the others.

Thanks,
Maciek

[1]:
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=95dbd827f2edc4d10bebd7e840a0bd6782cf69b7