Re: When extended query protocol ends?

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
Cc: Jelte Fennema-Nio <postgres@jeltef.nl>, Tatsuo Ishii <ishii@sraoss.co.jp>, davecramer@postgres.rocks, pgsql-hackers@postgresql.org
Date: 2024-02-21T16:18:42Z
Lists: pgsql-hackers
Vladimir Sitnikov <sitnikov.vladimir@gmail.com> writes:
>> Would performance suffer that much?

> I have not benchmarked it much, however, the driver sends "autosave"
> queries once (savepoint) or twice(savepoint+release) for every
> user-provided query.
> If we use extended queries (parse+bind+exec) for every savepoint, that
> would result in 3 or 6 messages overhead for every user query.

Those should get bundled into single TCP messages, though.  Assuming
that that's done properly, I share the doubt that you're saving
anything very meaningful.

			regards, tom lane