Re: Do TEMP Tables have an OID? Can this be a problem if used too frequently?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: rod(at)iol(dot)ie
Cc: Phil Couling <couling(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Do TEMP Tables have an OID? Can this be a problem if used too frequently?
Date: 2009-05-01 15:09:58
Message-ID: 12082.1241190598@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Raymond O'Donnell" <rod(at)iol(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Geoghegan 2009-05-01 15:31:25 Re: Connecting to a postgreSQL database with windows CE over wi-fi; failing gracefully
Previous Message Tom Lane 2009-05-01 15:04:24 Re: recover corrupt DB?