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 <[EMAIL PROTECTED]> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature
