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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Do TEMP Tables have an OID? Can this be a problem if used too frequently?
Дата
Msg-id 12082.1241190598@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Do TEMP Tables have an OID? Can this be a problem if used too frequently?  (Raymond O'Donnell <rod@iol.ie>)
Список pgsql-general
Дерево обсуждения 
"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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: recover corrupt DB?
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Connecting to a postgreSQL database with windows CE over wi-fi; failing gracefully