On Thu, May 28, 2009 at 11:49 PM, Kevin Grittner
> 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.
In response to
pgsql-hackers by date
|Next:||From: Joshua Tolley||Date: 2009-05-28 23:20:39|
|Subject: Re: Dtrace probes documentation|
|Previous:||From: Tom Lane||Date: 2009-05-28 22:52:21|
|Subject: Re: pg_migrator and an 8.3-compatible tsvector data type |