Re: Query performance

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query performance
Date: 2006-05-22 23:33:33
Message-ID: slrne74iif.jf9.sgunderson@trofast.sesse.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

antonio(dot)batovanja(at)humanomed(dot)co(dot)at wrote:
> The above query takes 5 seconds to execute!
>
> [...]
>
> Total runtime: 96109.571 ms

It sure doesn't look like it...

> Total runtime: 461.907 ms
>
> [...]
>
> Suddenly the query takes only 0.29 seconds!

How are you timing this, really?

/* Steinar */
--
Homepage: http://www.sesse.net/

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jonathan Blitz 2006-05-23 00:33:09 Re: slow query using sub select
Previous Message Tom Lane 2006-05-22 23:07:24 Re: slow query using sub select