performance
Middleware
Middleware is a piece of code that mediates the request and response to the application server.
performance
postgresql
Ouch! Killing PG Performance with Row-Level Security
Postgres 11 and higher has a feature called Row Security Policies, or Row-Level Security, which is a great feature for restricting access to rows in a tabel on a per-user basis. However, if you’re not careful, you can drag down performance with a bad policy. The post below comes
postgresql
One WEIRD Trick for Speeding Up ORDER BY That You Probably Shouldn't Use
I was digging into a performance issue at work recently and found THE WEIRDEST way of speeding up a query that uses ORDER BY. When testing against our replica database, I was getting results up to 100 times faster than before.