Server Prepared Statements

Motivation The PostgreSQL™ server allows clients to compile sql statements that are expected to be reused to avoid the overhead of parsing and planning the statement for every execution. This functionality is available at the SQL level via PREPARE and EXECUTE beginning with server version 7.3, and at the protocol level beginning with server version 7.4, but as Java developers we really just want t

[msykt]

“With 9.2, the planner will use specific plans regarding to the parameters sent (the query will be planned at execution), except if the query is executed several times and the planner decides that the generic plan is not too much more expensive than the specific plans.”

[k--kato]

なるほど 《Server Prepared Statements のプラン作成はサーバで一度だけ行われ，問い合わせの実行プラン再作成を毎回行うコストを抑える。 それは特定の値をプランナが使用する利点が活かせないことも意味する》