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

From Jean-Christophe Arnu
Subject Re: FileFallocate misbehaving on XFS
Date
Msg-id CAHZmTm1MgBV4-SD_zG5LLG-pWHxGYQ=V7uYrNUhcdPd0gtYe-A@mail.gmail.com
Whole thread Raw
In response to Re: FileFallocate misbehaving on XFS  (Michael Harris <harmic@gmail.com>)
List pgsql-hackers
Hello Mike,

We encountered the same problem with a fixed allocsize=262144k. Removing this option seemed to fix the problem.We are now in an XFS managed allocation heuristic way.  The problem does not show up since the change was made on monday, but I'm not totally sure it has fixed the problem.
If we can provide you with more information, please let me know.



Le ven. 31 janv. 2025 à 00:53, Michael Harris <harmic@gmail.com> a écrit :
Hello All

An update on this.

Earlier in this thread, Jakub had suggested remounting the XFS
filesystems with the mount option allocsize=1m.
I've done that now, on a few systems that have been experiencing this
error multiple times a day, and it does seem to stop the errors from
occurring.
It has only been a few days, but it does look encouraging as a workaround.

From the xfs man page, it seems that manually setting allocsize turns
off the dynamic preallocation size heuristics that are normally used
by XFS.

The other piece of info is that we have raised a support ticket with
Redhat. I'm not directly in contact with them (it's another team that
handles that) but I will let you know of any developments.

Cheers
Mike




--
Jean-Christophe Arnu

pgsql-hackers by date:

Previous
From: Alena Rybakina
Date:
Subject: Re: POC, WIP: OR-clause support for indexes
Next
From: Yura Sokolov
Date:
Subject: Re: hash_search_with_hash_value is high in "perf top" on a replica