Re: When extended query protocol ends? - Mailing list pgsql-hackers

From Vladimir Sitnikov
Subject Re: When extended query protocol ends?
Date
Msg-id CAB=Je-Hi_48+7gea54bkiKXz6hCFYWj1_WD-3bApFXP=+JG1cw@mail.gmail.com
Whole thread Raw
In response to Re: When extended query protocol ends?  (Jelte Fennema-Nio <postgres@jeltef.nl>)
Responses Re: When extended query protocol ends?
Re: When extended query protocol ends?
List 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(?,?)"
Based on that measurements I assume there's a non-trivial per-message overhead.

Vladimir

pgsql-hackers by date:

Previous
From: Jelte Fennema-Nio
Date:
Subject: Re: When extended query protocol ends?
Next
From: Tom Lane
Date:
Subject: Re: When extended query protocol ends?