Skip site navigation (1) Skip section navigation (2)

Re: Query is significantly slower on faster machine

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andy Lowe" <andyl(at)dmetrix(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Query is significantly slower on faster machine
Date: 2004-08-13 18:16:33
Message-ID: 25441.1092420993@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-odbc
"Andy Lowe" <andyl(at)dmetrix(dot)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

In response to

pgsql-odbc by date

Next:From: Wolfgang F├╝rtbauerDate: 2004-08-13 18:59:08
Subject: Problem with VB6, DAO, Data Control: Update does not work
Previous:From: Andrew AyersDate: 2004-08-13 17:04:03
Subject: Re: MS VB6 CheckBox with PostgreSQL ODBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group