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

From Craig Ringer
Subject Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1
Date
Msg-id 1247646470.32366.27.camel@tillium.localnet
Whole thread Raw
In response to 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
Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1
Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1
List 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


pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1
Next
From: Greg Stark
Date:
Subject: Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1