Re: bind variables, soft vs hard parse

From: Douglas McNaught <doug(at)mcnaught(dot)org>
To: Marcus Engene <mengpg(at)engene(dot)se>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: bind variables, soft vs hard parse
Date: 2005-11-16 02:13:09
Message-ID: m2mzk5nxvu.fsf@Douglas-McNaughts-Powerbook.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Marcus Engene <mengpg(at)engene(dot)se> writes:

> Which will be the same as the second call. There is quite a big
> difference in performance using bind variables.
>
> Does Postgres work the same? Where can I go for more info?

You can do this (or close to it) but you need to explicitly PREPARE
the query (or use the protocol-level prepare, which some client
libraries will do for you). See the SQL documentation for PREPARE.

-Doug

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Yann Michel 2005-11-16 03:09:20 Re: PG_DUMP and table locking in PG7.4
Previous Message Christopher Kings-Lynne 2005-11-16 01:59:44 Re: PG_DUMP and table locking in PG7.4