On 31/05/2010 10:34 PM, Alonso García , Bruno Elier wrote:
> If I perform the query using pgadmin I get the same result in both versions 7.4 and version 8.3.
Just re-read your post and realized you were probably saying that you get (effectively) the same EXPLAIN ANALYZE results from both, ie this isn't your problem.
In fact I have written two test applications that perform the same query, one using the synchronous command processing (PQexec) an one using the asynchronous Command Processing (PQsendQuery / PQconsumeInput / PQisBusy / PQgetResult) and the results are: -> synchronous command processing takes less than two seconds to retrieve the result.
So PQexec works fine for you on both 7.4 and 8.3, producing a quick result no matter which server you run it against?
-> asynchronous command processing takes more than 120 seconds to retrieve the result.
You mean that this is where you have your problem, and it's fine on both versions when you use plain PQexec?
Consider using wireshark to examine the network traffic, and see if there's much activity during your long and slow PQconsumeInput / PQisBusy loop. The throughput analysis tool is handy for this.
-- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
