Re: Large files for relations

From: Jim Mlodgenski <jimmy76(at)gmail(dot)com>
To: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Large files for relations
Date: 2023-05-11 20:16:37
Message-ID: CAB_5SRdVfQtrfos_UsfTAbK1-+pMBBAChVoGPwsnbzzZ3ynoZw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, May 1, 2023 at 9:29 PM Thomas Munro <thomas(dot)munro(at)gmail(dot)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?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kirk Wolak 2023-05-11 20:37:52 Re: psql tests hangs
Previous Message Kirk Wolak 2023-05-11 20:16:01 Re: v16 regression - wrong query results with LEFT JOINs + join removal