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

From Tom Lane
Subject Re: When extended query protocol ends?
Date
Msg-id 84852.1708532322@sss.pgh.pa.us
Whole thread Raw
In response to Re: When extended query protocol ends?  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
List 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



pgsql-hackers by date:

Previous
From: Vladimir Sitnikov
Date:
Subject: Re: When extended query protocol ends?
Next
From: "David E. Wheeler"
Date:
Subject: Re: Patch: Add parse_type Function