[Bucardo-general] Design of new txntime field

Greg Sabino Mullane greg at endpoint.com
Sun Nov 8 02:30:34 UTC 2015

On Fri, Nov 06, 2015 at 07:35:37AM -0700, Jon Jensen wrote:
> That's missing seconds, though, which are pretty important. :) I think you'd
> want:

Thanks! Obviously I wrote that in haste.

> I'm guessing that the varchar version would take way more disk space, and
> the index would be way bigger and slower.
> So I too wonder whether a composite 2-field primary key would be better.
> For the sake of completeness do we need to discuss the likelihood of getting
> the same PID at the same microsecond from two different machines? :)

I don't think so. These come from the forked backend, and on the same machine, 
so there is no way they can have the same PID.

Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20151107/c882f0e2/attachment.sig>

More information about the Bucardo-general mailing list