serial + db key, or guid?

From: Mark Phillips <mark(dot)phillips(at)mophilly(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: serial + db key, or guid?
Date: 2020-08-10 22:19:52
Message-ID: 7D67E902-4581-4380-903E-92ECAA9B3866@mophilly.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Given four instances of posgres, each with a database, each instance receiving new data, and desiring a data “merge” a la BDR or similar multiple database solutions, my team has been discussing the pros and cons of generating unique keys in each table.

1. create a unique “database” id for each database, add a column to all tables for this id value and combine that with a serial id
2. use guid from pg functions
3. create id ranges for each database, e.g. db1 gets 1 to 1M, db2 gets 1M+1 to 2M, and so on

All get us to the finish line, but each has its drawbacks.

Advice, cautionary tales, suggestions and such will be warmly received.

- Mark

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2020-08-10 22:21:34 Re: serial + db key, or guid?
Previous Message John W Higgins 2020-08-10 21:30:48 Re: UUID or auto-increment