Re: Batch replication ordering (was Re: [GENERAL] 32/64-bit

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: Batch replication ordering (was Re: [GENERAL] 32/64-bit
Дата
Msg-id 3E983059.3CD1517B@Yahoo.com
обсуждение исходный текст
Ответ на 32/64-bit transaction IDs?  ("Ed L." <pgsql@bluepolka.net>)
Список pgsql-general
"Ed L." wrote:
> If the ordering I seek exists via the algorithm I've described, I don't

The right ordering is commit order, because that is the order that
played back serialized (without possible lock conflicts) guarantees the
same tuples hit.

Unfortunately I know of no sure way to tell the commit order. The
max(seqid) per transaction in ascending order would be a good
approximation at least.


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


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

Предыдущее
От: Shridhar Daithankar
Дата:
Сообщение: Re: How to drop column ?
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Batch replication ordering (was Re: [GENERAL] 32/64-bit