Changes between Version 53 and Version 54 of InstallationGuidelines/PostgreSQL


Ignore:
Timestamp:
11/15/11 15:37:32 (13 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • InstallationGuidelines/PostgreSQL

    v53 v54  
    257257== Troubleshooting ==
    258258
     259 * http://wiki.postgresql.org/wiki/Performance_Optimization
    259260 * http://wiki.postgresql.org/wiki/SlowQueryQuestions
     261 * http://www.revsys.com/writings/postgresql-performance.html
     262 * http://www.depesz.com/index.php/2008/11/23/waiting-for-84-auto-explain/
     263
     264Log all queries which take longer than 5s:
     265{{{
     266su postgres
     267psql
     268set log_min_duration_statement = 5000;
     269\q
     270
     271tail -n 45 -f /var/log/postgresql/postgresql-8.4-main.log
     272}}}
     273
     274Disable logging again:
     275{{{
     276su postgres
     277psql
     278set log_min_duration_statement = -1;
     279\q
     280}}}
     281
     282Log all queries which take longer than 5s & do an 'EXPLAIN' on those queries (not working)
     283{{{
     284LOAD 'auto_explain';
     285set explain.log_min_duration = 5000;
     286}}}
    260287== Also see ==
    261288 * [wiki:InstallationGuidelinesGISDataLinux#PostGIS PostGIS Installation]