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 1qc8vH-00E21I-1U for pgsql-hackers@arkaria.postgresql.org; Fri, 01 Sep 2023 18:31:11 +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 1qc8vF-00GZrJ-DW for pgsql-hackers@arkaria.postgresql.org; Fri, 01 Sep 2023 18:31:09 +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 1qc8vF-00GZqw-38 for pgsql-hackers@lists.postgresql.org; Fri, 01 Sep 2023 18:31:08 +0000 Received: from mail-oa1-x31.google.com ([2001:4860:4864:20::31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qc8vB-002OWF-B9 for pgsql-hackers@postgresql.org; Fri, 01 Sep 2023 18:31:08 +0000 Received: by mail-oa1-x31.google.com with SMTP id 586e51a60fabf-1c4c7a83bcdso1501722fac.0 for ; Fri, 01 Sep 2023 11:31:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1693593063; x=1694197863; 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=V7B8Kv5QD5hpJD9PiXhnVmsA0ZU2XgtfHpGNqppHs/8=; b=hMzFTTcUMvLYSqb6Co6OtoDC3zwJMuMf1icTMMkuRLaWT86w+RyAQZzgWz8VWLXM7F 5mjzUaWn3t7OiDRlhqsqhyGEn4/9AgXecGN1CJlOiM1pa5h0kupuYfXG79nz5liafQ6v yEN/r97wwQwAv/B0nr1bnioK3F01Q5v2XWnFQhkd/VUbcaIJd0GrH4tXlUTwo1CzdzG+ JLoJCHv+1qWgz/8Aj6YkbUhDOXJ7D6rCShYTtqONZHqmqsBPl+LzM8X2FrSwfAG5j3BY 5Ddaxex79Ur7CpovGX+XpiBm3zgubNqsQ4qzRWDvnekdcevO0ZWqYkOook3Wag7PdigL S1FA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1693593063; x=1694197863; 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=V7B8Kv5QD5hpJD9PiXhnVmsA0ZU2XgtfHpGNqppHs/8=; b=Alc5bjMms0vjRd0GBgFpnf6ZqAsIYF3Lwn/X7EMp37YdawVjzimR4Z46DAJDfiXmGv MuPzY8E2ZW2malCm/z4xU6Tnr3XfsIJ+kOHditgqO18/AnwxRZdd/AgHPTEO4STwipk1 7hxaSHFg94CwYH1/WoV82NXWBys2QYujzdPgZQO/Xb0BSL67M/3zaaKEzm9bDuISMPfv Fk/km/fBSmP9AyPvwASPZ2eqzL6/K1i4nSlbdXWXuxKk75sQVcdbwVxHfn+tkxK0x3BU 1/WII1ZlCuYB6LwzEDIwKn3mg5OzK1WCUmSnLRl7ng2b94XNCYYc+S6aSV3udtUzVOLe /VfQ== X-Gm-Message-State: AOJu0YwjhNhRBMn8eLYrnQddYzDae4LU1u1z6dvh/xmPKvzbcGR1n/ir zzzf6Ma1oABw7X4Qrpv+JMo= X-Google-Smtp-Source: AGHT+IGJCt+7/Iu9MEWaPkrxzJkfMGOjQa212i07pQcEKspuOFrjvd+QZKmuGDAhdyJqK7Ej0bz44w== X-Received: by 2002:a05:6870:2308:b0:1bb:3f64:bb89 with SMTP id w8-20020a056870230800b001bb3f64bb89mr3775942oao.24.1693593063239; Fri, 01 Sep 2023 11:31:03 -0700 (PDT) Received: from nathanxps13 ([2600:1700:48f8:340f:6862:ed15:920:90f8]) by smtp.gmail.com with ESMTPSA id v1-20020a056870e28100b001c0f4484d20sm2449669oad.25.2023.09.01.11.31.02 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 01 Sep 2023 11:31:02 -0700 (PDT) Date: Fri, 1 Sep 2023 11:31:00 -0700 From: Nathan Bossart To: Justin Pryzby Cc: Michael Paquier , Thomas Munro , David Steele , Fujii Masao , Bruce Momjian , Paul Guo , Tom Lane , Michael Brown , pgsql-hackers@postgresql.org Subject: Re: should frontend tools use syncfs() ? Message-ID: <20230901183100.GD3180181@nathanxps13> References: <20210930004340.GM831@telsasoft.com> <20220413115412.GM26620@telsasoft.com> <20230729214010.GA189456@nathanxps13> <20230901180851.GC3180181@nathanxps13> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Sep 01, 2023 at 01:19:13PM -0500, Justin Pryzby wrote: > What about (per git grep no-sync doc) pg_receivewal? I don't think it's applicable there, either. IIUC that option specifies whether to sync the data as it is streamed over. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com