From: | Christoph Haller <ch(at)rodos(dot)fzk(dot)de> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: SELECT FOR UPDATE NOWAIT |
Date: | 2003-07-23 07:35:26 |
Message-ID: | 3F1E3ABE.D29A50F1@rodos.fzk.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>
> Rod Taylor wrote:
> -- Start of PGP signed section.
> > On Fri, 2003-07-18 at 19:46, Paulo Scardine wrote:
> > > My boss is asking for something like Oracle's "SELECT FOR UPDATE
NOWAIT".
> > >
> > > Is there any such feature? If no, should I look forward into
implementing
> > > this? Any advice?
> >
> > Lookup STATEMENT_TIMEOUT and set it to a very short time.
>
> Some people have said they want to distinguish between a slow query
> (busy system) and waiting on a lock. I can particulary see wanting to
> do a NOWAIT only on exclusive locks --- not sure how many really want
> that, though.
>
I think I'm a quite attentive to the SQL and HACKERS list, and I see
requests for a NOWAIT option at least once a month, and it's growing.
Regards, Christoph
From | Date | Subject | |
---|---|---|---|
Next Message | Christoph Haller | 2003-07-23 07:55:07 | Re: Exception table ... |
Previous Message | Kevin Brown | 2003-07-23 05:17:54 | Re: reprise on Linux overcommit handling |