>>> Simon Riggs <simon(at)2ndQuadrant(dot)com> wrote:
> If I was going to add anything to the btree page header, it would be
> latestRemovedLSN, only set during recovery. That way we don't have
> explicitly kill queries, we can do the a wait on OldestXmin then let
> them ERROR out when they find a page that has been modified.
> I have a suspicion that we may need some modification of that
> for all data blocks, so we don't kill too many queries.
If the failure is caused by the timing of various database
transactions, and the query is likely to run successfully after a
delay and a retry, please use SQLSTATE of '40001'. Some software
(ours, for one) will recognize this and retry the query automatically,
so that the user impact is essentially the same as blocking.
In response to
pgsql-hackers by date
|Next:||From: Simon Riggs||Date: 2008-12-19 18:06:20|
|Subject: Re: Hot standby and b-tree killed items|
|Previous:||From: Bruce Momjian||Date: 2008-12-19 17:00:41|
|Subject: Re: Updates of SE-PostgreSQL 8.4devel patches (r1324)|