Jim C. Nasby wrote:
My college professor said it, it must be true! ;P
The famous joke ;)
My understanding is that in plpgsql, 'bare' queries get prepared and act
like prepared statements. IE:
SELECT INTO variable
field
FROM table
WHERE condition = true
;
Unfortunately I don't know enough about PostgreSQL, but from responses
I've been reading I've
come to that conclusion.
Ok, so post some numbers then. It might be interesting to look at the
cost of preparing a statement, although AFAIK that does not store the
query plan anywhere.
In most databases, query planning seems to be a pretty expensive
operation. My experience is that that isn't the case with PostgreSQL.
I didn't think about storing query plan anywhere on the disk, rather
keep them in memory pool.
It would be great if we had an option to use prepare statement for
stored procedure so it
would prepare it self the first time it's called and remained prepared
until server shutdown or
memory pool overflow.
This would solve problems with prepare which is per session, so for
prepared function to be
optimal one must use same connection.
