A new security update from Postgres, this time addressing a DoS vulnerability based around JSON and JSONB values. Available for 9.4.5, 9.3.10, 9.2.14, 9.1.19 and 9.023, you should upgrade now, and especially if using JSON/JSONB.
Not the most exciting topic, but the IDs on your tables have a critical role to play and it's important to get it right. Just ask Instagram or other applications that run out of index IDs because they’re using integers. Fortunately it’s easily solved.
CitusDB delivers real-time insights into your Big Data while reducing the cost and complexity of your database infrastructure and leverages your existing knowledge and applications. Supports structured or unstructured data and horizontally scales.
Replication and standbys with Postgres can have lots of implications for how your database works. One example is it will automatically cancel queries that run for a certain amount of time so that replication continues. Get the deeper run down of how it works and what it all means.
Postgres is continuing to improve its usability and smooth out rough edges. One of the latest commits for 9.6 will allow dependencies on different extensions to be able to cascade rather than simply error if you now specify a flag.
Here’s a great new database series, which highlights SQL but specifically Postgres as well. Start with setting up your Postgres instance and then advance on to other parts in the series such as how to start inserting data