MIME-Version: 1.0
References: <HgsD3gOH-K3PK0n7PogBu3X1goIJ3_kN04shv7womj--6jQcAggYWdAOqYOmq1VVlVPf6TiHvxpZCvwmFawmHMEjciHsLErgsjaLruEspg0=@a7q.com>
 <CA+bJJbyM22f8x3WerZbNP+ME=m+WqDHQ425+_G0V3cZGrD9xYQ@mail.gmail.com>
In-Reply-To: <CA+bJJbyM22f8x3WerZbNP+ME=m+WqDHQ425+_G0V3cZGrD9xYQ@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sun, 14 Apr 2024 11:11:23 -0700
Message-ID: <CAKFQuwY5O6QK-bgbb+h34zhBdwL53ViuEH1OoHWmQXdZkHBL5A@mail.gmail.com>
Subject: Re: constant crashing
To: Francisco Olarte <folarte@peoplecall.com>
Cc: jack <jack4pg@a7q.com>, 
	"pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000fcbd080616127025"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwY5O6QK-bgbb%2Bh34zhBdwL53ViuEH1OoHWmQXdZkHBL5A%40mail.gmail.com>
Precedence: bulk

--000000000000fcbd080616127025
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sun, Apr 14, 2024 at 10:20=E2=80=AFAM Francisco Olarte <folarte@peopleca=
ll.com>
wrote:

>
> If postgres does not supress redundant updates ( lots of people can
> answer that )


It does not.  My other usual piece of advice along these lines, if doing
the transform outside the database is not desirable, is to at least ensure
you are doing them on a staging table that is defined as either being
temporary or unlogged.  WAL production probably isn't causing the crash but
can definitely be an issue and is pointless to incur during most
transformation processing.

David J.

--000000000000fcbd080616127025
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Sun, Apr 14, 2024 at 10:20=E2=80=AFAM Francisco Olarte =
&lt;<a href=3D"mailto:folarte@peoplecall.com">folarte@peoplecall.com</a>&gt=
; wrote:</span><br></div></div><div class=3D"gmail_quote"><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><br>
If postgres does not supress redundant updates ( lots of people can<br>
answer that )</blockquote><div><br></div><div class=3D"gmail_default" style=
=3D"font-family:arial,helvetica,sans-serif">It does not.=C2=A0 My other usu=
al piece of advice along these lines, if doing the transform outside the da=
tabase is not desirable, is to at least ensure you are doing them on a stag=
ing table that is defined as either being temporary or unlogged.=C2=A0 WAL =
production probably isn&#39;t causing the=C2=A0crash but can definitely be =
an issue and is pointless to incur during most transformation processing.</=
div><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-=
serif"><br></div><div class=3D"gmail_default" style=3D"font-family:arial,he=
lvetica,sans-serif">David J.</div><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><br></div></div></div>

--000000000000fcbd080616127025--