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:26:14
Message-ID: 1247646374.32366.25.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:
> Hi,
>
> I am transplanting an application to use PostgreSQL8.2.4 instead of DB2 9.1.
> CLI was used to connect to DB2, and ODBC is used to connect to PostgreSQL.
> The query statement is as follows:

> PostgreSQL cost nearly the same time but DB2 ran 30 times faster in
> second execution.

Can you run your query with EXPLAIN ANALYZE and post the results, both
of the first and later executions?

--
Craig Ringer

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Craig Ringer 2009-07-15 08:27:50 Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1
Previous Message Greg Stark 2009-07-15 08:22:26 Re: Poor query performance