Re: I want to make an example of using parameterized path - Mailing list pgsql-general

 postgres=# explain execute s(2);

                                   QUERY PLAN                                    

---------------------------------------------------------------------------------

 Index Only Scan using idx_tst01_id on tst01 t  (cost=0.00..8.38 rows=1 width=4)

   Index Cond: (id < 2)

(2 rows)

postgres=# explain execute s(100000);

                          QUERY PLAN                           

---------------------------------------------------------------

 Seq Scan on tst01 t  (cost=0.00..1693.00 rows=100000 width=4)

   Filter: (id < 100000)

(2 rows)

postgres=# 

 

When I just send sql of  " select * from tst01 t where id <2" , it will also produce index only scan plan.

When I just send sql of  " select * from tst01 t where id < 100000", it will also produce seq scan plan.

 

So I think that  the above example can not show that "parameterized path" has been created.