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 205 — May 3, 2017
Why Use Postgres
An anniversary follow-up to a 2012 post on 'why to use Postgres' but now looking at features from the last five years. It provoked extensive discussion on Hacker News.
Craig Kerstiens
Logical Replication in Postgres 10
Logical replication has been one of the more welcomed advancements to Postgres in recent years. Postgres 10 will feature a number of updates to it. Get a primer of what it is, and why you would use it.
Petr Jelinek
The In-Progress Draft of Postgres 10's Release Notes
Postgres 10 isn’t quite here yet, but it’s starting to take a pretty close-to-final form. Take an early look at the (still in progress) release notes.
postgresql.​org
Postgres-BDR: Multi Master Replication Solution for PostgreSQL
Postgres-BDR is a multi-master replication system for geographically distributed clusters using highly efficient, asynchronous logical replication. It supports anything from 2 to more than 48 nodes in a distributed database.
2ndQuadrant PostgreSQL Products    #sponsored 
Deep Dive Into Postgres Stats: pg_stat_user_indexes
Continuing a great series on Postgres stats, this takes a quick look at an index related stats table, and links to some handy queries for things such as finding unused indexes.
Alexey Lesovsky
Postgres Tips for Rails Developers
A recap of the best Rails-related PostgreSQL tips that Citus shared at RailsConf.
Citus Data
Creating a Postgres Container with Default User and Password
Use Docker for the rest of your local dev and want to set up Postgres the same way? Here’s a quick tutorial on getting things running.
Beld
What You Need To Know About SQL's 'GROUP BY'
GROUP BY is used so often in SQL that it pays to understand it well.
Periscope
The Big Old Reliable Elephant: Talking About Postgres with Craig Kerstiens
An interview with Craig Kerstiens on the benefits of Postgres over other SQL databases.
Federico Carrone
ZomboDB: Integrating Postgres and Elasticsearch
ZomboDB is an extension to Postgres that allows you to directly use Elasticsearch indexes from within Postgres. It’s got a new website and look and is worth taking a look at if you use both.
ZomboDB   #tools 
Linux cloud hosting starting at 1GB of RAM for $5/mo.
Get a Linode server up and running in seconds. Use promo code POSTGRES20 for a $20 credit on a new account.
linode    #sponsored 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.