can we add SKIP LOCKED to UPDATE? - Mailing list pgsql-hackers

From 德哥
Subject can we add SKIP LOCKED to UPDATE?
Date
Msg-id 68135042.7944.150ea9df17e.Coremail.digoal@126.com
Whole thread Raw
Responses Re: can we add SKIP LOCKED to UPDATE?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

HI, 
   PostgreSQL 9.5 added skip locked to select for update to improve concurrency performance, but why not add it to update sql?
   this is an application case, some body will update a tuple at the same time, so the RT for waiter is big, I use function and select for update nowait or advisory lock , can improve concurrency , but it's not very pure for developer.

--
公益是一辈子的事,I'm Digoal,Just Do It.

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [PATCH] Refactoring of LWLock tranches
Next
From: Torsten Zuehlsdorff
Date:
Subject: Re: Extracting fields from 'infinity'::TIMESTAMP[TZ]