[HACKERS] transaction timeout

2001-03-16 Thread Kevin T. Manley
Is there a timeout setting I can use to abort transactions that aren't deadlocked, but which have been blocked waiting for locks greater than some amount of time? I didn't see anything in the docs on this and observed with 2 instances of psql that a transaction waiting on a lock seems to wait fore

Re: [HACKERS] WAL & SHM principles

2001-03-12 Thread Kevin T. Manley \(Home\)
""Mikheev, Vadim"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > It is possible to build a logging system so that you mostly don't care > > when the data blocks get written; a particular data block on disk is > > considered garbage until the next checkpoint