comparison PostgreSQL/NEWS @ 468:8f1f26680527 pg-transactions

news
author Alain Mazy <am@osimis.io>
date Mon, 05 Feb 2024 09:47:40 +0100
parents ff84104f7842
children 19d40a152e49
comparison
equal deleted inserted replaced
467:ff84104f7842 468:8f1f26680527
1 Pending changes in the mainline 1 Pending changes in the mainline
2 =============================== 2 ===============================
3 3
4 * Experimental debug feature: 4 * Transaction Mode:
5 Introduced a new configuration to select the transaction isolation level 5 Introduced a new configuration to select the transaction isolation level
6 "TransactionMode": "Serializable" 6 "TransactionMode": "Serializable"
7 Allowed values: "Serializable", "ReadCommitted". 7 Allowed values: "Serializable", "ReadCommitted".
8 The "Serializable" mode was the only available value up to now. It is still the default 8 The "Serializable" mode was the only available value up to now. It is still the default
9 value now. 9 value now.
10 The "ReadCommitted" is possible now due to rewrites of SQL queries. 10 The "ReadCommitted" is possible now due to rewrites of SQL queries and notably improves
11 the Orthanc ability to ingest data from multiple sources in parallel.
11 * internals: 12 * internals:
12 - Added a UNIQUE constraint on Resources.publicId to detect DB inconsistencies 13 - Added a UNIQUE constraint on Resources.publicId to detect DB inconsistencies
13 * New "EnableVerboseLogs" configuration to show SQL statements being executed. 14 * New "EnableVerboseLogs" configuration to show SQL statements being executed.
14 15
15 16