Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Enhance postgresql scripts with index for FK constraints in data-index #923

Closed
martinweiler opened this issue Feb 12, 2024 · 0 comments · Fixed by apache/incubator-kie-kogito-apps#1985
Closed

Enhance postgresql scripts with index for FK constraints in data-index #923

martinweiler opened this issue Feb 12, 2024 · 0 comments · Fixed by apache/incubator-kie-kogito-apps#1985
Assignees
@martinweiler
Labels
area:engine Related to the runtime engines

Comments

@martinweiler
Copy link

Performance testing has revealed degraded performance over time in data-index with postgresql persistence. See the discussion on the apache mailing list for further details.

Creating indexes for the FK columns should help to improve performance.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@martinweiler martinweiler

Labels
area:engine Related to the runtime engines
Projects
🦉 KIE Podling Board
Archived in project
Milestone
No milestone
2 participants
@martinweiler @yesamer