On Sun, Apr 14, 2024 at 10:20 AM Francisco Olarte <folarte@xxxxxxxxxxxxxx> 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.