Re: When extended query protocol ends?
Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
From: Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
To: Jelte Fennema-Nio <postgres@jeltef.nl>
Cc: Tatsuo Ishii <ishii@sraoss.co.jp>, davecramer@postgres.rocks,
tgl@sss.pgh.pa.us, pgsql-hackers@postgresql.org
Date: 2024-02-21T16:07:20Z
Lists: pgsql-hackers
>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. From many measurements we know that insert into table(id, name) values(?,?),(?,?),(?,?) is much more efficient than sending individual bind-exec-bind-exec-bind-exec-sync messages like "insert into table(id, name) values(?,?)" For instance, here are some measurements: https://www.baeldung.com/spring-jdbc-batch-inserts#performance-comparisons Based on that measurements I assume there's a non-trivial per-message overhead. Vladimir