From: "Mike Sofen" <msofen@runbox.com>
To: "'pgsql-sql'" <pgsql-sql@lists.postgresql.org>
References: 
 <CA+i5JwbqHrQNPjWgUzcQWTs3XueGuxp82RZ4FAZ-P8dhRk22CA@mail.gmail.com>
 <CA+i5JwYicGdvXLSNx_VdREEuCCWch2gWevK6avSQfPM2EgDwEQ@mail.gmail.com>
In-Reply-To: 
 <CA+i5JwYicGdvXLSNx_VdREEuCCWch2gWevK6avSQfPM2EgDwEQ@mail.gmail.com>
Subject: RE: Long running processes and commit writing to disk
Date: Fri, 8 Apr 2022 09:52:23 -0700
Message-ID: <02f801d84b69$06336370$129a2a50$@runbox.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_02F9_01D84B2E.59D59CE0"
Thread-Index: AQGl8ncKu1TYrZZ5pEoz71gksRj6IQIITsO4rTqpi3A=
Content-Language: en-us
Archived-At: 
 <https://www.postgresql.org/message-id/02f801d84b69%2406336370%24129a2a50%24%40runbox.com>
Precedence: bulk

This is a multipart message in MIME format.

------=_NextPart_000_02F9_01D84B2E.59D59CE0
Content-Type: text/plain;
	charset="utf-8"
Content-Transfer-Encoding: quoted-printable

From: Shaozhong SHI <shishaozhong@gmail.com>   Sent: Friday, April 08, =
2022 9:39 AM


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

=20

=20

Simple:  don=E2=80=99t use a database =E2=80=93 you=E2=80=99re asking to =
violate ACID. =20

=20

A database=E2=80=99s power comes from set-based operations.  =
You=E2=80=99re asking to do single row operations.  Use a =
spreadsheet...or a plain text file and treat it like a log.

=20

Mike


------=_NextPart_000_02F9_01D84B2E.59D59CE0
Content-Type: text/html;
	charset="utf-8"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40"><head><meta =
http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8"><meta =
name=3DGenerator content=3D"Microsoft Word 15 (filtered =
medium)"><style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:Consolas;
	panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;}
span.EmailStyle24
	{mso-style-type:personal-reply;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri",sans-serif;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]--></head><body lang=3DEN-US =
link=3D"#0563C1" vlink=3D"#954F72" style=3D'word-wrap:break-word'><div =
class=3DWordSection1><div><div><div><p class=3DMsoNormal =
style=3D'margin-left:.5in'><b>From:</b> Shaozhong SHI =
&lt;shishaozhong@gmail.com&gt; =C2=A0=C2=A0<b>Sent:</b> Friday, April =
08, 2022 9:39 AM<br><br><o:p></o:p></p><p class=3DMsoNormal =
style=3D'margin-left:.5in'>When long running processes got disrupted, =
one may not see any expected result.<o:p></o:p></p><div><p =
class=3DMsoNormal style=3D'margin-left:.5in'>How to make sure that the =
result of each operation is saved to disk in a =
loop?<o:p></o:p></p></div><div><p class=3DMsoNormal =
style=3D'margin-left:.5in'>Regards,<o:p></o:p></p></div><div><p =
class=3DMsoNormal style=3D'margin-left:.5in'>David<o:p></o:p></p><p =
class=3DMsoNormal><o:p>&nbsp;</o:p></p><p =
class=3DMsoNormal><o:p>&nbsp;</o:p></p><p =
class=3DMsoNormal>Simple:=C2=A0 don=E2=80=99t use a database =E2=80=93 =
you=E2=80=99re asking to violate ACID.=C2=A0 <o:p></o:p></p><p =
class=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=3DMsoNormal>A =
database=E2=80=99s power comes from set-based operations.=C2=A0 =
You=E2=80=99re asking to do single row operations.=C2=A0 Use a =
spreadsheet...or a plain text file and treat it like a =
log.<o:p></o:p></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><p =
class=3DMsoNormal>Mike<o:p></o:p></p></div></div></div></div></div></body=
></html>
------=_NextPart_000_02F9_01D84B2E.59D59CE0--