Changes between Version 8 and Version 9 of jazz/PostgreSQL

Timestamp:

Mar 26, 2018, 11:19:46 AM (6 years ago)

Author:

jazz

Comment:

--

jazz/PostgreSQL

@@ -99 +99 @@
 postgres=# SELECT * FROM pg_settings WHERE  name = 'max_connections';
 }}}
+* [https://stackoverflow.com/questions/8288823/query-a-parameter-postgresql-conf-setting-like-max-connections 參考]
 
 == 效能調校 ==
@@ -220 +221 @@
 [LOW] Upgrade to last version
 }}}
+  * 這裡提到的 `update your kernel parameters line with elevator=deadline to keep this parameter at next reboot` 必須改在 `/etc/default/grub` 的 `GRUB_CMDLINE_LINUX`
+{{{
+GRUB_CMDLINE_LINUX="rd.lvm.lv=centos/root rd.lvm.lv=centos/swap rhgb quiet elevator=deadline"
+}}}