PostgreSQL surrogate keys: use sequence/bigint or OID?

1 vote

2 answers

6092 views

postgresql database-design sequence surrogate-key citus

                          I'm looking at a need for surrogate keys in tables I'm designing on a PostgreSQL-derived DBMS (Citus ). Would OIDs suffice? Is there a downside to using them instead of creating a bigint field and a sequence?
                        

Asked by Andrew Wolfe (584 rep)

Feb 1, 2016, 05:43 PM
Last activity: Sep 27, 2021, 12:04 AM

PostgreSQL surrogate keys: use sequence/bigint or OID?

Related Questions