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 1ncre7-0004xn-5i for pgsql-sql@arkaria.postgresql.org; Fri, 08 Apr 2022 16:39:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ncre5-0006EM-SU for pgsql-sql@arkaria.postgresql.org; Fri, 08 Apr 2022 16:39:37 +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 1ncre5-0006ED-IV for pgsql-sql@lists.postgresql.org; Fri, 08 Apr 2022 16:39:37 +0000 Received: from mail-ej1-x634.google.com ([2a00:1450:4864:20::634]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ncrdz-0003wf-4d for pgsql-sql@lists.postgresql.org; Fri, 08 Apr 2022 16:39:36 +0000 Received: by mail-ej1-x634.google.com with SMTP id qh7so18338183ejb.11 for ; Fri, 08 Apr 2022 09:39:30 -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=GjFyZ0MajQiMTjr5uj+RO7Qc9tgcbJ1wC0KexdJLx2I=; b=Dc5eVoU1cwx4HRS867efnfDEeLFEaLHGVOeUFYlxj26C0VOQ85mNphapJmM3kab2Cc Aj2VnjaD6a9r6nni9KN91f4ruHVR7eIiG9UY/fGit5GW7IfmiAxqAepIHCrAQz7Zl6nL qmMiAJUH6r2+HrENUMz/GoIg/2J8DAS/ADorLaiEgMueuLI1tPiKIsbdsN2DKzKXDuzF xjwg9pED8QBUkN+kD8BzW/aQydLjeIfJ5E3e/5RDgzbcFNcShB3QyAs74GMxUhvQ8SU9 ofhfnyuSHIbM312oFtFuSpjR351Jg1miVH81nXsezuz/QVIpIcdfMzttTG8EWkW40qV7 UeHw== 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=GjFyZ0MajQiMTjr5uj+RO7Qc9tgcbJ1wC0KexdJLx2I=; b=JmF2eo+WjuJr67fOGP9gqWaVV+mHrLDEZkgStFTE0G2WVyZjxm/hZX7FUz6xtK7D2G WZsj7zcJWMVkwwoI4EOcYYg6xLM6UorgLD+2LAvku2SQA9U+ybfCGQFXefKftQbMSSVc I6y5/SxKeNiPTbjBl+oR+yRTmkhU0/roidI5wfDAyaNByOMQXnZ6mJ1IyzA20fSyPzaY RIRVVZwcZLnFEBBSJa0G8HpYYnVBNNB9QTvdFIyWZTw9VqDRe/MxcU5NehJcLwKhQq5n rdGv6hO6yWWxOZ0zONP3E81AWFfaVy8gpvTc2+HiVlwAvhGFaofhZ0+s/qkkVg8wqBKH 5sQQ== X-Gm-Message-State: AOAM532b44qSl7gi1QNEW94U2RXGnZ9LucXeEiOiu+XaRUNmo5GjZOL/ SrKtoNGbG1iIHl9sX8TNtIqKc9jnsFlYILRcTuEa8iei X-Google-Smtp-Source: ABdhPJzlEqemZmjX5xzh+/jKlJZMm0BP9Ll+WJxyALITqR4dhCx4Ql5/7Tcps5r/J7MWSgMyNZB2rAmjbKYQPMYIJtM= X-Received: by 2002:a17:907:da6:b0:6e7:f84e:75b7 with SMTP id go38-20020a1709070da600b006e7f84e75b7mr19872930ejc.89.1649435968928; Fri, 08 Apr 2022 09:39:28 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Shaozhong SHI Date: Fri, 8 Apr 2022 17:39:18 +0100 Message-ID: Subject: Long running processes and commit writing to disk To: pgsql-sql Content-Type: multipart/alternative; boundary="00000000000001ff5605dc273dcd" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000001ff5605dc273dcd 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 --00000000000001ff5605dc273dcd Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


When l= ong running processes got disrupted, one may not see any expected result.
How to make sure that the result of each operation is sav= ed to disk in a loop?

Regards,

David
--00000000000001ff5605dc273dcd--