Re: PostgreSQL-R

Поиск
Список
Период
Сортировка
От Darren Johnson
Тема Re: PostgreSQL-R
Дата
Msg-id 3E051C62.1000007@up.hrcoxmail.com
обсуждение исходный текст
Ответ на PostgreSQL-R  ("Mikheev, Vadim" <VMIKHEEV@sectordata.com>)
Список pgsql-hackers
>
>
>
>Next, pg-r was originally based on 6.4, so what was changed for
>current pg versions when MV is used for CC? It seems that locking
>tuples via LockTable at Phase 1 is not required anymore, right?
>

We haven't put those hooks in yet, so the current version is master/slave.  

>
>Upon receiving local WS in Phase 3 local transaction should just
>check that there are no conflicting locks from remote transactions
>in LockTable and can commit after that. Remote transactions will not
>see conflicts from local ones in LockTable but will notice them
>during execution and will be able to abort local transactions.
>(I hope I didn't miss something here.) Also it seems that we could
>perform Phases 2 & 3 periodically during transaction execution.
>This would make WS smaller and conflicts between long running
>transactions from different sites would be resoved faster.
>
>Comments?
>

Seems like a good idea to me, but we won't know for sure until we 
implement the multi-
master hooks.  

Thanks,

Darren

>
>
>




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

Предыдущее
От: Ryan Mahoney
Дата:
Сообщение: Re: plpgsql and index usage
Следующее
От: Gavin Sherry
Дата:
Сообщение: Re: Resource management in 7.4