Re: Ever increasing OIDs - gonna run out soon? - Mailing list pgsql-general

From Qingqing Zhou
Subject Re: Ever increasing OIDs - gonna run out soon?
Date
Msg-id e6ihu6$1fqo$1@news.hub.org
Whole thread Raw
In response to Ever increasing OIDs - gonna run out soon?  (John Sidney-Woollett <johnsw@wardbrook.com>)
Responses Re: Ever increasing OIDs - gonna run out soon?
List pgsql-general
"John Sidney-Woollett" <johnsw@wardbrook.com> wrote
>
> It looks like the db is using them at the rate of 1.5 million per day.
> At what value will I hit a wraparound, and what options do I have to
> identify/fix the (impending) problem.
>

The Oid will wraparound when it reaches the 32bits unsigned integer limit.
If you don't use the oid explicitely in your application, then you don't
worry about it.

Regards,
Qingqing



pgsql-general by date:

Previous
From: "Qingqing Zhou"
Date:
Subject: Re: Disk corruption detection
Next
From: Tatsuo Ishii
Date:
Subject: Re: Pgpool-committers unsubscribe notification