Hi,
On 2018-03-23 21:28:22 +0100, bk(at)e8s(dot)de wrote:
> I have a table api.issues that has a text column "body" with long texts (1000+ chars). I also wrote a custom function "normalizeBody" with plv8 that is a simple Text -> Text conversion. Now I created an index applying the function to the body column, so I can quickly run
>
> SELECT * FROM api.issues WHERE normalizeBody(body) = normalizeBody($1)
>
> The issue is, that the planning time is very slow (1.8 seconds). When I replace "normalizeBody" with "md5", however, I get a planning time of 0.5ms.
How long does planning take if you repeat this? I wonder if a good chunk
of those 1.8s is initial loading of plv8.
Greetings,
Andres Freund