Re: OIDs as keys

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: daniel alvarez <d-alvarez(at)gmx(dot)de>, Richard Huxton <dev(at)archonet(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: OIDs as keys
Date: 2003-02-26 17:17:24
Message-ID: 200302260917.24500.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-02-27 01:19:32 Re: Index File growing big.
Previous Message Richard Huxton 2003-02-26 16:10:13 Re: OIDs as keys