Re: Guarantee order of batched pg_advisory_xact_lock

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Nico Heller <nico(dot)heller(at)posteo(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Guarantee order of batched pg_advisory_xact_lock
Date: 2026-02-11 22:49:57
Message-ID: 101916.1770850197@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Nico Heller <nico(dot)heller(at)posteo(dot)de> writes:
> So it would probably be better to ORDER BY the hashtextended result
> instead of :keysToLock, right?

Yeah, that seems like it'd work, if you have no other dependencies
on the locking order.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nico Heller 2026-02-12 11:18:34 Re: Guarantee order of batched pg_advisory_xact_lock
Previous Message Nico Heller 2026-02-11 21:51:40 Re: Guarantee order of batched pg_advisory_xact_lock