Re: is PG able to handle a >500 GB Database?

Поиск
Список
Период
Сортировка
От Martin A. Marques
Тема Re: is PG able to handle a >500 GB Database?
Дата
Msg-id 01012218190104.06366@math.unl.edu.ar
обсуждение исходный текст
Ответ на Re: is PG able to handle a >500 GB Database?  (Florent Guillaume <efgeor@noos.fr>)
Ответы Re: is PG able to handle a >500 GB Database?  (Florent Guillaume <efgeor@noos.fr>)
Список pgsql-general
El Lun 22 Ene 2001 17:56, Florent Guillaume escribió:
> > > select recordid from t1 where oid = $lastoid;
> > > Because the last select could return several lines.
> >
> > Shouldn't! oids are unique over the whole database server (I'm right on
> > this?) So you should have only one or non.
>
> Well, no, that's the point of this whole discussion. If you give it
> enough time, oids can wrap around, which apparently doesn't affect the
> functionning of the database but application that depend on unique oids
> could get hosed.
>
> Yes, the documentation is wrong.

Wow. I guess we need to hear what the developers have to say. AFAITIK oids
were unique. This paints a new panorama for me. :-( (not a very good one).

Saludos... :-)

--
System Administration: It's a dirty job,
but someone told I had to do it.
-----------------------------------------------------------------
Martín Marqués            email:     martin@math.unl.edu.ar
Santa Fe - Argentina        http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

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

Предыдущее
От: shawn everett
Дата:
Сообщение: Views
Следующее
От: Alfred Perlstein
Дата:
Сообщение: Re: [HACKERS] Re: postgres memory management