Re: simple update queries take a long time - postgres 8.3.1 - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: simple update queries take a long time - postgres 8.3.1
Date
Msg-id 47F1498F.201@iol.ie
Whole thread Raw
In response to Re: simple update queries take a long time - postgres 8.3.1  (mark <markkicks@gmail.com>)
List pgsql-general
On 31/03/2008 21:11, mark wrote:

> it says actual time is 0.161 seconds or milliseconds.. but the total run
> time is 11 seconds.. any ideas why this discrepancy?

Well, I interpret the docs as implying that the difference between the
time quoted in the top line of EXPLAIN ANALYZE's output and the time in
"Total runtime" if effectively the time taken to apply the update.
Beyond that, I'm guessing.....

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: FATAL: bogus freespace amount
Next
From: "Olexandr Melnyk"
Date:
Subject: Re: GSoC Proposal: PL/Mono