PREPARE statements

Поиск
Список
Период
Сортировка
От Andrei Reinus
Тема PREPARE statements
Дата
Msg-id 42522333.4040804@uptime.ee
обсуждение исходный текст
Ответы Re: PREPARE statements  (Sean Davis <sdavis2@mail.nih.gov>)
Список pgsql-novice
Hi,

I have few questions about PREPARE statements.
As starting a new project, I always try to find ways to 'do-it-right' and application is
all OLTP style system.

I have lots of queries like "SELECT name FROM client WHERE id = 1". Plain and simple PK index search.
To save parsing/rewriting/planning overhead I should use PREPARE statements, right?

Manual states that prepare statements are only stored in database session,
is there are way to be sure that statement exists or make it last over all sessions?

I cant PREPARE statments over and over again with every page request, right?


-- Andrei Reinus


Вложения

В списке pgsql-novice по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Major problem with custom data type
Следующее
От: Kim Kohen
Дата:
Сообщение: Problems with initdb