0

I'd like to persistently set the transaction isolation level to SERIALIZABLE for all future sessions, but I can see only see a way to do it at the session only.

If this is possible, how can it be done?

1 Answers1

2

This answer has the solution.

The variable is default_transaction_isolation.

Community
  • 1
  • 1
  • 1
    Do be aware that this may surprise applications that are not expecting serialization failure rollbacks - though most apps that support multiple DBs should be written to cope, as some DBs default to serializable. – Craig Ringer Feb 09 '14 at 23:41
  • @CraigRinger Indeed! In my case, I need perfect data at high speeds and don't care about failed writes as it can be easily remedied by later attempts, a special case. –  Feb 09 '14 at 23:43