Postgres extensions are extremely powerful, and there’s an abundance of them out there. But if you’re looking to create one either for the broader community or your narrow use case there’s less tools to get started, here’s a great guide to getting started writing your own.
If you want to build a large scale website, you’ll need to cleverly manage the database side. A key to scalability with Postgres is locking, and Postgres now has some cool new features to reduce locking and speed things up via improved concurrency.
Your time is valuable, but a highly tuned and optimized DBMS is even more important. Learn practical, safe, and highly efficient ways to optimize the performance of a PostgreSQL Server with an on-demand training course.