Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: simple update queries take a long time - postgres 8.3.1
- From: Raymond O'Donnell <rod(at)iol(dot)ie>
- To: mark <markkicks(at)gmail(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: simple update queries take a long time - postgres 8.3.1
- Date: Mon, 31 Mar 2008 21:29:03 +0100
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(at)iol(dot)ie ---------------------------------------------------------------
- References:
- simple update queries take a long time - postgres 8.3.1
- From: mark
- Re: simple update queries take a long time - postgres 8.3.1
- From: Raymond O'Donnell
- Re: simple update queries take a long time - postgres 8.3.1
- From: mark
- Re: simple update queries take a long time - postgres 8.3.1
- From: Raymond O'Donnell
- Re: simple update queries take a long time - postgres 8.3.1
- From: mark
- Re: simple update queries take a long time - postgres 8.3.1
- From: Raymond O'Donnell
- Re: simple update queries take a long time - postgres 8.3.1
- From: mark
- simple update queries take a long time - postgres 8.3.1
- Prev by Date: Re: FATAL: bogus freespace amount
- Next by Date: Re: GSoC Proposal: PL/Mono
- Previous by thread: Re: simple update queries take a long time - postgres 8.3.1
- Next by thread: Check if table or View exists
- Indexes: