Postgres Weekly Issue 68
August 13, 2014
As always, thanks to Craig Kerstiens for continuing to curate Postgres Weekly for us :-) Be sure to hit him up on Twitter with any appreciation or ideas.
The New Heroku Postgres Database Experience
Heroku unveiled a pretty big change to it’s Postgres as a Service offering, which is the largest provider of Postgres in the world. The updates include updates to performance, security, and monitoring providing hopefully something for everyone at least if you’re running on Heroku.
Call for Quotes for The 9.4 Release Announcement
Are you an end user of Postgres? Want to help support the community in what you’re excited about for the upcoming release? We’re looking for quotes to help support the imminent 9.4 release. You have until Friday so reach out soon.
Josh Berkus
The Two Kinds of Stats in PostgreSQL
Postgres keeps a lot of data about your database in addition to just being reliable for the records you request to store. This other metadata often is in the form of stats which serve two purposes, take a look under the hood at the types of stats and how they’re used in Postgres.
PostgreSQL Addict
PostgreSQL Page Size for SSD
Running Postgres on SSDs? Here’s a look at write performance on SSDs and the role of the PostgreSQL page size (which is 8KB by default).
Fabien Coelho
JSONB and Horizontal Scaling Strategies
Postgres has a reasonable reputation for handling web scale, and it’s continued to become more flexible with hstore, JSON, and now JSONB. Here’s a great set of slides digging into all of that from the NYC Postgres meetup.
Jonathan S Katz
Math and SQL, part 2: Functions and First Normal Form
If you missed a database class which covered normalization and first normal form, get your crash course in it here. This post continues in a three part series on much of the roots of SQL/relational databases.
Chris Travers
Introducing pg:diagnose
One of the visibility improvements for Heroku Postgres is a tool called pg:diagnose. Think of it as your DBA in a box highlighting problematic areas as well as levels of warnings. Of course it’s baked right in if you’re on Heroku, but if not the server side piece of it is open-sourced thanks to @leinweber and Heroku
CitusDB: cstore_fdw 1.1 release notes
The first ever open source columnar store for Postgres has it’s first set of major updates. Most of these changes include some smoothing of edges making it a more tenable option to run yourself, dig in further to the details in their release notes.
Citus Data
Math and SQL part 3: MVCC, Immutability, and Functional Programming
And we finally arrive at the end of the three part series, getting into multi-version concurrency control, which is of course deep at the root of so much of how Postgres operates.
Chris Travers