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 <[email protected]>
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: [email protected]
For additional commands, e-mail: [email protected]
