Search Postgresql Archives

libpq performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-general@xxxxxxxxxxxxxx
Subject: libpq performance
From: Juan Backson <juanbackson@xxxxxxxxx>
Date: Mon, 24 Aug 2009 00:08:51 +0800

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: libpq performance
  - From: Craig Ringer

Prev by Date: Re: Multiple table entries?
Next by Date: Re: Multiple table entries?
Previous by thread: Figuring out relationships between tables.
Next by thread: Re: libpq performance
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux