News for hackers. Stuff that matters.
Re:Ask HN: Have you ever used PL/pgSQL – the PostgreSQL prog... by kumarvvr on Monday September 03, 2018 @12:43AM (#17900377)
Thanks for the detailed reply.

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?

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.