Re: Index on immutable function call

From: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>
To: A(dot) Kretschmer <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Index on immutable function call
Date: 2010-01-19 09:22:30
Message-ID: B989CFBF-7989-40F1-8E95-ECE0D727A7A0@solfertje.student.utwente.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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.

Alban Hertroys

--
Screwing up is the best way to attach something to the ceiling.

!DSPAM:737,4b5579d610602488920658!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tore Halvorsen 2010-01-19 09:37:30 Re: Index on immutable function call
Previous Message Alban Hertroys 2010-01-19 09:21:35 Re: Index on immutable function call