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

Re: raising the default prepareTheshold

From: Kris Jurka <books(at)ejurka(dot)com>
To: Oliver Jowett <oliver(at)opencloud(dot)com>
Cc: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: raising the default prepareTheshold
Date: 2004-09-20 09:12:07
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc

On Sun, 19 Sep 2004, Oliver Jowett wrote:

> I'd like to raise the default prepareThreshold to some non-zero value, 
> perhaps 5 or so. This means that PreparedStatements that are used more 
> than 5 times will allocate and use a named backend statement.

Seems like a good idea and I think five is a nice conservative number.

At the same time do you think we should change the default fetchSize to
1000 or so?  Even though it only works for FORWARD_ONLY ResultSets it 
could reduce the number of complaints we see here without much penalty.  
Previously the cursor implementation was more limiting by ruling out 
server prepared statements.

Kris Jurka

In response to


pgsql-jdbc by date

Next:From: Kris JurkaDate: 2004-09-20 09:31:48
Subject: Re: Detecting SQL_ASCII databases
Previous:From: Csaba NagyDate: 2004-09-20 08:47:57
Subject: Re: "Idle in Transaction" revisited.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group