Re: 32/64-bit transaction IDs?
| От | Ed L. |
|---|---|
| Тема | Re: 32/64-bit transaction IDs? |
| Дата | |
| Msg-id | 200303211438.12046.pgsql@bluepolka.net обсуждение исходный текст |
| Ответ на | Re: 32/64-bit transaction IDs? (Tom Lane <tgl@sss.pgh.pa.us>) |
| Список | pgsql-general |
On Friday March 21 2003 11:53, Tom Lane wrote: > "Ed L." <pgsql@bluepolka.net> writes: > >> XIDs are issued in transaction start order, not transaction commit > >> order. Dunno if that's what's concerning you. > > > > Yes, I'm interested in any reliable ordering of transaction commits for > > the purpose of serial asyncronous replication. Is that possible? > > The order in which commit records are inserted into the WAL log would > work (and if you just need an ID number, the commit records' WAL-log > addresses are 64-bits and would serve nicely). But you'll have to add > code to the backend to get at that. A 64-bit serial ID number would suffice. I could spend a little time on that. Any starter hints on files/functions/structure of such an addition? Something akin to GetTransactionId()? Ed
В списке pgsql-general по дате отправления: