Re: constant crashing - Mailing list pgsql-general

From David G. Johnston
Subject Re: constant crashing
Date
Msg-id CAKFQuwY5O6QK-bgbb+h34zhBdwL53ViuEH1OoHWmQXdZkHBL5A@mail.gmail.com
Whole thread Raw
In response to Re: constant crashing  (Francisco Olarte <folarte@peoplecall.com>)
List pgsql-general
On Sun, Apr 14, 2024 at 10:20 AM Francisco Olarte <folarte@peoplecall.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.

pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: constant crashing
Next
From: Vijaykumar Jain
Date:
Subject: Re: constant crashing