Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1trobM-009oCQ-4H
	for pgsql-hackers@arkaria.postgresql.org; Tue, 11 Mar 2025 01:40:12 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1trobK-004PG2-OU
	for pgsql-hackers@arkaria.postgresql.org; Tue, 11 Mar 2025 01:40:10 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <harmic@gmail.com>)
	id 1trobK-004PFi-Ei
	for pgsql-hackers@lists.postgresql.org; Tue, 11 Mar 2025 01:40:10 +0000
Received: from mail-wm1-x336.google.com ([2a00:1450:4864:20::336])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <harmic@gmail.com>)
	id 1trobI-0028Hv-26
	for pgsql-hackers@postgresql.org;
	Tue, 11 Mar 2025 01:40:09 +0000
Received: by mail-wm1-x336.google.com with SMTP id
 5b1f17b1804b1-43cfba466b2so16179415e9.3
        for <pgsql-hackers@postgresql.org>;
 Mon, 10 Mar 2025 18:40:08 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1741657207; x=1742262007;
 darn=postgresql.org;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=9pvY8NTKKuH9HqJervGmtkrjQXP/SbznUlGLiD+FAoQ=;
        b=YKEcaot7KdF1TZvRFibhm9TDFIeiT+qIGgyQto31jg4BSBd4N//iK9zd41cbjbwXMD
         sN0a4t8+YZQmFbRTlVrBj4vAlY6n9ljA6TM/yucZZ2d8qMOCggDIjOF8PMOwjiW3482e
         qEIa3QwAoCOdZhYvgXVVR5ixjbq7wD7DcwMzEC1/xck7G7DPoHuEj78x6Bpq3uKXfKHa
         AcmujsGmSnjvhhW5YVGxqqNzTQsI0r4DulmwmfcIhdKMZmt90dncAL9ilzB1BwffAFGi
         UhNiGPfXyXi9psfVmBbH4B3aG1KZ29pOGAiiHy6rU9GG/GmENcEtbZ1SAProYXAGT6Yk
         cV7g==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1741657207; x=1742262007;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id
         :reply-to;
        bh=9pvY8NTKKuH9HqJervGmtkrjQXP/SbznUlGLiD+FAoQ=;
        b=PNJBujo2ZWBRPKfUyxaLu8JjAfNBF5FC9Y3WQHFyoyWuI9ywTqaSDjW2jTwKDVSbSD
         dMCMl4sv03Yl7JYp0icnHRPOEpkmLqcIB6xY0Cf3GOVulksowkvn17Ans1lznszd5WEQ
         DCdFj8U2shAqgmWaiowk4u+GmFj4DyJSR5mz0OAa0IKgg+jQXCBGgML5f0DlcS/PWaMm
         VnqBQkHOExG9EbSy3ETnx9qWupmSkvI+O6eNbgZ/yB6B/kmlRl2Z2i1mVx2REldZI4x/
         0qI5w/VVNCvW4+XJRJYFnBuqlDibR9SEuZ4aFYWY0qC0kAvueQHxo1SL24YNvC3xnx2A
         y4Fw==
X-Forwarded-Encrypted: i=1;
 AJvYcCXSld8vf2i6+PLL+4xlp7966ZuY9Hnrp3lnyoGB4JDU9U6l7l3rMk8EMfNW97gC41w2FoLqVHo6s0M3rJhp@postgresql.org
X-Gm-Message-State: AOJu0YyyAPJzdM9vnHcK2TNncuFXpc7RE8qEQlV1aGZ0wkgriS1RIF+X
	YOBPGW4VvVMud8jHcYZuul0qH+SHHFdxdEgxkiAx+Jy40lNN3DdMHiuGZq0hnxWgZqPq57q5f9P
	ArlFTAkOxmLPOWsfeZ41f2euQZJA=
X-Gm-Gg: ASbGncuTDX0N00a7LeYgeBAw6TjKaUEdGTuu3zY6sObzrwfEhUB6LDC2pF0go629i6e
	zdNZviDRB6W5HneF993K6uyQOgFus2wsZsc0J3ferQ01eI0VQHENsSdvyCxNkQy2CYbCTizo9AK
	iqy/RSrp1GaE4jcypY9ZloYsnHYrXw
X-Google-Smtp-Source: 
 AGHT+IH8WB2+pb9uIo/oyaAaD2P3Bxb2uIMF2kAERPaAHgsfqSHWfD/nWIJ/f4yZg/D6wxMhGxcfBYTLvbfDppykYDQ=
X-Received: by 2002:a5d:588a:0:b0:391:298c:d673 with SMTP id
 ffacd0b85a97d-39132da2286mr14872767f8f.40.1741657207345; Mon, 10 Mar 2025
 18:40:07 -0700 (PDT)
MIME-Version: 1.0
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>
 <CADofcAWeD4uFPjk8Tee+wxFbaoa30hEENs+JQXg24+uaoKVD1A@mail.gmail.com>
 <CADofcAVENSB2KEjWh2FW=RJOuWZmwQPbRJistj46Z-W6_4chxA@mail.gmail.com>
 <CAHZmTm1MgBV4-SD_zG5LLG-pWHxGYQ=V7uYrNUhcdPd0gtYe-A@mail.gmail.com>
 <CAKZiRmyoJpi3qvouvMKJ6tteYvXzpk3a53pT8K9oRM+_R3NS-g@mail.gmail.com>
In-Reply-To: 
 <CAKZiRmyoJpi3qvouvMKJ6tteYvXzpk3a53pT8K9oRM+_R3NS-g@mail.gmail.com>
From: Michael Harris <harmic@gmail.com>
Date: Tue, 11 Mar 2025 12:39:55 +1100
X-Gm-Features: AQ5f1JrTP7xoipGwr8bG276b1-3hh0fx2Z3mJSQI_eqROWspSXD_asBJ4bYzkgs
Message-ID: 
 <CADofcAUpeGaBTcNZFz17xvoQzGoa4CDovVHCFMtd-DWeD_58CQ@mail.gmail.com>
Subject: Re: FileFallocate misbehaving on XFS
To: Jakub Wartak <jakub.wartak@enterprisedb.com>
Cc: Jean-Christophe Arnu <jcarnu@gmail.com>,
 Andres Freund <andres@anarazel.de>,
	Robert Haas <robertmhaas@gmail.com>,
 Alvaro Herrera <alvherre@alvh.no-ip.org>,
	Tomas Vondra <tomas@vondra.me>,
 PostgreSQL-development <pgsql-hackers@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/CADofcAUpeGaBTcNZFz17xvoQzGoa4CDovVHCFMtd-DWeD_58CQ%40mail.gmail.com>
Precedence: bulk

On Tue, 4 Mar 2025 at 23:05, Jakub Wartak <jakub.wartak@enterprisedb.com> wrote:
> out of curiosity, did Redhat provide any further (deeper) information
> on why too big preallocation (or what heuristics) on XFS can cause
> such issues?

Hi Jakub

So far I don't have any feedback from RH. Unfortunately there is a
long corporate chain of people between me and whomever in RH is
dealing with the ticket! I will update this list if/when I get an
update.

Cheers
Mike