=?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