Hi, On 2018-03-23 21:28:22 +0100, bk@xxxxxx 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
