Re: Large files for relations

Jim Mlodgenski <jimmy76@gmail.com>

From: Jim Mlodgenski <jimmy76@gmail.com>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2023-05-11T20:16:37Z
Lists: 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?