Re: Support prepared statement invalidation when result types change - Mailing list pgsql-hackers

From Shay Rojansky
Subject Re: Support prepared statement invalidation when result types change
Date
Msg-id CADT4RqD_vf8tV_O0kpMQhWr3UWMBt_BGgZhTkYPS3LSA5TwBCw@mail.gmail.com
Whole thread Raw
In response to Re: Support prepared statement invalidation when result types change  (Jelte Fennema-Nio <me@jeltef.nl>)
Responses Re: Support prepared statement invalidation when result types change
List pgsql-hackers
On Mon, Sep 18, 2023 at 1:31 PM Jelte Fennema-Nio <me@jeltef.nl> wrote:

> Furthermore caching RowDescription is also not super useful, most
> clients request it every time because it does not require an extra
> round trip, so there's almost no overhead in requesting it.

Just to point out, FWIW, that the .NET Npgsql driver does indeed cache RowDescriptions... The whole point of preparation is to optimize things as much as possible for repeated execution of the query; I get that the value there is much lower than e.g. doing another network roundtrip, but that's still extra work that's better off being cut if it can be.

pgsql-hackers by date:

Previous
From: Andy Fan
Date:
Subject: Re: Extract numeric filed in JSONB more effectively
Next
From: Andrei Lepikhov
Date:
Subject: Re: Multidimensional Histograms