[GENERAL] Slow cross-machine read on one table

2009-02-10 Thread Rob Richardson
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

Re: [GENERAL] Slow cross-machine read on one table

2009-02-10 Thread Craig Ringer
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