On 7/8/2016 12:00 PM, Karl Czajkowski wrote:
3. Rewrite or refactor such complex stored procedures in a different
programming language such as C or Python, so your PL/pgsql stored
procedures remain small glue around libraries of code. Postgres
makes it very trivial to extend the system with such procedural
libraries.
4. move said business logic to app servers to unload the database
server from doing so much compute, and get better all around
performance. use plpgsql functions for inner functions only where
there are significant performance gains. its easy to cluster app
servers, its not so easy to parallelize database servers.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
