Re: Conservation of OIDs - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Conservation of OIDs
Date
Msg-id 20031114190727.GB25386@dcc.uchile.cl
Whole thread Raw
In response to Re: Conservation of OIDs  (<btober@seaworthysys.com>)
List pgsql-general
On Fri, Nov 14, 2003 at 01:37:50PM -0500, btober@seaworthysys.com wrote:

> > If you're really concerned, you can initdb separate clusters for QAT
> > and DEV and run three postmasters using three different ports.
>
> Follow-up question: Are different ports really necessary?

No, and it will be probably a waste of shared_buffers too.  IMHO you
should keep them under a single postmaster, and forget about the OID
wraparound problem.  It won't be a problem for you anyway, because if
you create the whole DB from scratch you won't have OID collision
anyway, even on year 2030 when your OIDs really do wrap around.  Maybe by
then we will have 8 bit OIDs anyway, and you will surely initdb way
before that.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Las mujeres son como hondas:  mientras más resistencia tienen,
más lejos puedes llegar con ellas"  (Jonas Nightingale, Leap of Faith)

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Conservation of OIDs
Next
From: Vivek Khera
Date:
Subject: Re: More Praise for 7.4RC2