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

From Michael Harris
Subject Re: FileFallocate misbehaving on XFS
Date
Msg-id CADofcAXJxdXQZvPdMvbW_f1ASNhrrKV0dhrMQLyo2DZZ85=wMg@mail.gmail.com
Whole thread Raw
In response to Re: FileFallocate misbehaving on XFS  (Andres Freund <andres@anarazel.de>)
Responses Re: FileFallocate misbehaving on XFS
List pgsql-hackers
Hi Andres

On Tue, 10 Dec 2024 at 03:31, Andres Freund <andres@anarazel.de> wrote:
> Were those pg_upgrades done with pg_upgrade --clone? Or have been, on the same
> filesystem, in the past?

No, our procedure is to use --link.

> I found some references for bugs that were fixed in 5.13. But I think at least
> some of this would persist if the filesystem ran into the issue with a kernel
> before those fixes. Did you upgrade "in-place" from Rocky Linux 8?

We generally don't use "in place" OS upgrades - however we would
usually have the databases on separate filesystem(s) to the OS, and
those filesystem(s) would be preserved through the upgrade, while the
root fs would be scratched.
A lot of the cases reported are on RL8. I will try to find out the
history of the RL9 cases to see if the filesystems started on RL8.

Could you please provide me links for the kernel bugs you are referring to?

Cheers
Mike.



pgsql-hackers by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: unused-but-set-variable warning on REL_13_STABLE
Next
From: Tomas Vondra
Date:
Subject: Re: psql: Add tab completion for ALTER USER RESET