Re: PREPARE and stuff

From: PFC <lists(at)peufeu(dot)com>
To: "Andreas Kostyrka" <andreas(at)kostyrka(dot)org>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: PREPARE and stuff
Date: 2007-06-23 22:27:32
Message-ID: op.tuebb6krcigqcu@apollo13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> Well, that's not completely trivial => the plan might depend upon the
> concrete value of $1,$2 and $3.

When you use PREPARE, it doesn't. I could live with that.
The purpose of this would be to have a library of "persistent prepared
statements" (just like lightweight functions) for your application, and
maximize the performance of persistent connections.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mikko Partio 2007-06-25 07:50:48 Re: Slow indexscan
Previous Message Gregory Stark 2007-06-23 22:02:25 Re: PREPARE and stuff