I'm trying to find information about PostgreSQL user defined functions in procedural languages performance for real time tasks.
- How does they compare to builtin functions?
- Is there any difference (in overhead) how Postgres call / manage plpython vs plpgsql vs pllua functions (I'm interested in the Postgres integration / context / data transfer side, not the VM itself)?
- Is the context a big overhead? Can I use it for realtime data mapping (let's say 1000 queries/s))
- Is there any benefit of writing user defined functions in plpgsql then other pg/language? On the documentation they enumerate advantages, but I think they apply to all postgresql procedural languages.