pgsql-general-owner@xxxxxxxxxxxxxx wrote: > On Tue, Jan 19, 2010 at 10:22 AM, Alban Hertroys > <dalroi@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote: >> >> On 19 Jan 2010, at 8:26, A. Kretschmer wrote: >>> The planner doesn't know the actual parameter for the function, so >>> he picked out the wrong plan. You can force the planner to >>> re-planning with a dynamical statement within the function and >>> EXECUTE that. >> >> >> There are no queries in his function, I think you misread his post. > > Perhaps this might work? > > create index transform_index on indexed_table(serial) where data1 > > this_is_a_long_transformation(data2); Hi, It does! With your index alone: --------------------------- Bitmap Heap Scan on indexed_table (cost=815.17..10106.08 rows=33333 width=12) (actual time=7.796..236.722 rows=50116 loops=1) Recheck Cond: (data1 > this_is_a_long_transformation(data2)) -> Bitmap Index Scan on transform_index (cost=0.00..806.84 rows=33333 width=0) (actual time=7.665..7.665 rows=50116 loops=1) Total runtime: 459.380 ms --------------------------- That works just fine, but is there maybe a way of creating a slighly more "generic" index? If I change the ">" with a "<" in the query, index cannot of course be used. According to documentation, answer seems to be "no"... Thanks, and best regards. ----------------------------------------------------------------------- Philippe Lang Web : www.attiksystem.ch Attik System Email : philippe.lang@xxxxxxxxxxxxxx rte de la Fonderie 2 Phone : +41 26 422 13 75 1700 Fribourg Mobile : +41 79 351 49 94 Switzerland Fax : +41 26 422 13 76 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
