| 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.
|
| 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
|
| 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 |
|
|
|
|