Re: FileFallocate misbehaving on XFS - Mailing list pgsql-hackers

From Andres Freund
Subject Re: FileFallocate misbehaving on XFS
Date
Msg-id upk5jhrfhddjhre3mmrlugjzbb3vizk4wdrkbuadzvkuxcdhem@3eyroksmkyjr
Whole thread Raw
In response to Re: FileFallocate misbehaving on XFS  (Jakub Wartak <jakub.wartak@enterprisedb.com>)
List pgsql-hackers
Hi,

On 2024-12-16 14:45:37 +0100, Jakub Wartak wrote:
> On Thu, Dec 12, 2024 at 12:50 AM Andres Freund <andres@anarazel.de> wrote:
> An extended cycle of 80 backends copying into relations and occasionally
> > truncating them (to simulate the partitions being dropped and new ones
> > created). For this I ran a 4TB filesystem very close to fully filled
> > (peaking
> > at 99.998 % full).
> >
> 
> I could only think of the question: how many files were involved there ?

I varied the number heavily. From dozens to 10s of thousands. No meaningful
difference.


> Well IMHO we are stuck till Michael provides some more data (patch outcome,
> bpf and maybe other hints and tests).

Yea.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: FileFallocate misbehaving on XFS
Next
From: "Joel Jacobson"
Date:
Subject: Re: New "single" COPY format