Postgres Pro
Downloads
Home   >   mailing lists

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

From John Sidney-Woollett
Subject Re: Ever increasing OIDs - gonna run out soon?
Date
Msg-id 448D9001.1010306@wardbrook.com
Whole thread Raw
In response to Re: Ever increasing OIDs - gonna run out soon?  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: Ever increasing OIDs - gonna run out soon?
Re: Ever increasing OIDs - gonna run out soon?
List pgsql-general
Tree view 
Jim C. Nasby wrote:
 > Except IIRC the OP is running 7.4 which doesn't have checks in DDL
 > code to deal with OID collisions. :(

This is not good news! :(

What about other long runing 7.4.x DBs? Do you really have to dump, init
and restore every once in a while?

Also, do you know what is actually using the OIDs - transactions?

John

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Disk corruption detection
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Ever increasing OIDs - gonna run out soon?