From: | Jean-Christophe Arnu <jcarnu(at)gmail(dot)com> |
---|---|
To: | Michael Harris <harmic(at)gmail(dot)com> |
Cc: | Andres Freund <andres(at)anarazel(dot)de>, Robert Haas <robertmhaas(at)gmail(dot)com>, Jakub Wartak <jakub(dot)wartak(at)enterprisedb(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Tomas Vondra <tomas(at)vondra(dot)me>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: FileFallocate misbehaving on XFS |
Date: | 2025-01-31 14:33:08 |
Message-ID: | CAHZmTm1MgBV4-SD_zG5LLG-pWHxGYQ=V7uYrNUhcdPd0gtYe-A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Yura Sokolov | 2025-01-31 14:38:10 | Re: hash_search_with_hash_value is high in "perf top" on a replica |
Previous Message | Alena Rybakina | 2025-01-31 14:31:44 | Re: POC, WIP: OR-clause support for indexes |