Re: Query is significantly slower on faster machine

"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