Postgres Weekly
Archives| Latest| RSS
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.
« Prev
Next »
Postgres Weekly
Issue 173 — September 7, 2016
PostgreSQL 9.6 RC 1 Released
The first release candidate of Postgres 9.6 is here, which means we’re not far away from the full release. Help the community out by giving it a test today.
postgresql.​org   #news 
When To Avoid JSONB in a PostgreSQL Schema
Postgres’ JSONB support can be powerful and flexible, but it’s not a once size fits all. This deeper dive looks at various implications of using it including indexing, performance, and storage.
Dan Robinson   #tutorial 
PostgreSQL 9.1 Reaching Its End of Life
If you’re still using 9.1 in production, it’s time to consider an upgrade. After November, there will be no more updates.
Simon Riggs
A lightning-fast server for a powerful database.
Join the masses of users already optimizing their PostgreSQL queries on the quick, easy to use, and powerful Linode SSD servers. Get started with $20 of credit with the code 'POSTGRES20'.
Linode    #sponsored 
Fun With SQL Constraints
Constraints aren’t always specified using the CONSTRAINT keyword as highlighted in this lightweight post showing how unique indexes can do the same thing.
Kamil   #tutorial 
Creating Pivot Tables in PostgreSQL Using Crosstab
Pivot tables are extremely common in Excel, but you can also do them directly in the database. Here’s a look at a Postgres extension that makes them simple to do right in Postgres.
Compose Articles   #tutorial 
pg_pathman 1.0(.1) Released: A Partitioning Tool for Postgres
The pg_pathman module provides optimized partitioning mechanism and functions to manage partitions.
Postgres Professional   #code 
pg_cron: Run Periodic Jobs in PostgreSQL
If you need to regularly schedule jobs directly in your database this extension can make it easier.
Citus Data   #code 
A Podcast Segment on libpq and the pg Ruby Gem
An interesting excerpt from this week’s ‘The Bike Shed’ podcast drills into some of how the libpq driver works and its integration with the pg Ruby gem.
The Bike Shed Podcast
Stop wasting time - know what you'll earn before the interview
On Hired, sign up in 10 minutes and get offers from top companies like GitHub, Uber, & Stripe. Engineers get an average of 5 offers on the platform in 1 week
Hired.​com    #sponsored 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.