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 d

[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 have