update command question? - Mailing list pgsql-general

From Charles.Hou
Subject update command question?
Date
Msg-id 1189998236.314155.63350@y42g2000hsy.googlegroups.com
Whole thread Raw
Responses Re: update command question?
List 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


pgsql-general by date:

Previous
From: Paul Boddie
Date:
Subject: Re: Database reverse engineering
Next
From: "Bima Djaloeis"
Date:
Subject: ON INSERT => execute AWK/SH/EXE?