Re: Thought on OIDs

From: "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar>
To: Patrik Kudo <kudo(at)partitur(dot)se>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Thought on OIDs
Date: 2001-03-02 14:52:53
Message-ID: 983544773.3a9fb3c517f76@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Quoting Patrik Kudo <kudo(at)partitur(dot)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(at)math(dot)unl(dot)edu(dot)ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2001-03-02 14:56:43
Previous Message Tom Lane 2001-03-02 14:51:45 Re: Trigger Blunder