Postgres Pro
Downloads
Home   >   mailing lists

Re: Query is significantly slower on faster machine - Mailing list pgsql-odbc

From Tom Lane
Subject Re: Query is significantly slower on faster machine
Date
Msg-id 25441.1092420993@sss.pgh.pa.us
Whole thread Raw
In response to Query is significantly slower on faster machine  ("Andy Lowe" <andyl@dmetrix.com>)
List pgsql-odbc
Tree view 
"Andy Lowe" <andyl@dmetrix.com> writes:
> I've got an application that runs on the same machine as my database.  The
> application contains a query that was taking significantly too long to run
> on a test system.  On my development machine, it runs approximately 8-10
> times faster, using a database containing identical data.

My first instinct is to think that you're getting different plans for
the query.  Try EXPLAIN ANALYZE'ing the query on both systems and see
what you get.

            regards, tom lane

pgsql-odbc by date:

Previous
From: "Andy Lowe"
Date:
Subject: Query is significantly slower on faster machine
Next
From: Andrew Ayers
Date:
Subject: Re: MS VB6 CheckBox with PostgreSQL ODBC