Search Postgresql Archives

Re: Memory usage per session

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux