From 6dbfb1669f2c3391b4323f0b606439f0c6148b47 Mon Sep 17 00:00:00 2001 From: Werner Hahn Date: Fri, 22 Sep 2017 02:48:11 +0200 Subject: [PATCH] =?utf8?q?WebshopApi:=20Trigram=20Indices=20f=C3=BCr=20Fuz?= =?utf8?q?zy=20Search?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- sql/Pg-upgrade2/trigram_indices.sql | 46 +++++++++++++++++++++++++++++ 1 file changed, 46 insertions(+) create mode 100644 sql/Pg-upgrade2/trigram_indices.sql diff --git a/sql/Pg-upgrade2/trigram_indices.sql b/sql/Pg-upgrade2/trigram_indices.sql new file mode 100644 index 000000000..87af0e852 --- /dev/null +++ b/sql/Pg-upgrade2/trigram_indices.sql @@ -0,0 +1,46 @@ +-- @tag: trigram_indices +-- @description: Trigram Indizes für häufig durchsuchte Spalten +-- @depends: release_3_5_0 shops +-- @encoding: utf-8 +-- @ignore: 1 + +-- CREATE EXTENSION IF NOT EXISTS pg_trgm; + +CREATE INDEX customer_customernumber_gin_trgm_idx ON customer USING gin (customernumber gin_trgm_ops); +CREATE INDEX customer_name_gin_trgm_idx ON customer USING gin (name gin_trgm_ops); + +CREATE INDEX vendor_vendornumber_gin_trgm_idx ON vendor USING gin (vendornumber gin_trgm_ops); +CREATE INDEX vendor_name_gin_trgm_idx ON vendor USING gin (name gin_trgm_ops); + +CREATE INDEX parts_partnumber_gin_trgm_idx ON parts USING gin (partnumber gin_trgm_ops); +CREATE INDEX parts_description_gin_trgm_idx ON parts USING gin (description gin_trgm_ops); + +CREATE INDEX oe_ordnumber_gin_trgm_idx ON oe USING gin (ordnumber gin_trgm_ops); +CREATE INDEX oe_quonumber_gin_trgm_idx ON oe USING gin (quonumber gin_trgm_ops); +CREATE INDEX oe_cusordnumber_gin_trgm_idx ON oe USING gin (cusordnumber gin_trgm_ops); +CREATE INDEX oe_transaction_description_gin_trgm_idx ON oe USING gin (transaction_description gin_trgm_ops); + +CREATE INDEX do_donumber_gin_trgm_idx ON delivery_orders USING gin (donumber gin_trgm_ops); +CREATE INDEX do_ordnumber_gin_trgm_idx ON delivery_orders USING gin (ordnumber gin_trgm_ops); +CREATE INDEX do_cusordnumber_gin_trgm_idx ON delivery_orders USING gin (cusordnumber gin_trgm_ops); +CREATE INDEX do_transaction_description_gin_trgm_idx ON delivery_orders USING gin (transaction_description gin_trgm_ops); + +CREATE INDEX ar_invnumber_gin_trgm_idx ON ar USING gin (invnumber gin_trgm_ops); +CREATE INDEX ar_ordnumber_gin_trgm_idx ON ar USING gin (ordnumber gin_trgm_ops); +CREATE INDEX ar_quonumber_gin_trgm_idx ON ar USING gin (quonumber gin_trgm_ops); +CREATE INDEX ar_cusordnumber_gin_trgm_idx ON ar USING gin (cusordnumber gin_trgm_ops); +CREATE INDEX ar_transaction_description_gin_trgm_idx ON ar USING gin (transaction_description gin_trgm_ops); + +CREATE INDEX ap_invnumber_gin_trgm_idx ON ap USING gin (invnumber gin_trgm_ops); +CREATE INDEX ap_ordnumber_gin_trgm_idx ON ap USING gin (ordnumber gin_trgm_ops); +CREATE INDEX ap_quonumber_gin_trgm_idx ON ap USING gin (quonumber gin_trgm_ops); +CREATE INDEX ap_transaction_description_gin_trgm_idx ON ap USING gin (transaction_description gin_trgm_ops); + +CREATE INDEX gl_description_gin_trgm_idx ON gl USING gin (description gin_trgm_ops); +CREATE INDEX gl_reference_gin_trgm_idx ON gl USING gin (reference gin_trgm_ops); + +CREATE INDEX orderitems_description_gin_trgm_idx ON orderitems USING gin (description gin_trgm_ops); + +CREATE INDEX doi_description_gin_trgm_idx ON delivery_order_items USING gin (description gin_trgm_ops); + +CREATE INDEX invoice_description_gin_trgm_idx ON invoice USING gin (description gin_trgm_ops); -- 2.20.1