Re: how could select id=xx so slow? - Mailing list pgsql-performance

From Ants Aasma
Subject Re: how could select id=xx so slow?
Date
Msg-id CA+CSw_sWjnGoKPSqPKBB-u1Phe0ba-bm428wp-11-=qtRazkcA@mail.gmail.com
Whole thread Raw
In response to Re: how could select id=xx so slow?  (Yan Chunlu <springrider@gmail.com>)
Responses Re: how could select id=xx so slow?  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-performance
On Thu, Jul 12, 2012 at 3:48 PM, Yan Chunlu <springrider@gmail.com> wrote:
> yes the system seems overloaded, I am dealing with a simple "INSERT" but not
> sure if it is normal that it took more time than the explain estimated:

The estimated cost is in arbitrary units, its purpose is to compare
different execution plans, not estimate time taken. So it's completely
normal that it doesn't match actual time taken.

Ants Aasma
--
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt
Web: http://www.postgresql-support.de

pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: how could select id=xx so slow?
Next
From: Jeff Janes
Date:
Subject: Re: how could select id=xx so slow?