No-one seems to have yet mentioned Facebook’s TAO paper, which describes scaling basically this approach to 1 billion reads per second. https://cs.uwaterloo.ca/~brecht/courses/854-Emerging-2014/re…
Postgres and Connection Pooling
A rule of thumb I’d use is if you have over 100 connections you want to look at something more robust
.. In contrast to the 5MB-ish standard connection to Postgres PG Bouncer has a 2kb per connection.
The Best Postgres Feature You’re Not Using – CTEs Aka WITH Clauses
Readability is huge when it comes to SQL to ensure its doing the right thing. SQL will almost always tell you an answer, it just may not be to the question you think you’re asking. Ensuring your queries can be reasoned about is critical to ensuring accuracy and CTEs are one great way of accomplishing that.
Postico: A Modern PostgreSQL Client for OS X
Postico will look familiar to anyone who has used a Mac before. Just connect to a database and begin working with tables and views. Start with the basics and learn about advanced features of PostgreSQL as you go along.