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?
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
pgsql-performance by date
|Next:||From: Nimesh Satam||Date: 2008-12-17 04:03:21|
|Subject: insert and Update slow after implementing slony.|
|Previous:||From: Alvaro Herrera||Date: 2008-12-16 13:45:42|
|Subject: Re: rebellious pg stats collector (reopened case)|