Hello again!
I modified the application I mentioned in my last post, the one that is
taking 20 minutes to solve a problem on our customer's system that is
solved in under ten seconds on my machine. The application is written
in C++. All data access is through a class named CCRecordset. We
Rob Richardson wrote:
The slow access seems to be happening with a single table. Here's the
query:
Can you post EXPLAIN ANALYZE output?
This query took about 75 seconds.
I ran PGAdmin on the same machine that the application is running on,
and executed the same query on the same