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

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