[GENERAL] Prepared statement's plan

2008-01-16 Thread Vyacheslav Kalinin
Hello, I would appreciate if someone explained me how exactly prepared parametrized statements are planned, i.e. what kind of assumptions planner makes on param values, selectivity, expected row count etc. that affect in particular whether indexes will be used or not. For instance consider the

Re: [GENERAL] Prepared statement's plan

2008-01-16 Thread Chris
Vyacheslav Kalinin wrote: Hello, I would appreciate if someone explained me how exactly prepared parametrized statements are planned http://www.postgresql.org/docs/8.2/static/sql-prepare.html Under the Notes it explains it can't use an index and has to basically guess what it's going to do