Horton
Menu

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

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

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Josh Berkus <josh@agliodbs.com>
Cc: Jeff Janes <jeff.janes@gmail.com>, Boszormenyi Zoltan <zb@cybertec.at>, pgsql-hackers@postgresql.org, Alvaro Herrera <alvherre@commandprompt.com>, Bruce Momjian <bruce@momjian.us>, Hans-Juergen Schoenig <postgres@cybertec.at>, Sándor Miglécz <sandor@cybertec.at>
Date: 2009-09-23T16:20:31Z
Lists: pgsql-hackers 
Josh Berkus <josh@agliodbs.com> writes:
> Jeff,
>> Will statement_timeout not suffice for that use case?

> Well, currently statement_timeout doesn't affect waiting for locks.

Sure it does.

> And as a DBA, I don't think I'd want the same timeout for executing
> queries as for waiting for a lock.

Well, that's exactly what Jeff is questioning.  How big is the use-case
for that exactly?

			regards, tom lane