"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ürtbauer||Date: 2004-08-13 18:59:08|
|Subject: Problem with VB6, DAO, Data Control: Update does not work|
|Previous:||From: Andrew Ayers||Date: 2004-08-13 17:04:03|
|Subject: Re: MS VB6 CheckBox with PostgreSQL ODBC|