Re: Slowness of extended protocol - Mailing list pgsql-hackers

From Vladimir Sitnikov
Subject Re: Slowness of extended protocol
Date
Msg-id CAB=Je-FzPCQuwzrt4ZT8bHWpFYazKiCMs0MN9WCGgBFviRPqsQ@mail.gmail.com
Whole thread Raw
In response to Re: Slowness of extended protocol  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Responses Re: Slowness of extended protocol  (Tatsuo Ishii <ishii@sraoss.co.jp>)
List pgsql-hackers
Tatsuo>understanding it always uses unnamed portal even if the SQL is like
"BEGIN" or "COMMIT" (no parameters). They are too often used. Why not
doing like this?

Does it actually work?

The documentation says named portals last till the end of the transaction:

https://www.postgresql.org/docs/9.5/static/protocol-flow.html#PROTOCOL-FLOW-EXT-QUERY 

doc>If successfully created, a named portal object lasts till the end of the current transaction, unless explicitly destroyed

Vladimir

pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Exporting more function in libpq
Next
From: Michael Paquier
Date:
Subject: Re: Password identifiers, protocol aging and SCRAM protocol