Обсуждение: 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/
> From each according to his ability. To each according to his ability to litigate.