Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Cc: ning <mailxiening(at)gmail(dot)com>, Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Subject: Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1
Date: 2009-07-16 09:33:41
Message-ID: 200907161133.41945.andres@anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thursday 16 July 2009 11:30:00 ning wrote:
> Hi Andres,
>
> By executing
> #explain analyze execute test_query;
>
> the first execution cost 0.389 seconds
> the second cost 0.285 seconds
Seconds or milliseconds?

If seconds that would be by far slower than the plain SELECT, right?

Andres

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Allan Kamau 2009-07-16 09:44:11 Re: [PERFORM] Concurrency issue under very heay loads
Previous Message ning 2009-07-16 09:30:00 Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1