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
>