update command question?

From: "Charles(dot)Hou" <ivan(dot)hou(at)msa(dot)hinet(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: update command question?
Date: 2007-09-17 03:03:56
Message-ID: 1189998236.314155.63350@y42g2000hsy.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Troy Rasiah 2007-09-17 04:13:09 Re: Time Zone design issues
Previous Message Ow Mun Heng 2007-09-17 01:42:10 Re: help w/ SRF function