diff options
author | rinpatch <rinpatch@sdf.org> | 2021-01-19 14:15:55 +0300 |
---|---|---|
committer | rinpatch <rinpatch@sdf.org> | 2021-01-19 14:26:17 +0300 |
commit | e58f45abd6fe6cdb4937788c6ff5a9f4cb923d39 (patch) | |
tree | e1e64b4c2ef0b496cd6e6b14d602505d490de6c3 /docs/installation | |
parent | 984426d9c4cadc59017c6770b033f4d72e497342 (diff) | |
download | pleroma-e58f45abd6fe6cdb4937788c6ff5a9f4cb923d39.tar.gz pleroma-e58f45abd6fe6cdb4937788c6ff5a9f4cb923d39.zip |
Improve PostgreSQL optimization article
Move query plan mode setting from OTP installation guide and try
to explain what it does.
Diffstat (limited to 'docs/installation')
-rw-r--r-- | docs/installation/otp_en.md | 13 |
1 files changed, 2 insertions, 11 deletions
diff --git a/docs/installation/otp_en.md b/docs/installation/otp_en.md index 63eda63ca..f36b33c32 100644 --- a/docs/installation/otp_en.md +++ b/docs/installation/otp_en.md @@ -89,6 +89,8 @@ RUM indexes are an alternative indexing scheme that is not included in PostgreSQ #### (Optional) Performance configuration It is encouraged to check [Optimizing your PostgreSQL performance](../configuration/postgresql.md) document, for tips on PostgreSQL tuning. +Restart PostgreSQL to apply configuration changes: + === "Alpine" ``` rc-service postgresql restart @@ -99,17 +101,6 @@ It is encouraged to check [Optimizing your PostgreSQL performance](../configurat systemctl restart postgresql ``` -If you are using PostgreSQL 12 or higher, add this to your Ecto database configuration - -```elixir -# -config :pleroma, Pleroma.Repo, -prepare: :named, -parameters: [ - plan_cache_mode: "force_custom_plan" -] -``` - ### Installing Pleroma ```sh # Create a Pleroma user |