Re: Re: Thought on OIDs - Mailing list pgsql-general

From Rod Taylor
Subject Re: Re: Thought on OIDs
Date
Msg-id 01ab01c0a331$36488060$6500000a@jester
Whole thread Raw
In response to Thought on OIDs  (Patrik Kudo <kudo@partitur.se>)
Responses Re: Re: Thought on OIDs
List pgsql-general
Someones bound to hit it in a year or 2 as Postgres is getting pretty
good for large projects as well as the small, especially with 7.1's
speed enhancements.  Hopefully 7.2 will create cycling OIDs and XIDs.
Then less problems in 'unlimited' extendability.
--
Rod Taylor

There are always four sides to every story: your side, their side, the
truth, and what really happened.
----- Original Message -----
From: "Martin A. Marques" <martin@math.unl.edu.ar>
To: "Patrik Kudo" <kudo@partitur.se>
Cc: <pgsql-general@postgresql.org>
Sent: Friday, March 02, 2001 9:52 AM
Subject: [GENERAL] Re: Thought on OIDs


> Quoting Patrik Kudo <kudo@partitur.se>:
>
> > Hi!
> >
> > A thought just hit me and I got a bit worried... If OIDs are
"globaly"
> > unique and I have a very high data-throughput on my database, i.e.
I do
> > a
> > lot of inserts and deletes, is it then possible to "run out" of
OIDs?
> > If
> > this can occur, will it cause any problems?
> >
> > Need I worry? =)
>
> Have you thought about how many inerts, time, etc you would need to
fill all the
> oids?
>
>
> System Administration: It's a dirty job,
> but someone told I had to do it.
> -----------------------------------------------------------------
> Martín Marqués                  email:  martin@math.unl.edu.ar
> Santa Fe - Argentina            http://math.unl.edu.ar/~martin/
> Administrador de sistemas en math.unl.edu.ar
> -----------------------------------------------------------------
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>


pgsql-general by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Re: Convert to upper
Next
From: Alasdair I MacLeod
Date:
Subject: Re: Triggered data change violation