3 ms·
> pgSQL is still not quite there when compared to PL/SQL. Yes, but maybe it's a good thing after all. pgSQL is small, and mostly clear and restrictive, there's
by snaky 9y ago
> pgSQL is still not quite there when compared to PL/SQL.
Yes, but maybe it's a good thing after all. pgSQL is small, and mostly clear and restrictive, there's no bunch of imperative features and dark corners. The main point of PostgreSQL always was extendability, so it supports a broad list of programming languages for stored procedures.
To address efficiency concerns, executor's JIT is on the way - https://postgrespro.com/roadmap/56509 https://postgrespro.com/roadmap/56509