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

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
>