update command question?
i have the log analysis report by using the pgFouine. in the part of
Slowest queries, the update commands " update com_status set
travel=620.70001220703 where no=1" have the high Av.duration(s). how
should i do to solve this problem? why this simple command can take
up
the most time?
Av.duration(s) :21.06
Times executed: 9
total duration : 3m9s
On Sun, Sep 16, 2007 at 08:03:56PM -0700, Charles.Hou wrote:
i have the log analysis report by using the pgFouine. in the part of
Slowest queries, the update commands " update com_status set
travel=620.70001220703 where no=1" have the high Av.duration(s). how
should i do to solve this problem? why this simple command can take
up
the most time?
Maybe you are missing an index? In any case, you're going to have to
provide *much* more information (at the very least an explain analyse
of that statement) if you want any more detailed answer.
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
Show quoted text
From each according to his ability. To each according to his ability to litigate.