| From: | Boszormenyi Zoltan <zb(at)cybertec(dot)at> |
|---|---|
| To: | David Johnston <polobo(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Curosity question regarding "LOCK" NOWAIT |
| Date: | 2012-09-22 07:29:22 |
| Message-ID: | 505D68D2.9010801@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
2012-09-22 04:43 keltezéssel, David Johnston írta:
>
> Has there been any discussion regarding adding a time-limited version of NOWAIT, say:
> "WAITONLY 50" (milliseconds), when dealing the explicit LOCK TABLE or the
> SELECT...FOR(SHARE|UPDATE) commands?
>
> David J.
>
we have a proposed patch for 9.3 at
http://archives.postgresql.org/message-id/50339B3D.8040403@cybertec.at
that adds "SET lock_timeout = N;" to have a time-limited wait for locks.
Best regards,
Zoltán Böszörményi
--
----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt, Austria
Web: http://www.postgresql-support.de
http://www.postgresql.at/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Boszormenyi Zoltan | 2012-09-22 08:01:37 | Re: Curosity question regarding "LOCK" NOWAIT |
| Previous Message | Jasen Betts | 2012-09-22 07:23:13 | Re: RFE: Column aliases in WHERE clauses |