comparison PostgreSQL/NEWS @ 472:d1e1cb3ab741

back to mainline
author Alain Mazy <am@osimis.io>
date Thu, 08 Feb 2024 16:18:36 +0100
parents 19d40a152e49
children 15e609c439d1
comparison
equal deleted inserted replaced
470:11c6bcc9d1f2 472:d1e1cb3ab741
1 Pending changes in the mainline 1 Pending changes in the mainline
2 =============================== 2 ===============================
3 3
4
5 Release 6.0 (2024-02-08)
6 ========================
7
8 DB schema revision: 2
9
10 * The DB schema has been updated to Revision 2. If you need to reinstall the previous
11 version of the plugin, you should run this script:
12 https://orthanc.uclouvain.be/hg/orthanc-databases/file/tip/PostgreSQL/Plugins/SQL/Downgrades/Rev2ToRev1.sql
4 * Transaction Mode: 13 * Transaction Mode:
5 Introduced a new configuration to select the transaction isolation level 14 Introduced a new configuration "TransactionMode" to select the transaction isolation level.
6 "TransactionMode": "Serializable"
7 Allowed values: "Serializable", "ReadCommitted". 15 Allowed values: "Serializable", "ReadCommitted".
8 The "Serializable" mode was the only available value up to now. It is still the default 16 The "Serializable" mode was the only available value up to now. It is still the default
9 value now. 17 value now.
10 The "ReadCommitted" is possible now due to rewrites of SQL queries and notably improves 18 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. 19 the Orthanc ability to ingest data from multiple sources in parallel.
12 * internals:
13 - Added a UNIQUE constraint on Resources.publicId to detect DB inconsistencies
14 * New "EnableVerboseLogs" configuration to show SQL statements being executed. 20 * New "EnableVerboseLogs" configuration to show SQL statements being executed.
15 21
16 22
17 Release 5.1 (2023-06-27) 23 Release 5.1 (2023-06-27)
18 ======================== 24 ========================
25
26 DB schema revision: 1
19 27
20 * Optimization of LookupResources mainly used in tools/find, C-Find and QIDO-RS. 28 * Optimization of LookupResources mainly used in tools/find, C-Find and QIDO-RS.
21 29
22 Release 5.0 (2023-04-15) 30 Release 5.0 (2023-04-15)
23 ======================== 31 ========================