Mercurial > hg > orthanc-databases
changeset 624:a0c2f38a7dea
back to mainline
author | Alain Mazy <am@orthanc.team> |
---|---|
date | Wed, 18 Dec 2024 18:52:40 +0100 |
parents | 218e145da8a3 (current diff) c704484ae9ae (diff) |
children | b96c96594e55 813f3633bea1 |
files | PostgreSQL/CMakeLists.txt |
diffstat | 1 files changed, 23 insertions(+), 17 deletions(-) [+] |
line wrap: on
line diff
--- a/PostgreSQL/NEWS Wed Dec 18 14:57:00 2024 +0100 +++ b/PostgreSQL/NEWS Wed Dec 18 18:52:40 2024 +0100 @@ -1,5 +1,5 @@ -Pending changes in the mainline (future 7.0) -=============================== +Release 7.0 (2024-12-18) +======================== DB schema revision: 3 Minimum plugin SDK (for build): 1.12.5+ @@ -14,34 +14,40 @@ of the new index can take some time (we have observed 3 minutes on a DB with 70M instances). Orthanc will not be available during the creation of this index. If needed, you can create it manually before installing - the new plugin by executing these SQL commands: + the new plugin by executing this SQL command (extracted from + https://orthanc.uclouvain.be/hg/orthanc-databases/file/default/PostgreSQL/Plugins/SQL/Upgrades/Rev2ToRev3.sql): - https://orthanc.uclouvain.be/hg/orthanc-databases/file/tip/PostgreSQL/Plugins/SQL/Upgrades/Partial/Rev2_To_Rev3.sql + CREATE INDEX IF NOT EXISTS ChildrenIndex2 ON Resources USING btree (parentId ASC NULLS LAST) INCLUDE (publicId, internalId) * WARNING: A new column has been added in the resources table when upgrading to this version. A new thread - is populating this new table and might consume DB bandwitdh and CPU. + is populating this new table and might consume DB bandwitdh and CPU until it has populated the column. + The creation of the new column might also take a few minutes the first time you launch this version. +* WARNING: when upgrading very large databases, make sur to read this section of the Orthanc book: + https://orthanc.uclouvain.be/book/plugins/postgresql.html#note-for-large-databases-and-multiple-orthanc-instances -* Added support for ExtendedChanges: - - changes?type=...&to=... -* Performance optimizations (to be summarized before release): - - using more prepared SQL statements: - - InsertOrUpdateMetadata - - ExecuteSetResourcesContentTags - - merged BEGIN and SET TRANSACTION statements +* Added support for ExtendedChanges introduced in Orthanc 1.12.5 + enabling new get arguments (type & to) in the /changes API route. +* Added support for ExtendedFind introduced in Orthanc 1.12.5 + enabling new filtering and ordering options in /tools/find API route. +* Performance optimizations: - reduced the number of round-trips between Orthanc and the PostgreSQL server: - - e.g: when receiving an instance in an existing series, reduced the number of SQL queries from 13 to 9 + - replaced numerous small queries by a single large query in /tools/find. + - reduced the number of queries when ingesting new instances. + - using more prepared SQL statements + * Fixed a memory leak when executing non cached SQL statements (rarely used) * New default values for configurations: - "IndexConnectionsCount": 50 - "TransactionMode": "ReadCommitted" -* Introduced a new thread to perform DB Housekeeping at regular interval (5s) for the - DB plugins requiring it (currently only PostgreSQL). E.g: This avoids very long update - times in case you don't call /statistics for a long period. The execution interval of - this thread can be configured through "HousekeepingInterval". +* Introduced a new thread to perform DB Housekeeping at regular interval. + E.g: This avoids very long update times in case you don't call /statistics + for a long period. The execution interval of this thread can be configured + through "HousekeepingInterval" (default: 1s). * Fix updates from plugin version 3.3 to latest version * Fix a bug introduced in 6.0 in the PatientRecyclingOrder when using patient protection. + Release 6.2 (2024-03-25) ========================