Re: How to perform a long running dry run transaction without blocking

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: Robert Leach <rleach(at)princeton(dot)edu>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to perform a long running dry run transaction without blocking
Date: 2025-02-06 18:53:38
Message-ID: 798DA50B-7932-4CF5-A16F-9131881EDDF6@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


>
Have you considered a validation app? Have it read the inputs and look in db for conflicts, rather than attempt the insert. Zero transactions necessary

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2025-02-06 19:13:36 Re: How to perform a long running dry run transaction without blocking
Previous Message Adrian Klaver 2025-02-06 18:44:36 Re: libc to libicu via pg_dump/pg_restore?