From 2cd9130726dec007e856d2c21916e6cd748d0537 Mon Sep 17 00:00:00 2001 From: Alexandre Alapetite Date: Fri, 6 Sep 2024 08:50:31 +0200 Subject: PostgreSQL suggestion of index improvement (#6705) https://www.postgresql.org/docs/current/sql-createstatistics.html https://www.postgresql.org/docs/current/sql-analyze.html Requires PostgreSQL 10+ (which is already EOL - shipped with Ubuntu 18.04, Debian 10 Buster -, so update doc at the same time even when not using it) https://www.postgresql.org/docs/release/10.0/ --- docs/en/admins/DatabaseConfig.md | 2 ++ 1 file changed, 2 insertions(+) (limited to 'docs/en/admins/DatabaseConfig.md') diff --git a/docs/en/admins/DatabaseConfig.md b/docs/en/admins/DatabaseConfig.md index aa80a3975..575749a7f 100644 --- a/docs/en/admins/DatabaseConfig.md +++ b/docs/en/admins/DatabaseConfig.md @@ -12,6 +12,8 @@ Without changing anything in FreshRSS’ code (which is using [`ILIKE`](https:// CREATE EXTENSION pg_trgm; CREATE INDEX gin_trgm_index_title ON freshrss_entry USING gin(title gin_trgm_ops); CREATE INDEX gin_trgm_index_content ON freshrss_entry USING gin(content gin_trgm_ops); +CREATE STATISTICS freshrss_entry_stats ON title, content FROM freshrss_entry; +ANALYZE freshrss_entry; ``` Where `freshrss_entry` needs to be adapted to the name of the *entry* of a given use, e.g., `freshrss_alice_entry`. -- cgit v1.2.3