Re: OID's.... - Mailing list pgsql-general

From Thalis A. Kalfigopoulos
Subject Re: OID's....
Date
Msg-id Pine.LNX.4.21.0105301453400.317-100000@aluminum.cs.pitt.edu
Whole thread Raw
In response to OID's....  ("Steve Wolfe" <steve@iboats.com>)
List pgsql-general

On Wed, 30 May 2001, Steve Wolfe wrote:

>
>   I know that this topic comes up fairly often, so I tried to search the
> archives, but the search engine doesn't appear to have info on messages
> after 1999, so forgive me for repeating this topic.
>
>    Recently, our OID usage has started to jump dramatically - today, we're
> using ten thousand or more in a few minutes.  We're trying to figure out
> just what is using so many, without any luck.  Aside from doing a lot of
> inserts (which we don't do many of), what would cause this?  Are they
> pre-allocated for transactions and not freed?
>
>    Also, when the OID's reach the limit of an int4, if I recall correctly,
> they simply wrap around, and things keep working unless you depend on
> unique OID's.  Is that correct?

That's correct.

cheers,
t.

p.s. and rumor has it that the universe will start shrinking as soon as this happens ;-)


pgsql-general by date:

Previous
From: "Thalis A. Kalfigopoulos"
Date:
Subject: Re: Indexes
Next
From: "Steve Wolfe"
Date:
Subject: Re: OID's....