Re: OID Perfomance - Object-Relational databases - Mailing list pgsql-sql

From Josh Berkus
Subject Re: OID Perfomance - Object-Relational databases
Date
Msg-id web-1096365@davinci.ethosmedia.com
Whole thread Raw
In response to Re: OID Perfomance - Object-Relational databases  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: OID Perfomance - Object-Relational databases
List pgsql-sql
Tom,

> The trouble with pg_dump -o is that after reload, the OID
> generator
> will be set to max(any OID in the dumped data).  So a
> dump & reload
> doesn't do anything to postpone OID-wraparound Ragnarok.
> 
> As for the likelihood of overflow, figure 4G / tuple
> creation rate
> for your installation (not database, but whole
> installation controlled
> by one postmaster).  Unless your installation has just
> one active
> table, per-table sequence values look like a better bet.

Somebody (urgently) needs to tell all of the above to Bruce
Momjian (I've cc'd him); his book-in-the-making points up
OID's as a convenient and universal way to identify and link
tuples (chapter 7) and doen't mention these problems.  Who
can I bug about how useless the above makes OID's?

Thanks for the warning, and thanks Michael for the
suggestion; I'll use it and send you all back notes on how
it affects performance.

-Josh







pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: OID Perfomance - Object-Relational databases
Next
From: Michael Ansley
Date:
Subject: RE: OID Perfomance - Object-Relational databases