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

From ning
Subject Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1
Date
Msg-id 27f31620907160230x20faa58aldd42465d1658b772@mail.gmail.com
Whole thread Raw
In response to Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1  (Andres Freund <andres@anarazel.de>)
Responses Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1
List pgsql-performance
Hi Andres,

By executing
#explain analyze execute test_query;

the first execution cost 0.389 seconds
the second cost 0.285 seconds

Greetings,
Ning


On Thu, Jul 16, 2009 at 4:45 PM, Andres Freund<andres@anarazel.de> wrote:
> On Thursday 16 July 2009 03:11:29 ning wrote:
>> Hi Andres,
>>
>> The log for the test you suggested is as follows in PostgreSQL8.2.4,
>> but I cannot find a clue to prove or prove not PostgreSQL is doing
>> plan caching.
> Well. How long is the PREPARE and the EXECUTEs taking?
>
>
> Andres
>

pgsql-performance by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Concurrency issue under very heay loads
Next
From: Andres Freund
Date:
Subject: Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1