| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | "elias ghanem" <e(dot)ghanem(at)acteos(dot)com>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Slow update query |
| Date: | 2010-01-21 15:43:19 |
| Message-ID: | 4B5821B7020000250002E954@gw.wicourts.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
"elias ghanem" <e(dot)ghanem(at)acteos(dot)com> wrote:
> I'm not sure this is the right place to ask my question
Yes it is. You gave a lot of good information, but we'd have a
better shot at diagnosing the issue with a bit more. Please read
the following and resubmit with as much of the requested information
as you can. Note that you might need to break out the problem query
from the function to run EXPLAIN ANALYZE (the output of which is one
of the more useful diagnostic tools we have).
http://wiki.postgresql.org/wiki/SlowQueryQuestions
-Kevin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2010-01-21 15:51:51 | Re: New server to improve performance on our large and busy DB - advice? |
| Previous Message | elias ghanem | 2010-01-21 15:27:02 | Slow update query |