Re: Transaction Snapshots and Hot Standby

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Transaction Snapshots and Hot Standby
Дата
Msg-id 48C9560C.8040902@enterprisedb.com
обсуждение исходный текст
Ответ на Re: Transaction Snapshots and Hot Standby  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-hackers
Gregory Stark wrote:
> Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
> 
>> BTW, we haven't talked about how to acquire a snapshot in the slave. You'll
>> somehow need to know which transactions have not yet committed, but will in the
>> future. 
> 
> I'm not sure why you need to know which ones will commit in the future.

Hmm, I phrased that badly. We need to know which transactions *might* 
commit in the future, IOW, are still in progress. Because we want to 
mark those as in-progress in the snapshots that are taken in the slave. 
Otherwise, when they do commit, they will suddenly become visible in the 
snapshots that didn't know that they were in progress.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: What is d2mdir?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] to_date() validation