Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ncreb-00050V-QC for pgsql-general@arkaria.postgresql.org; Fri, 08 Apr 2022 16:40:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ncrea-00089u-Lk for pgsql-general@arkaria.postgresql.org; Fri, 08 Apr 2022 16:40:08 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ncrea-00089l-7m for pgsql-general@lists.postgresql.org; Fri, 08 Apr 2022 16:40:08 +0000 Received: from mail-ej1-x631.google.com ([2a00:1450:4864:20::631]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ncreU-0003ww-AI for pgsql-general@lists.postgresql.org; Fri, 08 Apr 2022 16:40:07 +0000 Received: by mail-ej1-x631.google.com with SMTP id bh17so18396431ejb.8 for ; Fri, 08 Apr 2022 09:40:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=AHzGf64idssa+538uf7D2u+euiJHMrxLHNFl2NBU8RU=; b=GuOEBYm9EcmzHf6B2Xdfo37vYiLw1R3GQlCwPWR5X/wLN2cNmEK5QsID73vPgXyVGs wUMONnoIXyz5L4ybAYhbevZmMKowKOmX+0pjUgnq2tRhZTzAGU97L3Cvx8Ye0y4uCxN/ 5rSQuvLqccuxHDaxx7BbWNhLHyv/OOXPclrr3aFpMKPaALdZGcFNVRtKi98Pz7Q0ekYc VTfK0I3H4Mq1EdrAQgp+X1LnXapWy5T4HzbasQ20mJ7n1MQS2FxTMX/TkVqtQv86zTMP fSFgGzU+WCD7sn+MuUO1sTq6hwAYnddm+2g/HgCHP5vR1jBPUQcfF/6A1u3LhmdKdAoD PkJQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=AHzGf64idssa+538uf7D2u+euiJHMrxLHNFl2NBU8RU=; b=tJPp5O9ufY0idiTA7WhRzhCc/1lRp4tCelV5UCCrk7jp1PnD53EihBElxm0tp3bJdA VuHn4x1Wtyv7O8nAZTUTTWtXZZCUvG/WcUyi6H3Mj3jVKuvt+A2Gj04GyyFstgTtvdnk Aama6B2mp7DNNpw2m2V97MGQIr1HPCv5te0Oh3+vWO6P4XD8pAh1ZRd0kLE54FizbhT+ Nkt06LdHrGP05LxR3/afAyFfCy6IEgNorjXgAlrw1DMoCdpYmTM32PWtZcD77DkRZ1XQ m29AKmiTLrt7IOV35lYw8/qROX9OJuSpTz/Wbx7gB9yi/rfv21xswC6QuQt4sLJBLf9N Le5Q== X-Gm-Message-State: AOAM530cWa2GNErYLMQDTbLOCzofriSf8KNpc3VOuNYIjd3AwNA0wPsR pd8cbfW3eO3gJL61ZbnxClbQuBP7T8Lj5hENrevqCINE X-Google-Smtp-Source: ABdhPJymS4f+n3xzagdOUKcp3wDhJCqJE5Bh3Y8MkCneBeQidUdyynugO4g0vh7it7PXJVLl1LGP+I2neHK+B5MZeGw= X-Received: by 2002:a17:907:2d8d:b0:6df:a06c:7c55 with SMTP id gt13-20020a1709072d8d00b006dfa06c7c55mr19308485ejc.325.1649436001084; Fri, 08 Apr 2022 09:40:01 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Shaozhong SHI Date: Fri, 8 Apr 2022 17:39:50 +0100 Message-ID: Subject: Long running processes and commit writing to disk To: pgsql-general Content-Type: multipart/alternative; boundary="000000000000ecaa0305dc273eb2" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ecaa0305dc273eb2 Content-Type: text/plain; charset="UTF-8" When long running processes got disrupted, one may not see any expected result. How to make sure that the result of each operation is saved to disk in a loop? Regards, David --000000000000ecaa0305dc273eb2 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

When long running processes got disrupted= , one may not see any expected result.

How to make sure = that the result of each operation is saved to disk in a loop?
Regards,

David
--000000000000ecaa0305dc273eb2--