X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 114758B9EE3 for ; Fri, 18 Feb 2005 14:48:52 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 27394-08 for ; Fri, 18 Feb 2005 14:48:44 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 126E18B9B6C for ; Fri, 18 Feb 2005 14:48:47 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j1IEmkJW017941; Fri, 18 Feb 2005 09:48:46 -0500 (EST) To: "Spiegelberg, Greg" Cc: pgsql-admin@postgresql.org Subject: Re: OID assistance In-reply-to: <3482911A44F0C44EABC658E136A2E8073E974A@colmail01.cranel.local> References: <3482911A44F0C44EABC658E136A2E8073E974A@colmail01.cranel.local> Comments: In-reply-to "Spiegelberg, Greg" message dated "Fri, 18 Feb 2005 09:29:52 -0500" Date: Fri, 18 Feb 2005 09:48:46 -0500 Message-ID: <17940.1108738126@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/163 X-Sequence-Number: 16331 "Spiegelberg, Greg" writes: > It's come to our attention that in 14-16 days our OID's will wrap around and > we need some advice. Are you actually using the OIDs for anything? If not, don't worry about it. Unless you are actually depending on OIDs to be unique in some of your user tables, wraparound shouldn't matter. The only possible bad consequence is that you might once in a while get a collision in the system tables (eg, a CREATE TABLE fails because the OID generated for the table conflicts with an existing table). The odds of that are small enough that it's probably not going to be as much of a problem as a dump/reload would be. Just retry the transaction and it'll usually work the next time. regards, tom lane