Re: [HACKERS] tables >2GB

Поиск
Список
Период
Сортировка
От Vadim B. Mikheev
Тема Re: [HACKERS] tables >2GB
Дата
Msg-id 34D02EDE.CC9EFBA8@sable.krasnoyarsk.su
обсуждение исходный текст
Ответ на 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.

Someday we'll get TABLESPACEs and fixed multi-chunk code could
allow to store chunks in different TABLESPACEs created on _different
disks_ - imho, ability to store a table on > 1 disk is good thing.

And so, I would suggest just add elog(ERROR) to mdextend() now,
with recommendation to increase RELSEG_SIZE...

Vadim

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: tables >2GB
Следующее
От: "Alexandr V. Goncharuk"
Дата:
Сообщение: (no subject)