added change_settings.md

1 files changed, 15 insertions, 0 deletions

diff --git a/change_settings.md b/change_settings.md
new file mode 100644
index 0000000..c227654
--- /dev/null
+++ b/change_settings.md
@@ -0,0 +1,15 @@
+# Does changing a config setting require a restart of postgresql or just a reload (SIGHUP)?
+
+This can be archived by simply selecting the setting from pg_settings. 
+
+```
+select context from pg_settings where name='max_wal_size';
+```
+
+# Is a restart of postgresql required?
+
+```
+select pending_restart from pg_settings where name='max_wal_size';
+```
+
+This will tell you if a restart is pending for a setting.