Re: [HACKERS] Feature thought: idle in transaction timeout

2007-04-02 Thread Hannu Krosing
Ühel kenal päeval, E, 2007-04-02 kell 19:36, kirjutas Joshua D. Drake: > Tom Lane wrote: > > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > >> Bruce Momjian wrote: > >>> Added to TODO: > >>> * Add idle_timeout GUC so locks are not held for log periods of time > > > >> That should actually be tran

Re: [HACKERS] Feature thought: idle in transaction timeout

2007-04-02 Thread Bruce Momjian
TODO updated: * Add idle_in_transaction_timeout GUC so locks are not held for long periods of time --- Joshua D. Drake wrote: > Tom Lane wrote: > > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > >> Bruce Momjian wrote:

Re: [HACKERS] Feature thought: idle in transaction timeout

2007-04-02 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Added to TODO: > * Add idle_timeout GUC so locks are not held for log periods of time BTW, before I forget it: there's a non-obvious consideration here, which is not breaking the query protocol. I suspect that we cannot send an unsolicited ERROR m

Re: [HACKERS] Feature thought: idle in transaction timeout

2007-04-02 Thread Joshua D. Drake
Tom Lane wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: Bruce Momjian wrote: Added to TODO: * Add idle_timeout GUC so locks are not held for log periods of time That should actually be transaction_idle_timeout. It is o.k. for us to be IDLE... it is not o.k. for us to be IDLE in Transac

Re: [HACKERS] Feature thought: idle in transaction timeout

2007-04-02 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > Bruce Momjian wrote: >> Added to TODO: >> * Add idle_timeout GUC so locks are not held for log periods of time > That should actually be transaction_idle_timeout. It is o.k. for us to > be IDLE... it is not o.k. for us to be IDLE in Transaction Or

Re: [HACKERS] Feature thought: idle in transaction timeout

2007-04-02 Thread Bruce Momjian
Fixed. --- Andrew Dunstan wrote: > Bruce Momjian wrote: > > Added to TODO: > > > > * Add idle_timeout GUC so locks are not held for log periods of time > > > > > > > > ITYM long periods. > > > cheers > > > andrew

Re: [HACKERS] Feature thought: idle in transaction timeout

2007-04-02 Thread Bruce Momjian
fixed. --- Joshua D. Drake wrote: > Bruce Momjian wrote: > > Added to TODO: > > > > * Add idle_timeout GUC so locks are not held for log periods of time > > > > That should actually be transaction_idle_timeout. It is

Re: [HACKERS] Feature thought: idle in transaction timeout

2007-04-02 Thread Andrew Dunstan
Bruce Momjian wrote: Added to TODO: * Add idle_timeout GUC so locks are not held for log periods of time ITYM long periods. cheers andrew ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://

Re: [HACKERS] Feature thought: idle in transaction timeout

2007-04-02 Thread Joshua D. Drake
Bruce Momjian wrote: Added to TODO: * Add idle_timeout GUC so locks are not held for log periods of time That should actually be transaction_idle_timeout. It is o.k. for us to be IDLE... it is not o.k. for us to be IDLE in Transaction Joshua D. Drake -

Re: [HACKERS] Feature thought: idle in transaction timeout

2007-04-02 Thread Bruce Momjian
Added to TODO: * Add idle_timeout GUC so locks are not held for log periods of time --- Tom Lane wrote: > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > > Russell Smith wrote: > >> I agree with this, it reduces th

Re: [HACKERS] Feature thought: idle in transaction timeout

2007-03-31 Thread Joshua D. Drake
Tom Lane wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: Russell Smith wrote: I agree with this, it reduces the long running transaction problem a little where the user forgot to commit/rollback their session. I may be worth having a transaction_timeout as well, and setting it to link a

Re: [HACKERS] Feature thought: idle in transaction timeout

2007-03-31 Thread Joshua D. Drake
Tom Lane wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: Russell Smith wrote: I agree with this, it reduces the long running transaction problem a little where the user forgot to commit/rollback their session. I may be worth having a transaction_timeout as well, and setting it to link a

Re: [HACKERS] Feature thought: idle in transaction timeout

2007-03-31 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > Russell Smith wrote: >> I agree with this, it reduces the long running transaction problem a >> little where the user forgot to commit/rollback their session. I may be >> worth having a transaction_timeout as well, and setting it to link a few >>

Re: [HACKERS] Feature thought: idle in transaction timeout

2007-03-31 Thread Joshua D. Drake
Russell Smith wrote: Joshua D. Drake wrote: Hello, I ran into an interesting problem with a customer today. They are running Jabber XCP (not the one we use). Unfortunately, the product has a bug that causes it to leave connections persistent in a transaction state. This is what it does: BE

Re: [HACKERS] Feature thought: idle in transaction timeout

2007-03-31 Thread Russell Smith
Joshua D. Drake wrote: Hello, I ran into an interesting problem with a customer today. They are running Jabber XCP (not the one we use). Unfortunately, the product has a bug that causes it to leave connections persistent in a transaction state. This is what it does: BEGIN; SELECT 1; Basica