Sharing page tables with msharefs

Posted Jul 16, 2022 9:58 UTC (Sat) by flussence (guest, #85566)
In reply to: Sharing page tables with msharefs by edeloget
Parent article: Sharing page tables with msharefs

I've seen articles about database designs that, instead of routing things through a frontend web API or whatever, expose Postgres users and use its security rules model directly. I imagine that'd cause some scaling headaches if done to a medium-large website...

Sharing page tables with msharefs

Posted Jul 16, 2022 18:32 UTC (Sat) by butlerm (subscriber, #13312) [Link]

If your database server can handle the load in terms of number of connections, and your application can afford to be tightly coupled to the database design, and the connection latency is typical of a local area network, it is probably almost always faster to connect directly rather than running through extra tiers that mostly shuffle things around en route. In so many cases that is not possible any more though, even old school web applications multiplex database connections across concurrent users (and often do a outstanding job of it, but that is another story).