Postgres Pro
Downloads
Home   >   mailing lists

Re: Do TEMP Tables have an OID? Can this be a problem if used too frequently? - Mailing list pgsql-general

From Tom Lane
Subject Re: Do TEMP Tables have an OID? Can this be a problem if used too frequently?
Date
Msg-id 12082.1241190598@sss.pgh.pa.us
Whole thread Raw
In response to Re: Do TEMP Tables have an OID? Can this be a problem if used too frequently?  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
Tree view 
"Raymond O'Donnell" <rod@iol.ie> writes:
> On 30/04/2009 10:01, Phil Couling wrote:
>> If so am I right to assume that, if the function is used too frequently,
>> it could cause the database to crash by wraping OIDs?

> I'd imagine that this depends on how often the database is VACUUMed.

Wrapping around the OID counter does not create any problem in any
reasonably modern version of Postgres.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: recover corrupt DB?
Next
From: Peter Geoghegan
Date:
Subject: Re: Connecting to a postgreSQL database with windows CE over wi-fi; failing gracefully