Re: Prepared statement already exists

From: WireSpot <wirespot(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Prepared statement already exists
Date: 2008-11-20 11:56:50
Message-ID: b2d4b0380811200356gdd5553fr5cb6e0555ea2d86b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Nov 20, 2008 at 10:56, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> wrote:
> Do you still need the old prepared statement?
>
> If not, you can simple DEALLOCATE it and then try the PREPARE again.

Yes, I'd like to keep the old statements, that's part of the perks --
if a query will be repeated it will (possibly) benefit from the
statement being already prepared.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2008-11-20 12:16:17 Re: transaction_read_only effects on performance, actual meaning (was: How to reduce impact of a query)
Previous Message WireSpot 2008-11-20 11:53:58 join with redundant results VS simpler join plus multiple selects