Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: Prepared statements, parameters and logging


  • From: Dave Cramer <pg(at)fastcrypt(dot)com>
  • To: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
  • Cc: Postgres JDBC <pgsql-jdbc(at)postgresql(dot)org>
  • Subject: Re: Prepared statements, parameters and logging
  • Date: Mon, 25 Jun 2007 09:11:39 -0400
  • Message-id: <9537AA08-53BB-434E-9E62-F326AADED792@fastcrypt.com> <text/plain>

I think the text should be specifying that once you exceed preparedThreshold executions the driver uses a named prepared statement, and can re-use it. Otherwise it uses unnamed prepared statements which need to be prepared for each execution.

Dave
On 25-Jun-07, at 8:42 AM, Csaba Nagy wrote:

Dave,

If I read [1] correctly, the prepareThreshold parameter should actually
do what I want in protocol version 3... or am I misreading something ?

[1] http://jdbc.postgresql.org/documentation/81/server-prepare.html

Cheers,
Csaba.

On Mon, 2007-06-25 at 13:24, Dave Cramer wrote:
As far as I know you can't have both. In version 3 protocol,
everything is a server side prepared statement without parameters.



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings




Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group