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

From: ning <mailxiening(at)gmail(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org, 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:30:00
Message-ID: 27f31620907160230x20faa58aldd42465d1658b772@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)anarazel(dot)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
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andres Freund 2009-07-16 09:33:41 Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1
Previous Message Albe Laurenz 2009-07-16 09:15:24 Re: [PERFORM] Concurrency issue under very heay loads