Mercurial > gemma

changeset 3735:96230eadf96e

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added some optimizer hints to search functions.
author Sascha Wilde <wilde@intevation.de>
date Mon, 24 Jun 2019 11:49:08 +0200
parents 1504856c9378
children 4cc3b28fd87b
files schema/search_functions.sql
diffstat 1 files changed, 6 insertions(+), 6 deletions(-) [+]
line wrap: on
line diff
--- a/schema/search_functions.sql	Mon Jun 24 11:46:20 2019 +0200
+++ b/schema/search_functions.sql	Mon Jun 24 11:49:08 2019 +0200
@@ -12,7 +12,7 @@
 --  * Sascha Wilde <wilde@intevation.de>
 
 CREATE OR REPLACE FUNCTION search_hectometre(search_string text) RETURNS jsonb
-  LANGUAGE plpgsql
+  LANGUAGE plpgsql STABLE PARALLEL SAFE
   AS $$
 DECLARE
   _result jsonb;
@@ -33,7 +33,7 @@
 $$;
 
 CREATE OR REPLACE FUNCTION search_bottlenecks(search_string text) RETURNS jsonb
-  LANGUAGE plpgsql
+  LANGUAGE plpgsql STABLE PARALLEL SAFE
   AS $$
 DECLARE
   _result jsonb;
@@ -51,7 +51,7 @@
 $$;
 
 CREATE OR REPLACE FUNCTION search_cities(search_string text) RETURNS jsonb
-  LANGUAGE plpgsql
+  LANGUAGE plpgsql STABLE PARALLEL SAFE
   AS $$
 DECLARE
   _result jsonb;
@@ -73,7 +73,7 @@
 $$;
 
 CREATE OR REPLACE FUNCTION search_gauges(search_string text) RETURNS jsonb
-  LANGUAGE plpgsql
+  LANGUAGE plpgsql STABLE PARALLEL SAFE
   AS $$
 DECLARE
   _result jsonb;
@@ -104,7 +104,7 @@
 $$;
 
 CREATE OR REPLACE FUNCTION search_sections(search_string text) RETURNS jsonb
-  LANGUAGE plpgsql
+  LANGUAGE plpgsql STABLE PARALLEL SAFE
   AS $$
 DECLARE
   _result jsonb;
@@ -123,7 +123,7 @@
 $$;
 
 CREATE OR REPLACE FUNCTION search_most(search_string text) RETURNS jsonb
-  LANGUAGE plpgsql
+  LANGUAGE plpgsql STABLE PARALLEL SAFE
   AS $$
 BEGIN
   RETURN search_hectometre(search_string)