Changes between Version 2 and Version 3 of jazz/PostgreSQL

Timestamp:

Mar 26, 2018, 10:50:18 AM (7 years ago)

Author:

jazz

Comment:

--

jazz/PostgreSQL

@@ -64 +64 @@
 postgres=# ALTER USER 使用者名稱 WITH SUPERUSER;
 }}}
+
+== 查詢目前連線數 ==
+* 查連線總數
+{{{
+postgres=#  SELECT count(*) FROM pg_stat_activity;
+ count 
+-------
+    52
+(1 row)
+}}}
+* 依資料庫查詢各別連線數
+{{{
+postgres=#  SELECT datname, count(*) FROM pg_stat_activity GROUP BY datname;
+}}}
+
+== 修改同時連線數上限 ==
+
+{{{
+
+}}}
+
+== 查詢同時連線數上限 ==
+
+{{{
+postgres=# SHOW max_connections;
+}}}