diff options
author | Ismaël Bouya <ismael.bouya@normalesup.org> | 2019-12-20 01:51:17 +0100 |
---|---|---|
committer | Ismaël Bouya <ismael.bouya@normalesup.org> | 2019-12-20 04:12:30 +0100 |
commit | 0907cf1ba08ad04cff9b1fe805ac6f2072c24142 (patch) | |
tree | 9be77c9bb710497372c4749822348916b166d63b /modules/private/databases/postgresql.nix | |
parent | ab8f306d7c2c49b8116e1af7b355ed2384617ed9 (diff) | |
download | Nix-0907cf1ba08ad04cff9b1fe805ac6f2072c24142.tar.gz Nix-0907cf1ba08ad04cff9b1fe805ac6f2072c24142.tar.zst Nix-0907cf1ba08ad04cff9b1fe805ac6f2072c24142.zip |
Optimize mysql and postgresql for write IO
Diffstat (limited to 'modules/private/databases/postgresql.nix')
-rw-r--r-- | modules/private/databases/postgresql.nix | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/modules/private/databases/postgresql.nix b/modules/private/databases/postgresql.nix index 1932a82..3dcd311 100644 --- a/modules/private/databases/postgresql.nix +++ b/modules/private/databases/postgresql.nix | |||
@@ -161,6 +161,9 @@ in { | |||
161 | lc_numeric = 'en_US.UTF-8' | 161 | lc_numeric = 'en_US.UTF-8' |
162 | lc_time = 'en_US.UTF-8' | 162 | lc_time = 'en_US.UTF-8' |
163 | default_text_search_config = 'pg_catalog.english' | 163 | default_text_search_config = 'pg_catalog.english' |
164 | # this introduces a small delay before storing on disk, but | ||
165 | # makes it order of magnitudes quicker | ||
166 | synchronous_commit = off | ||
164 | ssl = on | 167 | ssl = on |
165 | ssl_cert_file = '${config.security.acme.directory}/postgresql/fullchain.pem' | 168 | ssl_cert_file = '${config.security.acme.directory}/postgresql/fullchain.pem' |
166 | ssl_key_file = '${config.security.acme.directory}/postgresql/key.pem' | 169 | ssl_key_file = '${config.security.acme.directory}/postgresql/key.pem' |