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

From Steve Wolfe
Subject OID's....
Date
Msg-id 002001c0e934$e6edf6e0$50824e40@iboats.com
Whole thread Raw
Responses Re: OID's....  ("Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>)
Re: OID's....  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
  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?

steve



pgsql-general by date:

Previous
From: "Tim Barnard"
Date:
Subject: Re: Things are terribly quiet
Next
From: newsreader@mediaone.net
Date:
Subject: dumping strategy