Re: Hot standby and b-tree killed items - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Hot standby and b-tree killed items
Date
Msg-id 20081220230954.GC3989@alvh.no-ip.org
Whole thread Raw
In response to Re: Hot standby and b-tree killed items  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: Hot standby and b-tree killed items  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Re: Hot standby and b-tree killed items  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Heikki Linnakangas wrote:
> Gregory Stark wrote:
>> A vacuum being replayed -- even in a different database -- could trigger the
>> error. Or with the btree split issue, a data load -- again even in a different
>> database -- would be quite likely cause your SELECT to be killed.
>
> Hmm, I wonder if we should/could track the "latestRemovedXid" separately  
> for each database. There's no reason why we need to kill a read-only  
> query in database X when a table in database Y is vacuumed.

What about shared catalogs?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: [COMMITTERS] pgsql: Append major version number and for libraries soname major
Next
From: Markus Wanner
Date:
Subject: Re: Sync Rep: First Thoughts on Code