Content-Type: multipart/alternative;
 boundary="------------tEhEQI5S8bqGxNb357gq0dVO"
Message-ID: <da996cfc-042a-2a52-06aa-3224e857cb64@gmail.com>
Date: Fri, 8 Apr 2022 13:01:23 -0500
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.5.0
Subject: Re: Long running processes and commit writing to disk
Content-Language: en-US
To: pgsql-general@lists.postgresql.org
References: 
 <CA+i5JwbqHrQNPjWgUzcQWTs3XueGuxp82RZ4FAZ-P8dhRk22CA@mail.gmail.com>
 <CA+i5JwYicGdvXLSNx_VdREEuCCWch2gWevK6avSQfPM2EgDwEQ@mail.gmail.com>
 <CA+i5JwYJ173ehMH7bfRvDyhAd0JwhFG5dV4U=4jgfe6uuoeizw@mail.gmail.com>
From: Ron <ronljohnsonjr@gmail.com>
In-Reply-To: 
 <CA+i5JwYJ173ehMH7bfRvDyhAd0JwhFG5dV4U=4jgfe6uuoeizw@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/da996cfc-042a-2a52-06aa-3224e857cb64%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------tEhEQI5S8bqGxNb357gq0dVO
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

On 4/8/22 11:39, Shaozhong SHI wrote:
>
> 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?

That would of course depend on how often you begin and commit transactions.


-- 
Angular momentum makes the world go 'round.
--------------tEhEQI5S8bqGxNb357gq0dVO
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    On 4/8/22 11:39, Shaozhong SHI wrote:<br>
    <blockquote type="cite"
cite="mid:CA+i5JwYJ173ehMH7bfRvDyhAd0JwhFG5dV4U=4jgfe6uuoeizw@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div class="gmail_quote">
          <div dir="ltr">
            <div class="gmail_quote"><br>
              <div dir="ltr">When long running processes got disrupted,
                one may not see any expected result.
                <div><br>
                </div>
                <div>How to make sure that the result of each operation
                  is saved to disk in a loop?</div>
              </div>
            </div>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
    That would of course depend on how often you begin and commit
    transactions.<br>
    <br>
    <br>
    <div class="moz-signature">-- <br>
      Angular momentum makes the world go 'round.</div>
  </body>
</html>

--------------tEhEQI5S8bqGxNb357gq0dVO--