Postgres Pro
Downloads
Home   >   mailing lists

Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 - Mailing list pgsql-performance

From Andres Freund
Subject Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1
Date
Msg-id 200907161133.41945.andres@anarazel.de
Whole thread Raw
In response to Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1  (ning <mailxiening@gmail.com>)
Responses Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: ning
Date:
Subject: Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1
Next
From: ning
Date:
Subject: Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1