Re: [HACKERS] Problems with >2GB tables on Linux 2.0

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: [HACKERS] Problems with >2GB tables on Linux 2.0
Дата
Msg-id 36BC3797.A103FBA@trust.ee
обсуждение исходный текст
Ответ на Problems with >2GB tables on Linux 2.0  (gjerde@icebox.org)
Ответы Re: [HACKERS] Problems with >2GB tables on Linux 2.0  (Peter T Mount <peter@retep.org.uk>)
Список pgsql-hackers
Thomas Reinke wrote:
> 
> I may be dating myself really badly here, but isn't there a hard limit
> on
> the file system at 2Gig? I thought the file size attribute in Unix is
> represented as a 32 bit signed long, which happens to be a max value
> of 2147483648. If I'm right, it means the problem is fundamentally
> with the file system, not with PostGres, and you won't solve this
> unless the os supports larger files.

There is logic insid PostgreSQL to overflof to nex file at 2GB, but 
apparently this is currently broken.

AFAIK, there are people working on it now

--------------
Hannu


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

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: Re: [HACKERS] Problems with >2GB tables on Linux 2.0
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Optimizer speed and GEQO (was: nested loops in joins)