Re: [HACKERS] Deterministic locking in PostgreSQL

2008-05-09 Thread Robert Hodges
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

Re: [HACKERS] Deterministic locking in PostgreSQL

2008-05-09 Thread Tom Lane
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

[HACKERS] Deterministic locking in PostgreSQL

2008-05-09 Thread Robert Hodges
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