Re: libpq performance

From: Chris <dmagick(at)gmail(dot)com>
To: Juan Backson <juanbackson(at)gmail(dot)com>
Cc: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>, pgsql-general(at)postgresql(dot)org
Subject: Re: libpq performance
Date: 2009-09-04 05:44:23
Message-ID: 4AA0A937.20505@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Juan Backson wrote:
> Hi,
>
> For this problem, what if I use prepared statement? if I use prepared
> statement directly from libpq, would it help?

It will possibly change the way postgres plans the query, so you may get
a different execution time.

http://www.postgresql.org/docs/current/static/sql-prepare.html

See the "Notes" section.

--
Postgresql & php tutorials
http://www.designmagick.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message gabriel munteanu 2009-09-04 05:46:21 custom datatype - rgb color
Previous Message Juan Backson 2009-09-04 05:38:20 Re: libpq performance