Changes between Version 56 and Version 57 of InstallationGuidelines/PostgreSQL

Timestamp:

11/16/11 10:46:06 (13 years ago)

Author:

Fran Boon

Comment:

--

InstallationGuidelines/PostgreSQL

@@ -262 +262 @@
  * http://www.postgresql.org/docs/8.4/static/runtime-config-logging.html
 
-Log all queries which take longer than 5s:
+Log all queries which take longer than 500ms:
 {{{
 vim /etc/rsyslog.conf
@@ -273 +273 @@
 syslog_facility = 'LOCAL0'
 syslog_ident = 'postgres'
-log_min_duration_statement = 5000
+log_min_duration_statement = 500
 
 /etc/init.d/postgresql restart
@@ -289 +289 @@
 
 
-Log all queries which take longer than 5s & do an 'EXPLAIN' on those queries (not working)
+Log all queries which take longer than 500ms & do an 'EXPLAIN' on those queries (not working)
  * http://www.depesz.com/index.php/2008/11/23/waiting-for-84-auto-explain/
 {{{
 LOAD 'auto_explain';
-set explain.log_min_duration = 5000;
+set explain.log_min_duration = 500;
 }}}
 == Also see ==