Re: Looking for tips

From: Vivek Khera <vivek(at)khera(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Looking for tips
Date: 2005-07-26 15:22:31
Message-ID: AAEE6A63-1412-426E-AB0F-9573E9CB90AF@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On Jul 19, 2005, at 3:01 PM, Tom Lane wrote:

> You could possibly get some improvement if you can re-use prepared
> plans
> for the queries; but this will require some fooling with the client
> code
> (I'm not sure if DBD::Pg even has support for it at all).
>

DBD::Pg 1.40+ by default uses server-side prepared statements when
you do $dbh->prepare() against an 8.x database server.

Vivek Khera, Ph.D.
+1-301-869-4449 x806

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message John A Meinel 2005-07-26 16:34:37 Cheap RAM disk?
Previous Message Jeff Trout 2005-07-26 14:22:57 Re: COPY insert performance