libpq performance

From: Juan Backson <juanbackson(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: libpq performance
Date: 2009-08-23 16:08:51
Message-ID: 27c25bc40908230908t159341ebs647cbbb8129bd54a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Ross 2009-08-23 16:37:00 Re: Multiple table entries?
Previous Message Tom Lane 2009-08-23 16:08:29 Re: Strange "missing tables" problem