On Sat, Nov 7, 2015 at 9:38 PM, Greg Sabino Mullane <[email protected]> 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 [email protected] > End Point Corporation > PGP Key: 0x14964AC8 >
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
