Re: update command question?

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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.