Re: [GENERAL] I want to make an example of using parameterized path

2013-06-23 Thread Tom Lane
=?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

Re: [GENERAL] I want to make an example of using parameterized path

2013-06-18 Thread 高健
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*.

Re: [GENERAL] I want to make an example of using parameterized path

2013-06-18 Thread Jeff Janes
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

[GENERAL] I want to make an example of using parameterized path

2013-06-18 Thread 高健
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