libpq performance - Mailing list pgsql-general

Hi,

 

I have a sql that only takes 0.3 ms to run when using psql with "explain analyze".

 

However, when I execute it using PQexec, it takes 12ms for PGexec.  Does anyone know why it is that slow?

 

My db server is in the internal network, so there should not be any latency issue.

 

Any suggestion will be greatly appreciated.

 

Thanks,

JB