Re: Large files for relations - Mailing list pgsql-hackers

From Jim Mlodgenski
Subject Re: Large files for relations
Date
Msg-id CAB_5SRdVfQtrfos_UsfTAbK1-+pMBBAChVoGPwsnbzzZ3ynoZw@mail.gmail.com
Whole thread Raw
In response to Large files for relations  (Thomas Munro <thomas.munro@gmail.com>)
Responses Re: Large files for relations  (Thomas Munro <thomas.munro@gmail.com>)
List 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 by date:

Previous
From: Kirk Wolak
Date:
Subject: Re: v16 regression - wrong query results with LEFT JOINs + join removal
Next
From: Kirk Wolak
Date:
Subject: Re: psql tests hangs