Description
All query methods except simple_query
and batch_execute
use the postgres extended query protocol.
The extended query protocol implementation of rust-postgres currently performs execution in 3 network roundtrips:
- Parse, which creates a "named statement"/"prepared statement"
- Bind and Execute, which performs the planning and execution of the statement
- Close, which removes the prepared statement.
This can be reduced to 2 network roundtrips by not performing the prepared statement creation.
When an extended query statement is not prepared or named, it will use a so-called 'unnamed statement'. An unnamed statement essentially performs a lot of the same work of a named statement, with the striking difference that the unnamed statement does not need to be closed, and is automatically destroyed by the next parse or simply query execution.
There are two cases known to me currently that requires a named statement/prepared statement to exist:
- When a statement is explicitly prepared.
- When statements are pipelined, these have to be named in order to guarantee taking the correct query.
As far as I know currently in all other situations an unnamed statement would work fine.
Reference: #1017