[GENERAL] Libpq Asynchronous Command Processing

2010-05-31 Thread Alonso García , Bruno Elier
Hello, I am migrating a client/server application from Debian Sarge to Debian 5.0 and I am finding problems with the client application. The facts are the following: -The client application is an interface to a Postgresql DB so it uses libpq. -The client application compiles properly in both

Re: [GENERAL] Libpq Asynchronous Command Processing

2010-05-31 Thread Alonso García , Bruno Elier
With that analysis, I'd be betting against it being a client problem. (If you wanted, you might confirm that by pointing an old client at the new server.) I'd look into how the data was loaded into the new server and how the database is configured: number of buffers, indexes, and whether

Re: [GENERAL] Libpq Asynchronous Command Processing

2010-05-31 Thread Alonso García , Bruno Elier
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? Yes. If I use PQexec, both 7.4 and 8.3 produce a quick result but I if I use asynchronous command processing 8.3 produce a slow result whereas 7.4 works fine. Consider using