Обсуждение: release prepared statement

Поиск
Список
Период
Сортировка

release prepared statement

От
Tommi Mäkitalo
Дата:
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

От
Joe Conway
Дата:
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