[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: |
|
||||||||
| Sprint: | CP: sprint 72 | ||||||||
| Development Team: | Core: Platform | ||||||||
| Description |
|
This is to decide on the next step for
|
| 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
|