locking order

From: Torsten Förtsch <torsten(dot)foertsch(at)gmx(dot)net>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: locking order
Date: 2014-06-12 20:15:59
Message-ID: 539A0A7F.2090708@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

when a row is updated a RowExclusiveLock is obtained on the updated row
and on every related index.

Is the order in which these locks are acquired defined in some way?

Thanks,
Torsten

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Grittner 2014-06-12 20:32:45 Re: max_connections reached in postgres 9.3.3
Previous Message Christopher Nielsen 2014-06-12 19:57:24 Spurious Stalls