From 31e1f836e714c3da56f99cdadb6c8340b08c8b08 Mon Sep 17 00:00:00 2001 From: Thomas Markwalder Date: Fri, 22 Jul 2022 09:28:43 -0400 Subject: [PATCH] [#2452] Addressed review comments share/database/scripts/pgsql/dhcpdb_create.pgsql share/database/scripts/pgsql/upgrade_012_to_013.sh.in Removed extraneous index --- src/share/database/scripts/pgsql/dhcpdb_create.pgsql | 6 ++---- src/share/database/scripts/pgsql/upgrade_012_to_013.sh.in | 6 ++---- 2 files changed, 4 insertions(+), 8 deletions(-) diff --git a/src/share/database/scripts/pgsql/dhcpdb_create.pgsql b/src/share/database/scripts/pgsql/dhcpdb_create.pgsql index 9187f8710f..f24e086a6e 100644 --- a/src/share/database/scripts/pgsql/dhcpdb_create.pgsql +++ b/src/share/database/scripts/pgsql/dhcpdb_create.pgsql @@ -5605,10 +5605,8 @@ END; $$ LANGUAGE plpgsql; -- Improve hosts indexes for better performance of global reservations --- Create new index that uses only dhcp4_identifier. -CREATE INDEX key_dhcp4_identifier on hosts (dhcp_identifier, dhcp_identifier_type); --- Create new index that uses only dhcp4_identifier. -CREATE INDEX key_dhcp6_identifier on hosts (dhcp_identifier, dhcp_identifier_type); +-- Create new index that uses only dhcp_identifier. +CREATE INDEX key_dhcp_identifier on hosts (dhcp_identifier, dhcp_identifier_type); -- Modify existing indexes to include subnet_id values of 0, so index is also used -- for global reservations. diff --git a/src/share/database/scripts/pgsql/upgrade_012_to_013.sh.in b/src/share/database/scripts/pgsql/upgrade_012_to_013.sh.in index 020edca5fe..bb45b9e732 100644 --- a/src/share/database/scripts/pgsql/upgrade_012_to_013.sh.in +++ b/src/share/database/scripts/pgsql/upgrade_012_to_013.sh.in @@ -654,10 +654,8 @@ END; \$\$ LANGUAGE plpgsql; -- Improve hosts indexes for better performance of global reservations --- Create new index that uses only dhcp4_identifier. -CREATE INDEX key_dhcp4_identifier on hosts (dhcp_identifier, dhcp_identifier_type); --- Create new index that uses only dhcp4_identifier. -CREATE INDEX key_dhcp6_identifier on hosts (dhcp_identifier, dhcp_identifier_type); +-- Create new index that uses only dhcp_identifier. +CREATE INDEX key_dhcp_identifier on hosts (dhcp_identifier, dhcp_identifier_type); -- Modify existing indexes to include subnet_id values of 0, so index is also used -- for global reservations. -- 2.47.2