measure database contention - Mailing list pgsql-performance

From Jaime Casanova
Subject measure database contention
Date
Msg-id 3073cc9b0812161132w3ae157a8n69e2b0cccea05ca2@mail.gmail.com
Whole thread Raw
Responses Re: measure database contention
Re: measure database contention
Re: measure database contention
List pgsql-performance
Hi,

we have a some bad queries (developers are working on that), some of
them run in 17 secs and that is the average but when analyzing logs i
found that from time to time some of them took upto 3 mins (the same
query that normally runs in 17secs).

so my question is: how could i look for contention problems?

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: filesystems benchmark
Next
From: "Nimesh Satam"
Date:
Subject: insert and Update slow after implementing slony.