Re: SELECT ... FOR UPDATE [WAIT integer | NOWAIT] for 8.5

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-hackers@postgresql.org
Date: 2009-05-11T23:25:44Z
Lists: pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> I can see Zoltan's argument: for web applications, it's important to 
> keep the *total* wait time under 50 seconds for most users (default 
> browser timeout for most is 60 seconds).

And why is that only about lock wait time and not about total execution
time?  I still think statement_timeout covers the need, or at least is
close enough that it isn't justified to make lock_timeout act like that
(thus making it not serve the other class of requirement).

			regards, tom lane