Skip site navigation (1) Skip section navigation (2)

Re: Hot standby and b-tree killed items

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Simon Riggs" <simon(at)2ndQuadrant(dot)com>,"Heikki Linnakangas" <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Hot standby and b-tree killed items
Date: 2008-12-19 17:54:18
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
>>> 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 RiggsDate: 2008-12-19 18:06:20
Subject: Re: Hot standby and b-tree killed items
Previous:From: Bruce MomjianDate: 2008-12-19 17:00:41
Subject: Re: Updates of SE-PostgreSQL 8.4devel patches (r1324)

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group