Differences

This shows you the differences between two versions of the page.

--- sysadmin:postgresql [2014/09/12 15:06] – cambiata query per monitorare l'utilizzo degli indici letti
+++ sysadmin:postgresql [Unknown date] (current) – removed - external edit (Unknown date) 127.0.0.1
@@ Line 1: / Line 1: @@
-  * Performance Tuning: http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
-  * Ottimo articolo segnalato da AndreaF http://www.revsys.com/writings/postgresql-performance.html
-===== Query comode x debug =====
-  * Processi attivi: ''select * from pg_stat_activity;''
-  * Indici presenti: ''SELECT * FROM pg_indexes;''
-  * Utilizzo degli indici: ''SELECT relid,relname,idx_scan,idx_tup_read,idx_tup_fetch FROM pg_stat_all_indexes WHERE schemaname='public' ORDER BY idx_scan desc;''
-  * Utilizzo delle tabelle: ''SELECT * FROM pg_stat_all_tables;''
-  * Lock da https://wiki.postgresql.org/wiki/Lock_Monitoring (ho aggiunto il WHERE nel mio caso)
-  SELECT a.datname,
-         c.relname,
-         l.transactionid,
-         l.mode,
-         l.granted,
-         a.usename,
-         a.current_query,
-         a.query_start,
-         age(now(), a.query_start) AS "age",
-         a.procpid
-    FROM  pg_stat_activity a
-     JOIN pg_locks         l ON l.pid = a.procpid
-     JOIN pg_class         c ON c.oid = l.relation
-    WHERE mode='RowExclusiveLock' ORDER BY a.query_start;
-===== Avvio manuale di postgres =====
-se service postgresql start offre poca flessibilità usare
-  pg_ctlcluster 8.4 main start -- -w
-o ancora più a basso livello, da utente ''postgres'' eseguire:
-  /usr/lib/postgresql/8.4/bin/pg_ctl start -D /var/lib/postgresql/8.4/main -w -o '-c config_file="/etc/postgresql/8.4/main/postgresql.conf"'