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/admins/DatabaseConfig.md | |
| 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/admins/DatabaseConfig.md')
| -rw-r--r-- | docs/en/admins/DatabaseConfig.md | 2 |
1 files changed, 2 insertions, 0 deletions
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`. |