| Subject | Re: Holding a connection open forever |
|---|---|
| Author | |
| Post date | 2015-10-21T13:00:13Z |
Hi Tim,
In response to your questions:
We had a similar issue with long running connections, and finally resorted to dropping the connection periodically.
One thing I noticed in our gstat -h output was that the oldest transaction number was not moving forward. I could not never figure out why. We use auto commit and ODBC, not explicit transactions. Dropping the connection every few hours resolved our problem.
Liz Watson
In response to your questions:
What are the implications of holding a connection to the database open
forever (and running millions and millions of tiny transactions flat out
through that connection)?
What difference would it make if we dropped the connection periodically?
forever (and running millions and millions of tiny transactions flat out
through that connection)?
What difference would it make if we dropped the connection periodically?
We had a similar issue with long running connections, and finally resorted to dropping the connection periodically.
One thing I noticed in our gstat -h output was that the oldest transaction number was not moving forward. I could not never figure out why. We use auto commit and ODBC, not explicit transactions. Dropping the connection every few hours resolved our problem.
Liz Watson