Sebastian Rychter wrote:
Hi, I’m executing a query through psql ODBC which is taking around 2 minutes to complete. When I run it from PgAdmin it takes less than 3 seconds.
The query itself has :
. 15 inner joins (from just around 10 different tables – the other inner joins are using different aliases for the same tables)
. Select statement returns 1 field.
. the testing database is selecting only 1 record.
Taking a look at the explain analyze report, I see they are both quite the same and tested the ODBC driver through Visual Foxpro and Vb.NET as well, taking both around 2 minutes to finish.
Any idea ?
Don't know if this is your issue but we had a legacy VB/ODBC app that selected a handful (10 or fewer) records from a single table but for some reason behind the scenes we discovered that the app selected the whole table. As you might imagine, this caused very poor performance on large tables. EXPLAIN will not reveal this. You might want to set the server to log all transactions and see what the app is really doing at the server level.
Cheers,
Steve
