Re: 4 billion record limit?

Поиск
Список
Период
Сортировка
От Chris Bitmead
Тема Re: 4 billion record limit?
Дата
Msg-id 3980CDD8.48DF0C1D@nimrod.itg.telecom.com.au
обсуждение исходный текст
Ответ на 4 billion record limit?  (Paul Caskey <paul@nmxs.com>)
Список pgsql-general
brad wrote:
>
> Mathieu Arnold wrote:
>
> > Chris Bitmead wrote:
> > >
> >
> > > Any complex scheme to solve this seems like a waste of time. In a couple
> > > of years when you are likely to be running out, you'll probably be
> > > upgrading your computer to a 64bit one with a newer version of postgres,
> > > and then the problem will disappear.
> >
> > that's the kind of thing people said about y2k, isn't it ?
> I don't want to start a war but I must agree here... I recoil when the
> argument is put forward for a "you will never use that up" approach.
> The best that I can offer is: Oh yeah? Seen some of the Beowulf clusters
> around recently?

Regardless, the solution is not to make a complex oid reuse scheme. The
solution is 64bit oids which is easily solved on a 64bit computer, but
requires a bit of effort to make it work on 32bit machines. If you want
to make the effort - go for it!

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

Предыдущее
От: Chris Jones
Дата:
Сообщение: Re: 4 billion record limit?
Следующее
От: John McKown
Дата:
Сообщение: Problems with insert (fwd)