Postgres has had a number of releases that focus on underlying performance or where there’s just one landmark improvement. Postgres 9.5 was as end user focused as many, and here’s the rundown of its benefits.
Support for parallel queries has been at the top of our request list to the core team for a long time. Now that it is finally arriving in 9.6 the question is: does it really help?
Postgres Vision focuses on current and future enterprise usage of Postgres. This event includes insights from technology and business luminaries, use cases, a look at the Postgres ecosystem, and long-range outlooks from analysts. Visit PostgresVision.com.
For many, what happens when you join two tables is a mystery. Once you do build a deeper understanding, it becomes much easier to optimize joins - luckily it’s not rocket science to understand some of the logic under the covers, as seen here.
A big change under the covers which won’t manifest to users, except in accelerated addition of new features. Extensible access methods continues the theme of Postgres as more of a platform than simply a RDMBS.
We often feature articles about people moving from other systems to Postgres - in contrast, here’s how to apply a Postgres perspective to a database that doesn’t lend quite the same flexibility: Cassandra.
