Re: Large files for relations

Поиск
Список
Период
Сортировка
От Jim Mlodgenski
Тема Re: Large files for relations
Дата
Msg-id CAB_5SRdVfQtrfos_UsfTAbK1-+pMBBAChVoGPwsnbzzZ3ynoZw@mail.gmail.com
обсуждение исходный текст
Ответ на Large files for relations  (Thomas Munro <thomas.munro@gmail.com>)
Ответы Re: Large files for relations  (Thomas Munro <thomas.munro@gmail.com>)
Список pgsql-hackers


On Mon, May 1, 2023 at 9:29 PM Thomas Munro <thomas.munro@gmail.com> wrote:

I am not aware of any modern/non-historic filesystem[2] that can't do
large files with ease.  Anyone know of anything to worry about on that
front? 

There is some trouble in the ambiguity of what we mean by "modern" and "large files". There are still a large number of users of ext4 where the max file size is 16TB. Switching to a single large file per relation would effectively cut the max table size in half for those users. How would a user with say a 20TB table running on ext4 be impacted by this change?  

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

Предыдущее
От: Kirk Wolak
Дата:
Сообщение: Re: v16 regression - wrong query results with LEFT JOINs + join removal
Следующее
От: Kirk Wolak
Дата:
Сообщение: Re: psql tests hangs