PREPARE statements - Mailing list pgsql-novice

From Andrei Reinus
Subject PREPARE statements
Date
Msg-id 42522333.4040804@uptime.ee
Whole thread Raw
Responses Re: PREPARE statements
List 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


Attachment

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Major problem with custom data type
Next
From: Kim Kohen
Date:
Subject: Problems with initdb