[Bucardo-general] Design of new txntime field

Ioana Danes ioanadanes at gmail.com
Mon Nov 9 15:19:47 UTC 2015


On Sat, Nov 7, 2015 at 9:38 PM, Greg Sabino Mullane <greg at endpoint.com>
wrote:

>
> > How about using 2 fields in the primary key. One the current txntime
> field
> > and one a serial id field.
>
> It's crossed my mind before, but that adds a good bit of complexity
> for too little gain.
>
> > Why even bother to use a PID when the postgres sequence does the job so
> well?
>
> Or more to the point, why use a timestamp at all when we could simply
> use a bigserial, full stop? I've toyed with this idea in the past. I think
> the big problem was the mental dififculty of giving up the nice
> human-readable way of viewing what was going on. But timestamps are not
> really needed - we just need a way to map between delta rows and
> track rows. So let's throw that idea into the mix too. Would certainly
> win the space and efficiency awards.
>
>
The bigint serial is the neatest idea so far.

> --
> Greg Sabino Mullane greg at endpoint.com
> End Point Corporation
> PGP Key: 0x14964AC8
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20151109/e342d010/attachment.html>


More information about the Bucardo-general mailing list