Immutable function with bind value

From: Brice Maron <bmaron(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Immutable function with bind value
Date: 2012-01-20 11:15:16
Message-ID: CAHBQ7mcLrFmQ8tKHOrw-W-_xhiTVjnD3sqQwK+XbDXsYV28vvA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

i've discovered something kind of weird while developing my app...
I was trying to fetch some records in a table using a function immutable.
In my interface it was really slow and while i was in a psql it was
really fast ...

After some research i've found out that it was caused by the bind
parameter "forcing" the immutable function to execute each time my
query gets a record.

while i know that the value can't be known at planning time the
difference between the binded / not binded is quite enormous...

i've isolated a test case here....

https://gist.github.com/e93792540cb3a68054c9

(it happens at least in pg 8.4 and 9.1.2)

What do you think about it... bug? feature? how can i avoid it?

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Florian Weimer 2012-01-20 11:41:34 Re: On duplicate ignore
Previous Message Lincoln Yeoh 2012-01-20 11:12:34 Re: On duplicate ignore