diff options
| author |  Alexandre Alapetite <alexandre@alapetite.fr>
| 2024-09-06 08:50:31 +0200 |
|---|---|---|
| committer |  GitHub <noreply@github.com>
| 2024-09-06 08:50:31 +0200 |
| commit | 2cd9130726dec007e856d2c21916e6cd748d0537 (patch) | |
| tree | 4b31663f6ca279a68203bd8aad4e059cf1fb9ef8 /docs/en | |
| parent | da13a4b663580a13376f5d15a136c9fb5380d979 (diff) | |
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/
Diffstat (limited to 'docs/en')
| -rw-r--r-- | docs/en/admins/02_Prerequisites.md | 2 | ||||
| -rw-r--r-- | docs/en/admins/DatabaseConfig.md | 2 |
2 files changed, 3 insertions, 1 deletions
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<br />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.<br />Required (32-bit only): GMP <br />Recommended: Zlib, mbstring, iconv, ZipArchive<br />*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`. |