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 1wc1yw-0032G2-0P for pgsql-admin@arkaria.postgresql.org; Tue, 23 Jun 2026 14:20:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wc1yu-00CMkW-2m for pgsql-admin@arkaria.postgresql.org; Tue, 23 Jun 2026 14:20:04 +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 1wc1yu-00CMkN-16 for pgsql-admin@lists.postgresql.org; Tue, 23 Jun 2026 14:20:04 +0000 Received: from mout.gmx.net ([212.227.17.22]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wc1ys-00000001kw3-1BRj for pgsql-admin@lists.postgresql.org; Tue, 23 Jun 2026 14:20:03 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1782224397; x=1782829197; i=mbanck@gmx.net; bh=rRk8BF5Fsxav8u87yGxNrD99rA+FgZslCMJ9zSyeZWo=; h=X-UI-Sender-Class:Date:From:To:Cc:Subject:Message-ID:References: MIME-Version:Content-Type:Content-Transfer-Encoding:In-Reply-To: cc:content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=VZv4e00O23G9khlQo4Djh+gRqBRS/e05l12mEibDswQXRmlzXaFK2PHhWrDkJqDp Q0jeKcXyVOALyVVufNHN7s7uBLUf/dnTQyHiu1mN008oK8MPqyR4WnM81AeAL3+rl qU5/klF4aP29yvELVo6sSWiMlaBviHK/Ct1+svnj7a/oeWHmYEpW9jmC7jFVWIHrR aw1x7WwniKv2jNIjDuRbgvB3/Y2bwsfh8WKUmzJZUz222X1MbQrttQmo2TmZAnpN5 GEarchUdcGT8RmkzkITpUK6Z7h7s6pDtpAm3MKK3wplsv+oOTXjL0rOH0gy163zeG +GDbkPMCWmIbsq/Obw== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from client.hidden.invalid by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MHoNC-1wPOPL3MCE-00Emwg; Tue, 23 Jun 2026 16:19:57 +0200 Received: from mbanck by lightning.p46.dedyn.io with local (Exim 4.92) (envelope-from ) id 1wc1yn-0001aF-Bu; Tue, 23 Jun 2026 16:19:57 +0200 Date: Tue, 23 Jun 2026 16:19:57 +0200 From: Michael Banck To: Ron Johnson Cc: Pgsql-admin Subject: Re: About asynchronous I/O Message-ID: <20260623141957.GM32053@p46.dedyn.io;lightning.p46.dedyn.io> References: <359C3FF2-C038-4237-A361-4DAEFA92C114@gmail.com> <1116567729.67464.1782219863407@connect.xfinity.com> <7442A254-D2FF-46AB-B4BA-47D6593087CB@elevated-dev.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) X-Provags-ID: V03:K1:J2HSkMAopXmQKmnsxtwGaDkjwIimYzkamN2faSyE1ne0HM5mlVT BAsK+mDU80CV1qSL4l6C9lTi3E2Huaj0tadXv8YgGq6RlwD3S83xU27xDUpKuBESC9GGDHT FDwS2Z4hzcwoNIGMbBrFN5HIWxw5j7YZ4fuMtQu/F9jzwO4s1L8yPAkQP46Rg7C2hI8I2B1 w000oH0f4ojg9pya9j9+A== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:uMMBsD61bHo=;nTerVpT6M231MtSn35cpB5A72OS dNumEwYS+hNUVTiHfMcnYkUspAA2Zfrz3mfV9RuMJ8b2MDnyGeBwScebMuCPp0WWj/sDMqxRr I2sNRyBATJ649ZRdwb/OUi8hH/ezasN38B+1novuQwBTSZEme6DHXGBW9GYNsQnvEM6Yenp4+ 6hYNpR+4ZYWpv4Vyk+czXDBsWdoBEoubEjM6fXj0IpnOIzfoQuLSR7Ib5umUitQu8/Q3tWJve 5THzskyWbYn11Y/q0Kol9SBsgcd5+jH2+0krM4gqihG9xnGs4KqCi49S4Kh3Zvg8me8wQMkTs HZlkyWA7ax3xIDqTWRqzgEa5N1pSKuHB62FofHV9uwpV1c7X9jYP+4s4Ja9f4zpLXZJZo0T96 ufN9tYYqur1lWvjZobwLRfcv2SIEkmLaXJzo92HEcnE0KSIMWVdDhQHYbVMtPwBVX6JjL1dbs 4HrAS+zSnqEcxlGd0LU8rVy7VppWfkcT1HXG7q2jwbTVBJ8dLwLXglrEvt/Ik0mgruNKbUfpS mR/2t/dApddOYimkDbPxOfIzRKwoWQwAasuXXd7yIs7cTZhwBVWtZFbfC8vLzUamctk1+Hmh0 SCTrN6YwJmAK7IUzexHa/um3hiQIuykohKnnOxibsqIOYjWO2+HFVS+056oeQJvnnq8C2BDLq 1+mWDbxNNsis5lk8YTDRsVhStnwUAhjhvzIQozGop8ELcWdMZ9xw0c+EuMy6/81uorHPVGzly lsiMW/rnGkVF0Dnsi6X7huF/ksJxGsMeVBkP8h+t2nfAMPYqnqix/bjqTkxBHNmK5TP2Oe5lw FBv3yn4TWax5SpshCXgUzqDwJnyqU6fSXAE6Z2LdcoN3I4EevBmKNwllkiGtDGWVpvTkyCl3m 1528z1WayJPR/Renc88/tdJRmdbHuOoC52odzDFIDZyIWsRtLtJwLZ3m8lm3NLuCQsIGwaIaN MVQVXTdPoNv7KHE6+qno7I9uuJ96+hT5D3gI9z0CS9TG20uDNXz0k6B+nAFzOzDMrVWrctXYU ItHyl45PLoCHPMuF1QcuSyNbc04c7AB1hUcCaKjC8zCRZGQM85c+HGsCMs9qURXqqTpaut7A8 gNu9zvSsIlWLUfXbGx9tMAGBky4Eotw5TnLpT/dc6ztnGBdRM1igQNW1pqL8XiPMx1HwDVluH dO59AuaM0MXP+G2QjCy5Q5dUxtL/qQvi8w5+d2m///hVue4lbJxKV8OC4U8xTFCNFC/RPwDEX EVEjX5ZMdaMzt8o9PK81PqyjIZVInaUAE55KGGv1GqkH4HcFs8mOlSSqn96lnZMOXu2BuoOW0 7Tpq2+EJsd86w4+m8KaIWM+C8WCcZhmH6EcBgm76r73OK8Yl3lQNLLOYNk1HsmM+hdvPHC6V4 AlNGtMXCD51qqQc1GM6VRUVo1MWxyXq90QZLdV905ek9bVNOnhWdfelJAVfSxRpTjT6tgHG7I qP/8bLL8+sDDM9cuzpGmECJ7BNqPkpUArIICCLKFdKHHwjhEU3ZcXSqbg16MIhVjQpND/X/Cg MNMzTM5ZiCliMZ9Nwl6WkIHo6cTaHSl2GLlHHufp1FrksV/ONKNEI3fBe2L86cTKeNfGBXq7v PPdiCgTg6+I15xsLCVEWP+pTnYVKTfczHMj4tEoExsX2r4cy2C6s7tPsJxpLIqlxJwavL41nD V/CHeyUniTnnlK4os5UbO+pFJ020FDA2AjFL6Mu4idQzWBTKmZkfK/hQhwgoXIoPYs7KvHdYg JCfR3P4c1Jbrsomn/691QKLU+mDGT6wzeEZnmtMJeF0HvXPugz0JpIt8JLdjT7bGjDRwMl7D7 CL554TOWl9P91G9ZsJnhAezRWPwaLBoI7Og7eeYw+W7DaqOR9WkiVpiFQoGxRAMl3x8tWbYM9 HYxlzwTlkFjVTeKjrbKr8XfGNQ6ZCfKUpdnGsGaujs8TO9R/FsZEf/Zbqh+Si3PP5VQnoYdBp vhCsrd3fwllIK1/bBO8akB5xKiVAVQ+K5qCSL1uUBQ6/ami/jW+FRVBR0DzNu/hWStjtUxAP7 kIQoG1DRHkSOwI9qLzDbViY6DByr5tH459py151Y/7j2/kar0rkRuFBA3iE+sCzS/qNiBVSXM MS6yT82Q5LbkwYikqNxS5FdtnVYMLk/gfNLff2LZghM+W5T3qurii/xrvgP9B2Lj8n4p4ok+T QeVYP4c14lCXfVp/rW7rYRk9key6EVHWoDQ8KjMiD3C6tydvSVIg4YIkUM5AM885RwoCmoqbG NgTO1w/VWbYPNpSxUhUXDQ0e/Bww2qn7kWZY24SXQuMzvAAqXGBBQSDr6CVmKLfNjuc5bxdIu eSjhPksCF4fwJ6TSGVFJjIE+ip91bgXHW/44KUY11pOTr4zLaVgjzJ1qUBd3N7QW518EhLIbX 1eAoATfaH5Z0NnnnyMkk6efUpbc6ygyLold+OsElT7AA33OB9SW6mwSCCZPPS0y9E7pYjUXJ9 onKFC+VBpeKk8kuceBaFir/9d0EaTcVB4mcpAM5GR2TQFP9ZCB/kH+Ki9F483MCxDuhM6AskA mq5fqIW1xQ7E4a0LfPmRZ68Y4OsRl2A5s+BO/iwcEZSiu9Xfqp50jbyi2UgFewsQhThJhisAG eVH5FV3T8FENAfNlf3I2I2L147L6Hxh2QfvoOOFjMvZxHcqGDZQdGmlvDTkE0ibFm/wTuFvLw C81AXEv0uVjQaet6uNqAg3Li5httjCw5L0A8KyG50k9DIWj63QSkRNcLQrdeA4ocYVZk6hQdK Tj2wfzieqnoPDDah7FiwlScsK8xfYQt8aL+9pnS7WiiI//3CFD8YODh85dGz3AUBEo+haGgkT bqNodCPixpQbQxRz/J0su+fAeFZ+qCElkgDgP8uSHmOYzqog6hZvMfgZciOlydeA1mm2n7K0t X+YkNoeO5iWMVlKE3WjGNDPEk4fKwfuUCPwge9A8WKGE6yNZdRL++qNtyDmdSScv2vy95IsVN asSCd3du9nJi5TZZlg2gHl6TBMT8vVYqd2p3Z6acQHLyZef8O5LFsrEjdYGrQ87L4g4aaWsxm 7ozz6Oji+AKt0ns8iBNF+X92L8BPRjrVk4UvQUC7jJLOvidURQv2D6rD/d7dgT+CnTZVojRM8 3hw/ukgIv4DpoguBK9q1SU4NVkTXIiM309VaHbGa8uPRariQgG/Jtwa37nNXSki19DUZlaVv1 CPt2NzLkcc0+YkOrHuRmkqsUfKfb8j5MjRd8xaEq7tDpG/d7sIifAop2BXDbzXgoEPAX2T9nS wZDmeZca8B3Przm308oAv7YN0LvbUBr9WukIDz+cr7ZcUOhqk/v0j2unXIaCHiZAwItMsNXa9 4R20ghcIIXXGUh6W0xd3u8VOa+6iokgNtirTa15NfzR1g4ZSjor9jWdtfjm7c6dWu+qxeui2s rrWBNlxsyKnwIDFI6pV1dbyfjzjGW/gP9mTKOcQC/t5FJAWUAi2AssXHN1IVLDWrj83WzGP32 +ZJ7GLQsX2aMAa4zhd0TfsV8jktQxC8jRtdDnqYUTzIn8PkQ4KIwsMC/UolfJ/CNOPtxSlIlg 7CIfSVTy1VwoZhsoJ1hXkkIBtdca78EgSGXHCwDB+KTeWGDBsQ6hfeTFIOfEe5TSXB84p1yZg IcCYLrJVV1V1c4HQVZbZh0YUMFTHVnYSReG8LdWTbH4snwdDsYAGCHzJ0RimE6lmxtfbCGpPP w85qLhIWdabXou9iTZ270DnTtVdiLtP/lywM0Tr+m1ZOZ9rT7rweGiFfxcofMI3mLvixyHJx4 CcFNRmZ6rv1c5tCRMWaZhjzWupOgXlpLBKhnOolq7AXiPUD/X2knsYpoRpFVkz7Tdi20/4DR6 Z7e3bkiR2zsiewprZVOBr46YVSahbpVYs1nwjKI4YZVZHoKZclQzIsOzccEiZRH8xspLDuyx3 IQp2K6+ul5a+ZgEA29p7bRqDT2bGZ38P++zi2A3hjkUtpzhnxoeIxMyaOXS1XOLyh8Siod4Q7 5xc8UyG9h+DhZssUzuOaFfo6w3EA6hgC7Ct4XuduQcBdLXpVPiGxKmjY0bEhL2CaGKigx5hSy Sr5KEqYszkkeiqITEtvmlNd10ukorVnaFsBF4i2cDy7ZSSWo735G20/YckMv6mGF3BeZJuUU6 SYM2TRp3do6WcDCkZX7Puytlhj/kodgMldjlrOuAVtoyDLUi9/jiNTWQosrylMk+ro6menKEt 4YmWwcE+DvAsUF560TInHwH4qHPfjZRIW/NnM9l6FGSCWP+ZUazjomZzjj5u+wi/c84snIikX XUEWcVzwMRrAZ+OIOXp+h5z2+wfiOeTu727Q2o74Ehmm+64m8rXtwgjO1ATqck26Vtess02Hj +rIrTP6hzwdRm7FWeRwpwiML2e9TXCaQiz7YnmGuIonQT5IEXOpUOsl3nW/eDDHejU8zVlgXS mxllUwjTCH4Lfx0h7pm0TyZ7+nS4EdqMImwq0UD6eLS7AsFHiQCAqRTOBI/b/EPa+3RmRTYXK JjJSYJhXwPVdGRi5cxVzDUjJUkoHoWMWrIoXQVeI5fqcbptK9+BNNeTpn1YjNLAYZVuw6x5J4 u1FGnRm+CrG804r9T3CEjAtB+IJhKXVt3l5BLQ7GGqsJYg6p5EzAf1PLjJqbYnubkwNBfIrQ8 wsgL+4OWkcw17ofgzGLEAerv2vbOcv+3KPuFdFED66zmGalQMtKNs/cW9iUWceYeZaiiHD5bf 2Y/ipSJA+F6MADkBHM6ol9BptObjbwg4OQQQ/mmzAFX4gPJpkE4XKxxTdGYMfT+aNkVuPTk2B qhcH4mwZVwm/hqmr93aZlnWksTBOv4V3gswIAW4NOUjpmtlCMyQv1qcxlydX/xp2Z4sETUNoA 5FhiEV7zougS9q0UvFGKUlhlIFXl5WVeppe3owGahjdLyu0Fl1eGCvPrqCZdyoYEHhVBSECsi roKB4ABKuOm4pdfeS1sjW4svZgoahJUioJH2LEbNCtcFwg9PiFomwIDwwFLMyNIPMTyHb3YXl i+yXOxZa+fkDperHgDCDftZoVAuK2ks9pej/J9zMScEkPp+BeFyeWjF9BgoBkNImWpVbOQYON mDIiDZT0bjLquFtkjoea04VhCKr2La9CwJQIqkeZkS0hPcLkxX6xgNZgBUbInxCUaIf8cT2rO zEsYPfkmqBfEV2CbsaVtlV5nXETZgkpdoFM7Usx2lt2gPnxuKx6SIhy5kdAIUfjf4x1kj7nC2 0mvsPJW8B1YT05n/9V7/jWLXhlLlmC256HdG1DYRxWbjECdKZIaZKZm23gP5gWiG7fecbSgX8 P7d3QEqmiTD0uCcpR5xi1gyH99Rv7YdlrzkDtFbCkS1ik5mjtKoKD5NewtmQuSm1/L9mQ18f6 BSCkq71HZszlYBnF/x7DMQIAknthvRhTpmmFuQlGkeLMam8TxAU9dBbW53hABa/Jte9VIdtuk Y2CGh5rynn0nT1EcsDnWedgXt3irzSJDT8EK/yvbz7iNfGHH0iIpaoR7CHrOr6pPK2OIj/cRz E9pnoB+P8SM2pXA== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Jun 23, 2026 at 10:05:42AM -0400, Ron Johnson wrote: > 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 eve= nt > > of a database crash? > > > > Pretty sure that's not a risk here... >=20 > Because WAL writing is sync io? That, and because AIO is read-only in Postgres so far (including in the upcoming PG19). Michael