Hello! Does anyone know whether the Postgres connector uses a single transaction when reading records from all the tables to ingest, or one transaction per table to ingest?
n
Nataly Merezhuk (Airbyte)
12/06/2022, 2:02 PM
Hi Florent, that's an excellent question, let me look into that. My guess would be though that it is one transaction per table as each table is a 'stream'.
f
Florent
12/07/2022, 5:01 PM
Thank you Nataly; looking forward to the answer.
u
user
12/08/2022, 2:31 PM
Hi! It is indeed one transaction per table or as we call it, 'stream'.