On Thu, Sep 07, 2017 at 12:00:37PM -0400, Ioana Danes wrote: > ... I changed the code by adding a bigint txnid in addition to the txntime > and > I am using it for everything except conflict resolution where I am still > using > the txntime. I have it running on 9 production sites for the past 1-2 years > and > the performance is great. ...
Excellent, glad to hear that solution is working for you. I've done some more testing, and it looks like the new way will be changing the txntime column from timestamp to text, and the default changed to now()::timestamp || txid_current()::text. Some big wins from this choice: * Still allows conflict resolution, as it's just basically a timestamp with some added numbers * Guaranteed unique as the txnid acts like a global sequence * Same value for the same transaction * Still human-readable * Very easy to upgrade existing installations - the timestamp and timestamp+txid can coexist peacefully -- Greg Sabino Mullane [email protected] End Point Corporation PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
Description: PGP signature
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
