Re: OIDs as keys - Mailing list pgsql-performance

From Josh Berkus
Subject Re: OIDs as keys
Date
Msg-id 200302260917.24500.josh@agliodbs.com
Whole thread Raw
In response to Re: OIDs as keys  (daniel alvarez <d-alvarez@gmx.de>)
List pgsql-performance
Daniel,

> There can also be some problems when using replication, because one needs
> to make
> sure that OIDs are the same on all machines in the cluster.

See the "uniqueidentifier" contrib package if you need a universally unique id
for replication.

> I'd find it more natural if the column wasn't there
> at all.

Probably by Postgres 8.0, it won't be.

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: OIDs as keys
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Index File growing big.