pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Michael Paquier <michael@paquier.xyz>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Change internal plan ID type from uint64 to int64
Date: Sat, 31 May 2025 00:41:15 +0000
Message-ID: <E1uLAHi-000ncM-1E@gemulon.postgresql.org> (raw)

Change internal plan ID type from uint64 to int64

uint64 was chosen to be consistent with the type used by the query ID,
but the conclusion of a recent discussion for the query ID is that int64
is a better fit as the signed form is shown to the user, for PGSS or
EXPLAIN outputs.

This commit changes the plan ID to use int64, following c3eda50b0648
that has done the same for the query ID.

The plan ID is new to v18, introduced in 2a0cd38da5cc.

Author: Michael Paquier <michael@paquier.xyz>
Reviewed-by: Sami Imseih <samimseih@gmail.com>
Discussion: https://postgr.es/m/aCvzJNwetyEI3Sgo@paquier.xyz

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/e050af28686e796bdf22cb53fe3fdf1c6655f315

Modified Files
--------------
src/backend/tcop/postgres.c                 |  4 ++--
src/backend/utils/activity/backend_status.c | 10 +++++-----
src/include/nodes/plannodes.h               |  2 +-
src/include/utils/backend_status.h          |  6 +++---
4 files changed, 11 insertions(+), 11 deletions(-)



Message-ID: <E1uLAHi-000ncM-1E@gemulon.postgresql.org>
Permalink:  ../E1uLAHi-000ncM-1E@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1uLAHi-000ncM-1E@gemulon.postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-committers@postgresql.org
  Cc: michael@paquier.xyz, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: Change internal plan ID type from uint64 to int64
  In-Reply-To: <E1uLAHi-000ncM-1E@gemulon.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox