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/02_Prerequisites.md | 2 +- docs/en/admins/DatabaseConfig.md | 2 ++ docs/fr/users/01_Installation.md | 2 +- 3 files changed, 4 insertions(+), 2 deletions(-) (limited to 'docs') diff --git a/docs/en/admins/02_Prerequisites.md b/docs/en/admins/02_Prerequisites.md index 6902a97e7..f048d8534 100644 --- a/docs/en/admins/02_Prerequisites.md +++ b/docs/en/admins/02_Prerequisites.md @@ -9,7 +9,7 @@ You need to verify that your server can run FreshRSS before installing it. If yo | Web server | **Apache 2.4** | nginx, lighttpd
minimal compatibility with Apache 2.2 | | PHP | **PHP 7.4+** | FreshRSS 1.21/1.22: PHP 7.2+; FreshRSS 1.23/1.24: PHP 7.4+ | | PHP modules | Required: libxml, cURL, JSON, PDO_MySQL, PCRE and ctype.
Required (32-bit only): GMP
Recommended: Zlib, mbstring, iconv, ZipArchive
*For the whole modules list see [Dockerfile](https://github.com/FreshRSS/FreshRSS/blob/edge/Docker/Dockerfile-Alpine#L7-L9)* | | -| Database | **PostgreSQL 9.5+** | SQLite, MySQL 5.5.3+, MariaDB 5.5+ | +| Database | **PostgreSQL 10+** | SQLite, MySQL 5.5.3+, MariaDB 5.5+ | | Browser | **Firefox** | Chrome, Opera, Safari, or Edge | ## Getting the appropriate version of FreshRSS 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`. diff --git a/docs/fr/users/01_Installation.md b/docs/fr/users/01_Installation.md index 3f4aaa45f..7e331776c 100644 --- a/docs/fr/users/01_Installation.md +++ b/docs/fr/users/01_Installation.md @@ -9,7 +9,7 @@ Il est toutefois de votre responsabilité de vérifier que votre hébergement pe | Serveur web | **Apache 2.4+** | nginx, lighttpd | | PHP | **PHP 7.4+** | | | Modules PHP | Requis : libxml, cURL, JSON, PDO_MySQL, PCRE et ctype
Requis (32 bits seulement) : GMP
Recommandé : Zlib, mbstring et iconv, ZipArchive
*Pour une liste complète des modules nécessaires voir le [Dockerfile](https://github.com/FreshRSS/FreshRSS/blob/edge/Docker/Dockerfile-Alpine#L7-L9)* | | -| Base de données | **PostgreSQL 9.5+** | SQLite, MySQL 5.5.3+, MariaDB 5.5+ | +| Base de données | **PostgreSQL 10+** | SQLite, MySQL 5.5.3+, MariaDB 5.5+ | | Navigateur | **Firefox** | Chrome, Opera, Safari, or Edge | ## Choisir la bonne version de FreshRSS -- cgit v1.2.3