Re: Ever increasing OIDs - gonna run out soon?

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Ever increasing OIDs - gonna run out soon?
Date: 2006-06-12 02:01:43
Message-ID: e6ihu6$1fqo$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


"John Sidney-Woollett" <johnsw(at)wardbrook(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tatsuo Ishii 2006-06-12 02:39:13 Re: Pgpool-committers unsubscribe notification
Previous Message Qingqing Zhou 2006-06-12 01:56:41 Re: Disk corruption detection