[FOLIO-2245] verify performance of a dedicated FK/PK column (with an index) vs JSONB::UUID column (with an index) Created: 09/Sep/19  Updated: 03/Jun/20  Resolved: 11/Sep/19

Status: Closed
Project: FOLIO
Components: None
Affects versions: None
Fix versions: None

Type: Task Priority: P2
Reporter: Jakub Skoczen Assignee: Adam Dickmeiss
Resolution: Done Votes: 0
Labels: platform-backlog
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Issue links:
Blocks
blocks RMB-468 Foreign key field index Closed
Sprint: CP: sprint 72
Development Team: Core: Platform

 Description   

This is to decide on the next step for RMB-468 Closed and performnace issues like MODINVSTOR-256 Closed .



 Comments   
Comment by Adam Dickmeiss [ 11/Sep/19 ]

I vote for dedicated FK/PK column. The performance seem to be slightly better as seen in MODINVSTOR-256 Closed .

Generated at Thu Feb 08 23:19:16 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.