Re: OID's....

From: "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu>
To: Steve Wolfe <steve(at)iboats(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: OID's....
Date: 2001-05-30 20:30:06
Message-ID: Pine.LNX.4.21.0105301453400.317-100000@aluminum.cs.pitt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ;-)

In response to

  • OID's.... at 2001-05-30 18:18:12 from Steve Wolfe

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thalis A. Kalfigopoulos 2001-05-30 20:31:38 Re: Indexes
Previous Message Mitch Vincent 2001-05-30 20:25:04 Re: Indexes