Thread: release prepared statement

release prepared statement

From
Tommi Mäkitalo
Date:
Hi,

is there any possibility to "unprepare" statements? I think about a long
living connection, where I use prepared statements often. I think, that every
prepare uses some resources, so it seems to be good to release the queryplan
when I know, that I won't use it any more.


Tommi Mäkitalo

Re: release prepared statement

From
Joe Conway
Date:
Tommi Mäkitalo wrote:
> Hi,
>
> is there any possibility to "unprepare" statements? I think about a long

See:
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/sql-deallocate.html

HTH,

Joe