domingo, 3 de maio de 2009

relatorios de erro

se¸c˜ao de relat´orio de erro no postgresql.conf
checkpoint (log checkpoints)
locks (log lock waits)
arquivos tempor´arios (log temp files)
Euler Taveira

consulta ao catalogo

consultas ao cat´alogo
pg stat *
pg statio *
pg settings
n´umero de conex˜oes
select datname,count(*) as num from pg stat activity group by
datname
Euler Taveira