Hi Tom,
First of all thanks for the quick response. No, the arrival order will not
be deterministic. Here is how we ensure determinism.
1.) SQL requests are delivered to the replication agent in a specific total
order. This could occur either because they were already serialized by a
database
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 assum
Hi everyone,
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