Re: Hot standby and b-tree killed items

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Hot standby and b-tree killed items
Дата
Msg-id 20081220230954.GC3989@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Hot standby and b-tree killed items  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Append major version number and for libraries soname major
Следующее
От: Markus Wanner
Дата:
Сообщение: Re: Sync Rep: First Thoughts on Code