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

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: ning <mailxiening(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1
Date: 2009-07-15 08:27:50
Message-ID: 1247646470.32366.27.camel@tillium.localnet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, 2009-07-15 at 12:10 +0900, ning wrote:

> First execution: PostgreSQL 0.006277 seconds / DB2 0.009028 seconds
> Second execution: PostgreSQL 0.005932 seconds / DB2 0.000332 seconds

Actually, on second thoughts that looks a lot like DB2 is caching the
query results and is just returning the cached results when you repeat
the query.

I'm not sure to what extent PostgreSQL is capable of result caching, but
I'd be surprised if it could do as much as DB2.

--
Craig Ringer

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Stark 2009-07-15 08:37:00 Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1
Previous Message Craig Ringer 2009-07-15 08:26:14 Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1