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.96) (envelope-from ) id 1wc1lI-00324h-2I for pgsql-admin@arkaria.postgresql.org; Tue, 23 Jun 2026 14:06:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wc1lG-00CH91-0Z for pgsql-admin@arkaria.postgresql.org; Tue, 23 Jun 2026 14:05:58 +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.96) (envelope-from ) id 1wc1lF-00CH8r-2d for pgsql-admin@lists.postgresql.org; Tue, 23 Jun 2026 14:05:57 +0000 Received: from mail-pg1-x52b.google.com ([2607:f8b0:4864:20::52b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wc1lE-00000001kpC-1Zfn for pgsql-admin@lists.postgresql.org; Tue, 23 Jun 2026 14:05:56 +0000 Received: by mail-pg1-x52b.google.com with SMTP id 41be03b00d2f7-c899550c840so3939707a12.3 for ; Tue, 23 Jun 2026 07:05:55 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1782223555; cv=none; d=google.com; s=arc-20240605; b=aQutK62aZ08KyFILWww7ttBbaskQe6NMv4HyDuq53yCrQ7rZ+7spgsP5GndVhtwtgy 1/UDg3ib3JdlitIEy0LtMA5pinSeiRplF8gRenELOcGHZSG0b+wByYzdpZO/cwLDmkEA m38tWPBybxw/v/Vo08EV9/FYUI3E+o8qbzBcg1d5OrGt21ChODUPqI1sMdyh6MG378rR x4j2qWkPpOvPE381U3vglbvlury4EdrSAiLY+sCNFY9tFFXAd/1gD4Y46u3Ixc9ODNbG kvTAKzatFpJ+Xd7TrbJKun86jylDFn27YFgTkDV5aOlfuaU0vF0IkmWcOpggGqCVQzlU uNjg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :dkim-signature; bh=DCWC9TmyrQe8EfnrKEpQjZ4TIi3PD+aGk1smVEFYElA=; fh=druxZHa2fk4e6MLibibygn9AWWgeaAPo4m8Gpo2MBXU=; b=GtAM+zRkQ30DNBcYof+WfEnBtvavTeUeyXjxskU33MiytMo0LZ7nf0OMgRFeyDYsn9 83RbGN1jc3VuSxYdhON2YZWcsYRDA0d8zGl9kAi80TPqhFUY/wVQ6IIBcUOQnFZmW8WJ 2kjsABPX2vlZc+H54GVmV4MZXoUxAV6BjNAnC1DT85NWZx6rM0LDLU8Rqde7yfzLK9o6 K50CTP+t8oId1rBRDOCjnbR+ABmB55YXG00CZe/Lx/6BfGgAbp5JqJiA7lgjgM0UbKmY qzv4hXgk7p47grDNsgmKwdAi442z9JYJBZdRIfaV2fpM4hXafsTA3mpR9oQmyzj+PH2z +VNw==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1782223555; x=1782828355; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=DCWC9TmyrQe8EfnrKEpQjZ4TIi3PD+aGk1smVEFYElA=; b=HJJAF60SZ+GmlU4D0htP/k/bdUdTt6we5B0H3a3QBT5PNGoRrEZVMrJVSUt1Cd7UIq YlAACSpialsI++zdEBMnHhoWi/u2vfKmW68Hdx6Mjj7JjZRjyFemfItBLIWFx9niQ371 asCzImyqQM9ri4flIkPUaiYsmCddwa8FSno1oAGwGNS1sh4/NPYUnNHJ631E4G6lNwEv H2erqGlsAZIl1qIOK1ssijz5zMv7seR59/wHU3nYllUWiOfXosnlsGNRxGKJed3Oagz2 wQt3BqWQHeHnjIC0OSV3JX4DnI6jiXEONQxbdSimjjudswMpb43P/ar9qsG1AfHjXyk0 ckRQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1782223555; x=1782828355; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=DCWC9TmyrQe8EfnrKEpQjZ4TIi3PD+aGk1smVEFYElA=; b=LaCn1yTGQaFg0B1H7iwCJiOxKul1bXHWxyGhB5AGpCQJ00ciUlsSRnVYYMjwhqFTEC 2qW31GGgbqk2c5aR4tbm59/1Iolp/9rS3leJBhhRHLpm0+74rwILGnTsINBSCIbHiO1J 0snpoA9IKdl4CINajTgewNt7cUkb5ybWRZuP1n0OzdAgzNdJUQvWRnaAwncTYq4OIwoa KdgRpz5uheGZ5wcjQ11leI6qeFwosPci6Tin6I7wjZu0SdnljoWJDpbk9jf1wchft1z6 Un4vhWNCzminRhNdeb3Z7sScpNw6yyG9LfT5y2+BqXvHz7YwYrV6zop3auB6Wlg19UbC F17Q== X-Gm-Message-State: AOJu0Yyk/4ACLyPW0idhdTZNY3i+P8qwxq7qiTpE1vrI1L6Vi9RKt/VH MNjDMubW+3IUkoESNX6oQx5XoOOBplZrA+w/B7XdDZxJkGat46Hjyt7LCk/+M2oWlNSxp53RZJf /QXqNlZ7OGkc/QheRBymAfX4WYs55u+oUug== X-Gm-Gg: AfdE7cnSNFduEBeO8z+pgJ56AVNaFgDo+JwSquzHvxjdUbL2nl0l6vzmiLxxMo0L49u x0S+3v3RKjRNqa2zdhiA98LsaTAHhrFpIqnDXiseeXZTxR3Bst6T+lwIcg1DVc9boStNgcaukqk DPFz7zpjWC1KSJdX1USnUa9WD3SMYuV0GOwmcQduJHPDvfiMbLKjfBgDNzrlWy1uwR+krduuIKO bhEOd/Fg+xY0OxG2JK/qElwF+1Rc08wnIrxHl4F6TucXKK+ElRc2UucxJVW2EWtJ2gEt9Mzlg== X-Received: by 2002:a17:902:cccd:b0:2c0:e5ee:f554 with SMTP id d9443c01a7336-2c7c758c438mr38213815ad.8.1782223554410; Tue, 23 Jun 2026 07:05:54 -0700 (PDT) MIME-Version: 1.0 References: <359C3FF2-C038-4237-A361-4DAEFA92C114@gmail.com> <1116567729.67464.1782219863407@connect.xfinity.com> <7442A254-D2FF-46AB-B4BA-47D6593087CB@elevated-dev.com> In-Reply-To: <7442A254-D2FF-46AB-B4BA-47D6593087CB@elevated-dev.com> From: Ron Johnson Date: Tue, 23 Jun 2026 10:05:42 -0400 X-Gm-Features: AVVi8CetrNd80LdeMBEbsLw8pU1YO8dQL-gqsllm3ZOkXVkrbpbPpTLSBOOpD7k Message-ID: Subject: Re: About asynchronous I/O To: Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000defdf00654ec41f3" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000defdf00654ec41f3 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, Jun 23, 2026 at 9:59=E2=80=AFAM Scott Ribe wrote: > On Jun 23, 2026, at 7:04=E2=80=AFAM, JOHN WIENCEK = wrote: > > > > Can your application assume the risk of lost transactions in the event > of a database crash? > > Pretty sure that's not a risk here... > Because WAL writing is sync io? --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000defdf00654ec41f3 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Tue, Jun 23, 2026 at 9:59=E2=80=AFAM Scott Ribe <scott_ribe@elevated-dev.com> wrote:
On Jun 23, 2026, at 7:04=E2=80=AFAM, JOH= N WIENCEK <jw= iencek3@comcast.net> wrote:
>
> Can your application assume the risk of lost transactions in the event= of a database crash?

Pretty sure that's not a risk here...

Because WAL writing is= sync io?

--
Death t= o <Redacted>, and butter sauce.
Don't boil me, I'm still = alive.
<Redacted> lobster!
=
--000000000000defdf00654ec41f3--