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