On Thu, May 28, 2009 at 11:49 PM, Kevin Grittner <kevin.gritt...@wicourts.gov> wrote: > The problem > is that the cost of a "perfect" predicate locking system is much > higher than the cost of letting some transaction block or roll back > for retry.
Surely that depends on how expensive it is to retry the transaction? Like, how much would it suck to find your big data load abort after 10 hours loading data? And how much if it didn't wasn't even selecting data which your data load conflicted with. -- greg -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
