public inbox for [email protected]
help / color / mirror / Atom feedFrom: Bruce Momjian <[email protected]>
To: Jakub Wartak <[email protected]>
Cc: Thomas Munro <[email protected]>
Cc: Dimitrios Apostolou <[email protected]>
Cc: Magnus Hagander <[email protected]>
Cc: Tomas Vondra <[email protected]>
Cc: [email protected]
Cc: Andres Freund <[email protected]>
Cc: Melanie Plageman <[email protected]>
Cc: Heikki Linnakangas <[email protected]>
Cc: Kyotaro Horiguchi <[email protected]>
Cc: David Rowley <[email protected]>
Subject: Re: [PING] fallocate() causes btrfs to never compress postgresql files
Date: Thu, 30 Oct 2025 12:59:41 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAKZiRmzF6SRR+AxPZsXzs1kaHrxjLO2sbLT4Q61EMA5PGQB3Vg@mail.gmail.com>
References: <[email protected]>
<[email protected]>
<CA+hUKGKAS_eWJh_WqHLU3hmMDx7+mJaointh6LMnZrQnR-AeAA@mail.gmail.com>
<CABUevExxDKNsnwJ_hmt7Y4k_0zjy6wMoqsTBAEUZix4EkKQvnA@mail.gmail.com>
<CA+hUKGKGgDOdS=n77p1=VUf5=XV2=L7VSiZW99Re7kUTRGMgxQ@mail.gmail.com>
<CABUevEx=CQcphH33TRcMeUkt-TZ=m+i1JhLHCdoB_FYE5ift2w@mail.gmail.com>
<CA+hUKGL74G_CR50N+gr8N1E9emuFJMHAsEKr6oGmHZZDZjRJHg@mail.gmail.com>
<[email protected]>
<CA+hUKGJQ=V4S-5Z=D6cDfsOz_7vGAAusj2b3fO36GuezcADamQ@mail.gmail.com>
<CAKZiRmzF6SRR+AxPZsXzs1kaHrxjLO2sbLT4Q61EMA5PGQB3Vg@mail.gmail.com>
On Thu, Oct 30, 2025 at 11:14:07AM +0100, Jakub Wartak wrote:
> On Thu, Oct 30, 2025 at 4:56 AM Thomas Munro <[email protected]> wrote:
> >
> > On Wed, Oct 29, 2025 at 4:31 AM Dimitrios Apostolou <[email protected]> wrote:
> > > Sorry to ping again, but was there a conclusion reached regarding adding the new file_extend_method setting?
> >
> > No objections appeared, so the conclusion I am drawing is that we
> > should do this,
>
> Hi Thomas,
>
> +1 to this GUCs as this would also help the nearby thread with XFS
> mysteries which are not fully solved [1]. Since the latest message in
> that discussion, I'm aware of at least one additional report of XFS
> failing at fallocate() with free space too, but without any details
> from the OS support vendor why that happened, so this $patch could be
> also used to workaround that problem too.
Uh, the problem with backpatching new GUCs is that the GUC variable will
_not_ appear in any postgresql.conf file until a new initdb is run.
This can be quite confusing for people. The minor release notes have to
explain this.
--
Bruce Momjian <[email protected]> https://momjian.us
EDB https://enterprisedb.com
Do not let urgent matters crowd out time for investment in the future.
view thread (30+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: [PING] fallocate() causes btrfs to never compress postgresql files
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox