Question about Postgres transaction mode

Hello, hopefully a very quick question about the TransactionMode setting for Postgres.

Is there anything potential problems I need to be aware of if I switch from Serializable to ReadCommitted? I’m aware of the differences in general and I’m assuming that by offering Read Committed as an option, the application can handle any inconsistencies that could arise from the looser isolation level. Is this a correct assumption?

Just want to make sure I fully understand any consequences before switching. Thank you.

Hi @josh.keller

No consequences to expect besides improved performances :wink:

BTW, ReadCommitted is now the default value and is being used at many places.

Best,

Alain

1 Like