Re: [HACKERS] tables >2GB

Поиск
Список
Период
Сортировка
От Mattias Kregert
Тема Re: [HACKERS] tables >2GB
Дата
Msg-id 35125A0A.5FF611AE@algonet.se
обсуждение исходный текст
Ответ на Re: [HACKERS] tables >2GB  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian wrote:
>
> >
> > Now that we know the storage manager code that splits tables over 2GB
> > into separate files doesn't work(Irix), can we rip out that code and
> > just use the OS code to access >2GB files as normal files.  Now, most
> > OS's can support 64-bit files and file sizes.
> >
> > Because it is isolated in the storage manager, it should be easy.
>
> Can someone knowledgeable make a patch for this for our mega-patch?

But, could it not be useful to be able to use multiple files per
table? Suppose someone wants to spread them out on different
disks to increase access performance?

And what about tables over 2^64 bytes size? There will never be
disks of that size? Now, remember what people said about 2^32 byte
files, and years after 1999, and 64k RAM, and about all inventions
already being invented, and... :)

/* m */

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

Предыдущее
От: Michael Meskes
Дата:
Сообщение: Re: AW: [HACKERS] Begin statement again
Следующее
От: Massimo Dal Zotto
Дата:
Сообщение: Re: [HACKERS] Re: [PATCHES] patches for 6.2.1p6