Re:Ask HN: Have you ever used PL/pgSQL – the PostgreSQL prog...
by combatentropy on Monday September 03, 2018 @02:07AM
(#17900686)
> performance
Performance is usually better in the database, because the data is local. However, like any language, there is more than one way to say it in SQL. When the query is complicated, with joins and subselects and aggregates, I have made it literally a thousand times faster by rearranging and rewriting things. I'm not even talking about adding indexes yet.
> scalability
I think 99% of applications could scale just fine with Postgres.
What is your observation on the performance of such a system, when compared to systems where the middle language has all the logic and the database is used just as a dumb datastore?
Also, what are your observations on the scalability of such a system you have mentioned above?