Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: can we add SKIP LOCKED to UPDATE?
Date
Msg-id 27324.1447088772@sss.pgh.pa.us
Whole thread Raw
In response to can we add SKIP LOCKED to UPDATE?  (德哥 <digoal@126.com>)
Responses Re: can we add SKIP LOCKED to UPDATE?  (Simon Riggs <simon@2ndQuadrant.com>)
Re: can we add SKIP LOCKED to UPDATE?  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
Tree view 
德哥 <digoal@126.com> writes:
>    PostgreSQL 9.5 added skip locked to select for update to improve concurrency performance, but why not add it to
updatesql?
 

Seems like you'd have unpredictable results from the update then.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Torsten Zuehlsdorff
Date:
Subject: Re: Extracting fields from 'infinity'::TIMESTAMP[TZ]
Next
From: Pavel Stehule
Date:
Subject: Re: proposal: multiple psql option -c