Robert Hodges <robert.hodges@[EMAIL PROTECTED]
> writes:
> This question may have an obvious answer I have somehow missed, but to
what
> extent is locking order deterministic in PostgreSQL? For example, if
> requests from multiple transactions arrive in some deterministic order
and
> acquire locks, can one assume that locks will be granted in the same
order
> if the requests are repeated at different times or on different servers?
Yeah, it should be deterministic given consistent arrival order.
> Lock determinism is an im****tant issue for replication algorithms that
> depend on database instances to behave as state machines.
However, the idea of depending on a replication algorithm that has race
conditions gives me the willies ... and that sure sounds like what you
are describing. Do not trust your data to the assumption that arrival
order will be deterministic.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
