Re: setPrepareThreshold - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: setPrepareThreshold
Date
Msg-id CADK3HHKRUxRO9_Lf_FKAmdf3jEW=DNLM1_jRL-n26LS6TjZE7A@mail.gmail.com
Whole thread Raw
In response to setPrepareThreshold  (Robert DiFalco <robert.difalco@gmail.com>)
List pgsql-jdbc
It defaults to 5. Basically if you reuse a prepared statement 5 times it will convert it from an unnamed portal to a named statement. Unnamed portals are automatically cleaned up after use. named statements have to be deallocated

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca


On Fri, Jan 17, 2014 at 10:31 AM, Robert DiFalco <robert.difalco@gmail.com> wrote:
I was wondering why this setting exists and why it is by default disabled? Is there some danger associated with it or some reason I would NOT want it to be set?  Thanks!

pgsql-jdbc by date:

Previous
From: Robert DiFalco
Date:
Subject: setPrepareThreshold
Next
From: Sehrope Sarkuni
Date:
Subject: Re: setPrepareThreshold