(incubator-kie-kogito-apps) branch main updated: [kie-issues#923] Add index to foreign key columns to improve performance in postgresql (#1985)

[mw...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

mweiler pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/incubator-kie-kogito-apps.git


The following commit(s) were added to refs/heads/main by this push:
     new 990f29f0a [kie-issues#923] Add index to foreign key columns to improve performance in postgresql (#1985)
990f29f0a is described below

commit 990f29f0ab790191b8bcbc7c070e7685dcb3e7b9
Author: Martin Weiler <mw...@ibm.com>
AuthorDate: Wed Feb 14 09:05:58 2024 -0700

    [kie-issues#923] Add index to foreign key columns to improve performance in postgresql (#1985)
---
 .../resources/db/migration/V1.45.0.3__add_fk_index.sql  | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)

diff --git a/data-index/data-index-storage/data-index-storage-postgresql/src/main/resources/db/migration/V1.45.0.3__add_fk_index.sql b/data-index/data-index-storage/data-index-storage-postgresql/src/main/resources/db/migration/V1.45.0.3__add_fk_index.sql
new file mode 100644
index 000000000..72e909ac5
--- /dev/null
+++ b/data-index/data-index-storage/data-index-storage-postgresql/src/main/resources/db/migration/V1.45.0.3__add_fk_index.sql
@@ -0,0 +1,17 @@
+create index if not exists idx_attachments_tid on attachments(task_id);
+create index if not exists idx_comments_tid on comments(task_id);
+create index if not exists idx_definitions_addons_pid_pv on definitions_addons(process_id, process_version);
+create index if not exists idx_definitions_annotations_pid_pv on definitions_annotations(process_id, process_version);
+create index if not exists idx_definitions_metadata_pid_pv on definitions_metadata(process_id, process_version);
+create index if not exists idx_definitions_nodes_pid_pv on definitions_nodes(process_id, process_version);
+create index if not exists idx_definitions_nodes_metadata_pid_pv on definitions_nodes_metadata(process_id, process_version);
+create index if not exists idx_definitions_roles_pid_pv on definitions_roles(process_id, process_version);
+create index if not exists idx_milestones_piid on milestones(process_instance_id);
+create index if not exists idx_nodes_piid on nodes(process_instance_id);
+create index if not exists idx_processes_addons_pid on processes_addons(process_id);
+create index if not exists idx_processes_roles_pid on processes_roles(process_id);
+create index if not exists idx_tasks_admin_groups_tid on tasks_admin_groups(task_id);
+create index if not exists idx_tasks_admin_users_tid on tasks_admin_users(task_id);
+create index if not exists idx_tasks_excluded_users_tid on tasks_excluded_users(task_id);
+create index if not exists idx_tasks_potential_groups_tid on tasks_potential_groups(task_id);
+create index if not exists idx_tasks_potential_users_tid on tasks_potential_users(task_id);


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@kie.apache.org
For additional commands, e-mail: commits-help@kie.apache.org