On 11/25/05 9:12 PM, "Stephan Szabo" <[EMAIL PROTECTED]> wrote:
> The latter, the row locks before were single owner and were such that a
> second lock request for the same row would wait for the first to be
> released. Now effectively you have two levels of locks at the row level,
> the weaker of which conflicts with the stronger but not with itself.
Now I understand. Thanks for clarifying.
It sounds like there may be some performance improvements that will be
beneficial to us also. Hopefully I can convince them to agree to the 8.1
upgrade. Besides verifying our application, it takes a full weekend to do
the dump/load - the database is just under a billion rows.
Wes
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
