Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group