[SYNCOPE-1609] Reduce the number of table joins into PostgreSQL JSONB persistence implementation

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1.8
• Fix Version/s: 2.1.9, 3.0.0
• Component/s: core
• Labels: jpa-json jsonb postgresql
• Assignee: Fabio Martelli
• Reporter: Fabio Martelli
• Created: 11/Jan/21 21:26
• Updated: 07/Apr/21 06:29
• Resolved: 12/Jan/21 08:41

Description

By exploiting new JSON Functions and Operators provided with PostgreSQL 12 it would be possible to remove several useless joins in order to improve user and any object search performance.

 

Take a look at "JSON Processing Functions" into [1].

 

[1]https://www.postgresql.org/docs/12/functions-json.html

Issue Links

• links to: GitHub Pull Request #233