Re: Proposal: Extending the PostgreSQL Protocol with Command Metadata

2025-08-19 Thread Jelte Fennema-Nio
On Mon, 18 Aug 2025 at 02:25, Kir Shatrov wrote: > I'd like to propose a backward-compatible extension to the PostgreSQL > Frontend/Backend Protocol that would allow servers to send command metadata > back to clients alongside query results. I think at least one of your goals for the feature ma

Re: Proposal: Extending the PostgreSQL Protocol with Command Metadata

2025-08-19 Thread Julien Rouhaud
Hi, FWIW I'm +1 on the feature idea, I think it would really allow way better metrics processing. On Tue, Aug 19, 2025 at 07:55:10AM +0800, Andy Fan wrote: > Kir Shatrov writes: > > Hi, > > > ## Unlocking Greater Extensions > > > > Extensions leveraging this metadata protocol could allow to buil

Re: Proposal: Extending the PostgreSQL Protocol with Command Metadata

2025-08-18 Thread Andy Fan
Kir Shatrov writes: Hi, > ## Unlocking Greater Extensions > > Extensions leveraging this metadata protocol could allow to build things with > very little overhead that are not possible > today: > > - Multi-tenant applications tracking per-query resource consumption (buffer > hits/misses, CPU/I

Re: Proposal: Extending the PostgreSQL Protocol with Command Metadata

2025-08-18 Thread Jacob Champion
On Mon, Aug 18, 2025 at 9:05 AM Jacob Champion wrote: > There have been previous requests for baking custom trace IDs and WAL > information into the protocol; the wiki is down right now but I recall > some discussion at maybe the 2024 unconference? Wiki's back up: https://wiki.postgresql.org/wiki

Re: Proposal: Extending the PostgreSQL Protocol with Command Metadata

2025-08-18 Thread Jacob Champion
On Sun, Aug 17, 2025 at 5:25 PM Kir Shatrov wrote: > Is there interest in this type of protocol extension? There have been previous requests for baking custom trace IDs and WAL information into the protocol; the wiki is down right now but I recall some discussion at maybe the 2024 unconference?

Re: Proposal: Extending the PostgreSQL Protocol with Command Metadata

2025-08-18 Thread Aleksander Alekseev
Hi, > - Multi-tenant applications tracking per-query resource consumption (buffer > hits/misses, CPU/IO time) BTW speaking of buffer hits/misses, you can already do this with EXPLAIN ANALYZE. -- Best regards, Aleksander Alekseev

Re: Proposal: Extending the PostgreSQL Protocol with Command Metadata

2025-08-18 Thread Aleksander Alekseev
Hi, > I'd like to propose a backward-compatible extension to the PostgreSQL > Frontend/Backend Protocol that would allow servers to send command metadata > back to clients alongside query results. > > ## Background & Motivation > > Coming from a MySQL background, I've found PostgreSQL's lack of

Proposal: Extending the PostgreSQL Protocol with Command Metadata

2025-08-17 Thread Kir Shatrov
Hi hackers, I'd like to propose a backward-compatible extension to the PostgreSQL Frontend/Backend Protocol that would allow servers to send command metadata back to clients alongside query results. ## Background & Motivation Coming from a MySQL background, I've found PostgreSQL's lack of sessio