Re: [SQL] maximum number of rows in table - what about oid limits?

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: [SQL] maximum number of rows in table - what about oid limits?
Дата
Msg-id Pine.BSF.4.21.0106061454140.17516-100000@megazone23.bigpanda.com
обсуждение исходный текст
Список pgsql-general
> my question is, since oid's are used by the
> postgres kernel, what effect does oid wrapping have upon
> the stability of the database.  for example, does oid wrapping mean
> i might clash with oid's in the system tables.

Let me try again.  I've been having problems trying to write it out
I fear.

AFAIK, the only real clashes you have to worry about are oid clashes
between rows within the same system table that have unique constraints
on oid.  That means that your table rows shouldn't conflict, and you
shouldn't even get conflicts between different system tables.  So,
you could get a conflict when say creating a table between an old
pg_class row and the one that was going to be created and the
create table would fail and need to be tried again, but if you
had a pg_class row oid 10000, and 100 other rows with oid 10000
in your own tables there's no conflict.


В списке pgsql-general по дате отправления:

Предыдущее
От: Martín Marqués
Дата:
Сообщение: Re: [HACKERS] something smells bad
Следующее
От: Bruno Wolff III
Дата:
Сообщение: using create constraint trigger