Horton
Menu

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

Josh Berkus <josh@agliodbs.com>

View thread
From: Josh Berkus <josh@agliodbs.com>
To: Jeff Janes <jeff.janes@gmail.com>
Cc: 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>, Tom Lane <tgl@sss.pgh.pa.us>, Sándor Miglécz <sandor@cybertec.at>
Date: 2009-09-23T16:12:41Z
Lists: pgsql-hackers 
Jeff,

> Will statement_timeout not suffice for that use case?

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

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

-- 
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com