Message-ID: <a8eb3c29-d6ed-44e5-a563-e33f43c8444b@dunslane.net>
Date: Thu, 5 Feb 2026 12:14:27 -0500
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: FileFallocate misbehaving on XFS
To: Thomas Munro <thomas.munro@gmail.com>,
 Jakub Wartak <jakub.wartak@enterprisedb.com>
Cc: Andres Freund <andres@anarazel.de>, Michael Harris <harmic@gmail.com>,
 Robert Haas <robertmhaas@gmail.com>, Alvaro Herrera
 <alvherre@alvh.no-ip.org>, Tomas Vondra <tomas@vondra.me>,
 PostgreSQL-development <pgsql-hackers@postgresql.org>
References: <CA+Tgmoa2fQihhhtvOD7BnTofmDa8OkDccFHB0i5NeyP-MZCs0A@mail.gmail.com>
 <202412161705.6u36fgydow3q@alvherre.pgsql>
 <coyrqea4ty53rknmxn4jjmok6f7vrvvia6s4stt6ys5l6fch4s@6tnxdtybqia3>
 <CA+TgmoZv7G57yRhHH4cdRPBnqkOrg6T-FZgExtwz263MpVRZHA@mail.gmail.com>
 <CADofcAXMX3OuPfbOU98v+nqGRxVWyUB+KrLs3LhPojgxTAntog@mail.gmail.com>
 <jq6lozj36wseov4tbg5ziduvy7bfj7r3oxmbyifi6yn24dmsyp@4cj5oivz22mj>
 <dk6af5xcmve6itleutbhvdx4ifxoe5om5dtft3pwa5wlteyazp@cp5auw3v4od5>
 <CAKZiRmzTPNWSwzsnf9VSXzC5HaH5shpxsk6axQD=KDZMoAc3Fg@mail.gmail.com>
 <CA+hUKGL9ND8Nv4Ssyz02zQ8+vXMcvAmEUPpjH6pwJC8NUtxcww@mail.gmail.com>
From: Andrew Dunstan <andrew@dunslane.net>
Content-Language: en-US
Autocrypt: addr=andrew@dunslane.net; keydata=
 xsBNBE7KWFkBCAClridxur2AIc7eW2AR7izbfp3EnNefie2HbLF0izW5Ik5UjX2HBXBx4syI
 gY6b0ugohXrr274+baoAlvSbq6cAoQuEVrk5IZFzt20b1Xkx65FwGSEj526yiKLocqkJceSq
 Xr9xcA5SGY+FZv441chh5SU92v4q6z+6LPpoHOh97ptAVXZYNTtU0LevyvD5lja0TzbvJm6C
 eFXitJfnm1pLEr0DGJCR/iUOl/N62Kh4855zZC7NHIjQHPOvV5Stz/l5ilDhvGVk+xkXFPys
 SjZoUr1rXhYLpiyi5sR0X9FHXT0KnGuz1F5ERO7ZTLSSQ6fJwPj6gOk9K+vvoKvoeql5ABEB
 AAHNJEFuZHJldyBEdW5zdGFuIDxhbmRyZXdAZHVuc2xhbmUubmV0PsLAlwQTAQgAQQIbAwIX
 gAIZAQULCQgHAwUVCgkICwUWAgMBAAIeBRYhBOQ+WEYd/Hy/RGkVpZn6f8tZ/DuBBQJoGNGd
 BQkdEO8nAAoJEJn6f8tZ/DuBq74H/jkTR4Zi3stbw+xC7v2u3QozssK7MYPL2AsVfh7OealS
 h182fiWXpfvmmAB7WUHbhk9GC2RAOnHI/2d2jgKaMLAHsGYOT0YopTVIwRY43fCw/mK67yxc
 wmDcX+zyKfLaivNbf5A7QPLNwda98bEAMSJ8Sn652Uc6cA8t3uKGsVzbRBQOoYzjgvBCfSrE
 9ql3PDNg0l4BfAqabd2f70ZUm9VAMEPrgv/v2xI7M2XiL4g5BVmqLCOwxLM8RMCotCuoweUr
 VO43DeBCIDwLxotMJKvGWDjBzQYlU1NPUAtNcz/gN9ITUe1VUGjyvGj4u1lxBOcQQUw7l1+T
 5moZ4iZxXzvOwE0ETspYWQEIANGc4zQULOxhbqO2dyD51YhqCNRmm9oKWaqf+wmW4tpDe/VV
 cxAnNizd4LWCHfzpb5cHAtGkOPePMfzWVf6nvdF7d3eglbtf59+zG7O7llV0xSSoFiieQBsr
 GvqDInXYX/4mRRXMtyhM353/tixC9RWLs1oofyYmCPPXXY7h9R7en3B8BoVrRFcdzlIY/NFN
 hFGW/9dkEiGjgna2Rk6e15kln4ZvFBWUg23p93w/pqXcxY6+k/8TEk+C4R+M6w7o2PLGOjdZ
 +kPiUcw5H85zf/yZJwQXzisXaNduwWB6Vads9YC9dj6kPR1c4VGRqAaYL++LAEOqrlvm2Tvq
 QqZRtnEAEQEAAcLAfAQYAQgAJgIbDBYhBOQ+WEYd/Hy/RGkVpZn6f8tZ/DuBBQJoGNI2BQkd
 EODdAAoJEJn6f8tZ/DuBfw0IAKTsfD40teP/pp+bsLLMSxPXUYrrprTj7WFB5v61p6dkpSr/
 qXmMlyahdxQFaPmfVgVirB1Vk/kHiWNnnGjfUV9nB2Zg9LI0Xb9/ts3LsUiRWXzG3tkMY6XL
 vsVOxW4XFRND9l2q+WW93aZ1DZl+fqWfYgMvsusFRhmGFOKTRfKPta2Pkv+AhA24N4+PrR5p
 bU4k2MO8PAGiK8eaYKGFG1bHKuAvoDoF7WXJ3FHxuWqLnKEt4dfOLm5pAe3zq1Lt6q8azT9i
 QWGpSAK5vQUWQHBHpiDjdPeqKZ6HiAXIIKfSmb+jrvXBqoP+D6/K7rUjG2aXiRtTIAXms9sm
 VRu7cmw=
In-Reply-To: <CA+hUKGL9ND8Nv4Ssyz02zQ8+vXMcvAmEUPpjH6pwJC8NUtxcww@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/a8eb3c29-d6ed-44e5-a563-e33f43c8444b%40dunslane.net>
Precedence: bulk


On 2026-02-05 Th 8:07 AM, Thomas Munro wrote:
> On Thu, Feb 5, 2026 at 8:16 PM Jakub Wartak
> <jakub.wartak@enterprisedb.com> wrote:
>> BTW: from our side we also have workaround patch (with GUC for this)
>> solving 2nd problem and that is pending for inclusion in separate
>> thread[2]
> Yeah, I'll push 0001 shortly to get it into the minor releases before
> the freeze, as it's still useful for the BTRFS people.  With this new
> info I can improve the reference to unexplained XFS failures in the
> commit message.  Thanks!
>

+many for getting this into the maintenance releases.


cheers


andrew


--
Andrew Dunstan
EDB: https://www.enterprisedb.com