Re: Slow planning time for custom function

2018-03-25 Thread bk
Hi, thanks for your help which already resolved the issue for me. I worked through your replies and it is indeed a startup delay for the first call to a plv8 function in a session. I pasted the query plans below for comparison. ``` explain analyze select normalizeunidiff('')

Slow planning time for custom function

2018-03-23 Thread bk
Hi, 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.