Is there a way to use exported snapshots in autocommit mode ?

From: Hannu Krosing <hannuk(at)google(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Is there a way to use exported snapshots in autocommit mode ?
Date: 2022-12-09 16:07:40
Message-ID: CAMT0RQTDTi455Zjfw4_3kBHoy0ALo0xLm5Quo4r-fw9YRWYz+g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello hackers,

Is there a way to use exported snapshots in autocommit mode ?

Either something similar to defaults
in default_transaction_deferrable, default_transaction_isolation,
default_transaction_read_only
Or something that could be set in the function's SET part.

Context: I am working on speeding up large table copy via parallelism using
pl/proxy SPLIT functionality and would like to have all the parallel
sub-copies run with the same snapshot.

Best Regards
Hannu

Browse pgsql-hackers by date

  From Date Subject
Next Message Amul Sul 2022-12-09 16:16:34 Re: Error-safe user functions
Previous Message Heikki Linnakangas 2022-12-09 15:50:00 Re: Raising the SCRAM iteration count