measure database contention

Поиск
Список
Период
Сортировка
Искать
От
Jaime Casanova
Тема
measure database contention
Дата
Msg-id
3073cc9b0812161132w3ae157a8n69e2b0cccea05ca2@mail.gmail.com
Список
Дерево обсуждения
measure database contention "Jaime Casanova" <jcasanov@systemguards.com.ec>
Re: measure database contention "Robert Haas" <robertmhaas@gmail.com>
Re: measure database contention "Jaime Casanova" <jcasanov@systemguards.com.ec>
Re: measure database contention "Robert Haas" <robertmhaas@gmail.com>
Re: measure database contention "Jaime Casanova" <jcasanov@systemguards.com.ec>
Re: measure database contention "Robert Haas" <robertmhaas@gmail.com>
Re: measure database contention "Scott Marlowe" <scott.marlowe@gmail.com>
Re: measure database contention "Merlin Moncure" <mmoncure@gmail.com>
Re: measure database contention "Albe Laurenz" <laurenz.albe@wien.gv.at>
Re: measure database contention "Jaime Casanova" <jcasanov@systemguards.com.ec>
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 по дате отправления
От: Greg Smith
Дата:
Сообщение: Re: filesystems benchmark
От: Nimesh Satam
Дата:
FAQ