When it's critical, you can count on us! A Platinum service plan with 2ndQuadrant is all the insurance you need for when things don't go according to plan. Giving you a quick database recovery, with as little downtime as possible.
In a large distributed system, using COUNT(*) can prove tricky but probabilistic algorithms could help you more quickly get ‘close enough’. This post looks at HyperLoglog and how you can use it in a distributed fashion.
JSONB is awesome in Postgres, it’s a document store in a relational database that you can index. In Postgres 10 it gets full text search. This deck from PGConf NY highlights what there is today and what’s to come.