We're have the postgres logging on for long running queries... nothing takes 
more than a few seconds.

-Mike


From: Karl Gretton [mailto:[email protected]]
Sent: Wednesday, March 06, 2013 12:06 PM
To: Michael Gargano
Cc: WebObjects-Dev List ([email protected])
Subject: Re: postgres jdbc driver

Michael,

Did my suggestion about the statement_timeout help at all?  If you have queries 
that run for a long time, the statement will time out and Postgres will close 
the connection.  There are both statement and connection timeout parameters in 
the PG conf file.

Karl

On 6 Mar 2013, at 08:37, Michael Gargano 
<[email protected]<mailto:[email protected]>> wrote:


Hi all,

                Just taking a quick survey of folks using postgres.  I think 
we've found an issue with the jdbc driver (any version within the last year or 
so).
                Since people don't update the jdbc drivers too frequently.
                What version of driver are you on?   Has it been stable under 
heavy load?

Thanks.
-Mike

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      
([email protected]<mailto:[email protected]>)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/kgretton%40mac.com

This email sent to [email protected]<mailto:[email protected]>

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to