replanning prepared Statements

Janning <ml@planwerk6.de> wrote:

Hi,

I am using prepared statements in Postgresql 8.4.

Does Postgresql

a) plans statements only once when PREPARE is called?

b) replans statements from time to time

c) replans when underlying statistics change on behalf of ANALYZE command?

AFAIK a), see
http://www.postgresql.org/docs/8.4/interactive/sql-prepare.html ,
chapter "Notes".

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082�, E 13.56889�