Re: how could select id=xx so slow?

From: Ants Aasma <ants(at)cybertec(dot)at>
To: Yan Chunlu <springrider(at)gmail(dot)com>
Cc: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: how could select id=xx so slow?
Date: 2012-07-12 16:07:17
Message-ID: CA+CSw_sWjnGoKPSqPKBB-u1Phe0ba-bm428wp-11-=qtRazkcA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Jul 12, 2012 at 3:48 PM, Yan Chunlu <springrider(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2012-07-12 18:53:35 Re: how could select id=xx so slow?
Previous Message Craig Ringer 2012-07-12 14:39:28 Re: how could select id=xx so slow?