Horton
Menu

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

Boszormenyi Zoltan <zb@cybertec.at>

View thread
From: Boszormenyi Zoltan <zb@cybertec.at>
To: Greg Stark <stark@enterprisedb.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Hans-Juergen Schoenig <postgres@cybertec.at>, pgsql-hackers@postgresql.org
Date: 2009-05-11T19:48:31Z
Lists: pgsql-hackers 
Greg Stark írta:
> 2009/5/11 Boszormenyi Zoltan <zb@cybertec.at>:
>   
>> Does statement_timeout counts against subtransactions as well? No.
>> If a statement finishes before statement_timeout, does it also decrease
>> the possible runtime for the next statement? No. I was talking about
>> locks acquired during one statement.
>>     
>
> With respect I can't figure out what you're trying to say here.
>   

Sorry, bad rhetorics. Point correctly made is below.

>> He argued about he wants a timeout *independent* from statement_timeout
>> for locks only inside the same statement IIRC.
>>