Re: Order of update - Mailing list pgsql-general

From Peter J. Holzer
Subject Re: Order of update
Date
Msg-id 20250420105906.ya2safyc66vhi7j3@hjp.at
Whole thread Raw
In response to Order of update  (Thiemo Kellner <thiemo@gelassene-pferde.biz>)
Responses Re: Order of update
List pgsql-general
On 2025-04-20 11:34:56 +0200, Thiemo Kellner wrote:
> Very interesting. But is the sort overhead worth it? Why not make the
> constraint deferrable before the update and switch back afterwards?

Mostly idle curiosity whether that's possible at all.

But there might be other reasons why you want to do updates in a
predictable order. For example to prevent deadlocks.

        hjp

--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

Attachment

pgsql-general by date:

Previous
From: Thiemo Kellner
Date:
Subject: Order of update
Next
From: Thiemo Kellner
Date:
Subject: Re: Order of update