[Bucardo-general] Design of new txntime field

[Greg Sabino Mullane]

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>