Postgres Pro
Downloads
Home   >   mailing lists

Re: BigSerial and txid issuance - Mailing list pgsql-general

From David G. Johnston
Subject Re: BigSerial and txid issuance
Date
Msg-id CAKFQuwaUTFc8+fFxGM5bdxucj2aDVTmnx8tOy9vOj=umGUSmRw@mail.gmail.com
Whole thread Raw
In response to BigSerial and txid issuance  ("Yorwerth, Adam" <Adam.Yorwerth@tesco.com>)
List pgsql-general
Tree view
On Wed, Jul 8, 2020 at 8:18 AM Yorwerth, Adam <Adam.Yorwerth@tesco.com> wrote:

Is it possible for two transactions to interleave their issuance of these two variables?

 

Is it possible for transaction 1 to be issued txid 1001 and offset 12 and transaction 2 to be issued txid 1002 and offset 11?


Given all of the disclaimers about serial value issuance you should assume that it is possible.

David J.

pgsql-general by date:

Previous
From: FOUTE K. Jaurès
Date:
Subject: Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device
Next
From: Adrian Klaver
Date:
Subject: Re: BigSerial and txid issuance