=?UTF-8?B?6auY5YGl?= writes:
>>> So I think that the above example can not show that "parameterized path"
>>> has been created.
>> But if you try the PREPAREd sets in versions before 9.2, you will find
>> they use the same plan as each other. Allowing them to differ based on the
>> parameter th
Thank you Jeff
I tried on PostgreSQL 9.1.0, and found the running result is:
postgres=# explain execute s(*2*);
QUERY PLAN
-
Bitmap Heap Scan on tst01 t (cost=*626.59*.
On Tue, Jun 18, 2013 at 2:09 AM, 高健 wrote:
> postgres=# explain execute s(2);
>
>QUERY PLAN
>
> -
>
> Index Only Scan using idx_tst01_id on tst01 t (cost=0.00..8.38 rows=1
> w
Hello:
I have some questions about parameterized path.
I have heard that it is a new feature in PG9.2.
I digged for information of parameterized path, but found few(maybe my
method is not right).
My FIRST question is:
What is "parameterized path " for?
Is the following a correct example