| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Jakub Wartak <jakub(dot)wartak(at)enterprisedb(dot)com> |
| Cc: | Michael Harris <harmic(at)gmail(dot)com>, Tomas Vondra <tomas(at)vondra(dot)me>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: FileFallocate misbehaving on XFS |
| Date: | 2024-12-16 14:53:42 |
| Message-ID: | upk5jhrfhddjhre3mmrlugjzbb3vizk4wdrkbuadzvkuxcdhem@3eyroksmkyjr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)anarazel(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joel Jacobson | 2024-12-16 15:09:36 | Re: New "single" COPY format |
| Previous Message | Robert Haas | 2024-12-16 14:44:44 | Re: FileFallocate misbehaving on XFS |