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 ) id 1qpxB2-007fvF-IR for pgsql-hackers@arkaria.postgresql.org; Mon, 09 Oct 2023 20:48:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qpxB0-001H2R-DC for pgsql-hackers@arkaria.postgresql.org; Mon, 09 Oct 2023 20:48:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qpxB0-001H2F-3Y for pgsql-hackers@lists.postgresql.org; Mon, 09 Oct 2023 20:48:31 +0000 Received: from mail-io1-xd34.google.com ([2607:f8b0:4864:20::d34]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qpxAy-001Asw-7F for pgsql-hackers@postgresql.org; Mon, 09 Oct 2023 20:48:30 +0000 Received: by mail-io1-xd34.google.com with SMTP id ca18e2360f4ac-79fe612beabso213489439f.3 for ; Mon, 09 Oct 2023 13:48:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1696884506; x=1697489306; darn=postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=mAPHCiihj0Y/BMKScEEynPTOJgWROPopFcMldlWFCYY=; b=hiOPjJYtM6YsfKKq61SlLRnuLmIk/KEQFEx7baPLO+99dDJHLrMcMXymzU56NBqysx /Eg2b6x0XT6GP9HcLt+bGt+u4fVi8w2n8/cbz9tCQAhNLnlZ/2cQ/1VghbHVHfCtl3tV FDbK8SVaUXGZjJ9V1OexZzrRvA7lv2MnFJK5xkWFT6Q/BxNMlioLoZxSYGD5CO/mTE+y 276SyHEbIL0bSNJKzzRHri0oX2RCRNjsMBrJLIxHrepZMyWnmf1I0hol33F6Kf6S+1eV rpCTh9TnBROkPUrIxWRqzZvDtLe0AIw7NmjnD2o/i97xJJnXA7MiHTqyyxxVsIJcbz0f EwCQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1696884506; x=1697489306; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=mAPHCiihj0Y/BMKScEEynPTOJgWROPopFcMldlWFCYY=; b=kLxHOLYOiOZ22DsNh4h4qJeGM+DcvesukFtvpkF0SOzSIkWghHpvW+Sr+O+xKT1mAa 4VBlTftEB3+jUBnmT8WSblR7ohBSyKla2ZkN/ppStDp33MlF6uY09OlUANSfGXl4B5UN 37gk5zWkOQZVr+rEZ9y5QfZv88ME8gcQPBdflPG4JJ2rKsyYnZmh4/9ivITCBl4tlgXA v2tWlCyjTdtTEouwk4Aauz9EzcPv/JRilWLB111/zkRM6lJZspUSaV5DHkuUhMopqflZ XoayO2giQHpXQj7T99a6kriz0wc1HFv1uiMxqJVbs/RNlfvHKgWyATIJsp9OiNb0lkG6 jlzQ== X-Gm-Message-State: AOJu0YxN2II+jCcDwm7rVM09eIkc9BrfGnG1g+1KyPDx5OPW6WWvqSW7 0fQN1q2zYkb+bge5WNxqgK0= X-Google-Smtp-Source: AGHT+IFE7tep4qfMXZuPKTfHctkrv8rG55V+YrkpZ36VViEWg0K8UM3Jn6d13GSg/LXx3qzNbEXxBg== X-Received: by 2002:a6b:6f06:0:b0:780:bf50:32ce with SMTP id k6-20020a6b6f06000000b00780bf5032cemr18930956ioc.19.1696884506048; Mon, 09 Oct 2023 13:48:26 -0700 (PDT) Received: from nathanxps13 (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id l4-20020a02cce4000000b0042b4b1246cbsm2349970jaq.148.2023.10.09.13.48.24 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 09 Oct 2023 13:48:25 -0700 (PDT) Date: Mon, 9 Oct 2023 15:48:23 -0500 From: Nathan Bossart To: Peter Eisentraut Cc: Michael Paquier , Justin Pryzby , Thomas Munro , David Steele , Fujii Masao , Bruce Momjian , Tom Lane , Michael Brown , pgsql-hackers@postgresql.org Subject: Re: should frontend tools use syncfs() ? Message-ID: <20231009204823.GA659480@nathanxps13> References: <20230729214010.GA189456@nathanxps13> <20230731175138.GA432880@nathanxps13> <20230731183946.GB537853@nathanxps13> <20230801163707.GA862840@nathanxps13> <20230808200606.GA1384393@nathanxps13> <20230816151705.GB2651383@nathanxps13> <42804669-7063-1320-ed37-3226d5f1067d@eisentraut.org> <20231004152907.GD3178@nathanxps13> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20231004152907.GD3178@nathanxps13> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Oct 04, 2023 at 10:29:07AM -0500, Nathan Bossart wrote: > On Wed, Sep 27, 2023 at 01:56:08PM +0100, Peter Eisentraut wrote: >> We have a collection of platform-specific notes in chapter 19, including >> file-system-related notes in section 19.2. Maybe it could be put there? > > I will give this a try. I started on this, but I couldn't shake the feeling that this wasn't the right place for these notes. This chapter is about setting up a server, and the syncfs() notes do apply to the recovery_init_sync_method configuration parameter, but it also applies to a number of server/client applications. I've been looking around, and I haven't found a great place to move this section to. IMO some of the other appendices have similar amounts of information (e.g., Date/Time Support, The Source Code Repository, Color Support), so maybe a dedicated appendix isn't too extreme. Another option could be to introduce a new section for platform-specific notes, but that would just make this section even larger for now. Thoughts? -- Nathan Bossart Amazon Web Services: https://aws.amazon.com