Re: constant crashing - Mailing list pgsql-general

From David G. Johnston
Subject Re: constant crashing
Date
Msg-id CAKFQuwbjojQtSv=SeFnvx6XXrJQ2k7rsNR=rCOAfM0f+E=BmHg@mail.gmail.com
Whole thread Raw
In response to Re: constant crashing  (jack <jack4pg@a7q.com>)
List pgsql-general
On Sun, Apr 14, 2024 at 6:58 PM jack <jack4pg@a7q.com> wrote:
But the current i9 machine is a machine from only 4 years ago which should have no issues.


That is a non sequitur.  Besides, if the current code is a representative example you've probably given it the effective usage of 8 years.

Whether related or not to this error you really should be doing all those updates on a temporary or unlogged staging table and getting WAL generation out of the equation.

David J.

pgsql-general by date:

Previous
From: David Rowley
Date:
Subject: Re: constant crashing
Next
From: Nicolas Seinlet
Date:
Subject: [MASSMAIL]Failing streaming replication on PostgreSQL 14