Skip site navigation (1) Skip section navigation (2)

measure database contention

From: "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
To: "psql performance list" <pgsql-performance(at)postgresql(dot)org>
Subject: measure database contention
Date: 2008-12-16 19:32:01
Message-ID: 3073cc9b0812161132w3ae157a8n69e2b0cccea05ca2@mail.gmail.com (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-performance by date

Next:From: Nimesh SatamDate: 2008-12-17 04:03:21
Subject: insert and Update slow after implementing slony.
Previous:From: Alvaro HerreraDate: 2008-12-16 13:45:42
Subject: Re: rebellious pg stats collector (reopened case)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group