From 3127d59613c54c58a77784ece4c0e2de02d5a282 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Tue, 26 Mar 2024 09:57:24 +0100 Subject: [PATCH] work around strange query planning behaviour --- nominatim/tokenizer/icu_tokenizer.py | 3 +++ 1 file changed, 3 insertions(+) diff --git a/nominatim/tokenizer/icu_tokenizer.py b/nominatim/tokenizer/icu_tokenizer.py index 251f4da5..9032d71b 100644 --- a/nominatim/tokenizer/icu_tokenizer.py +++ b/nominatim/tokenizer/icu_tokenizer.py @@ -163,6 +163,8 @@ class ICUTokenizer(AbstractTokenizer): else: LOG.info('Computing word frequencies') cur.drop_table('word_frequencies') + cur.execute('ANALYSE search_name') + cur.execute('ANALYSE word') cur.execute(""" CREATE TEMP TABLE word_frequencies AS WITH word_freq AS MATERIALIZED ( @@ -190,6 +192,7 @@ class ICUTokenizer(AbstractTokenizer): END) as info FROM word LEFT JOIN word_frequencies wf ON word.word_id = wf.id + ORDER BY word_id """) cur.drop_table('word_frequencies') -- 2.43.2