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 99 — April 1, 2015
Governor: A Toolkit to Orchestrate High Availablity Postgres
Since there’s not a ton of out of the box easy to use solutions for HA Postgres, Compose has released a template for you to create your own custom fit high availability solution using etcd and Python.
Compose   #tools 
Dirty PostgreSQL Database? Clean it up with a VACUUM
When you delete a row in Postgres, it doesn’t actually delete, well it does eventually. When you delete a row it marks it as logically deleted, here’s how you can ensure it’s gone as well as a read on how it works with MVCC under the covers.
Vertabelo   #tutorial 
Browser-based query tool and PostgreSQL client
Discover a collaborative and entirely browser-based environment for your team's queries and data-driven insights. JackDB adds a security layer to your organization's entire data infrastructure. Try it for free.
JackDB    #sponsored 
JSONB Type Performance in PostgreSQL 9.4
JSONB arrived in Postgres 9.4 to a lot of excitement, but how does it really measure up? Here’s a look a performance, and how to really take advantage of it with the new operators which can utilize GIN indexes.
2ndQuadrant
Postgres 9.5 Feature Highlight: Scale-out with Foreign Tables Now Part of Inheritance Trees
Foreign tables now present an even cleaner solution for partitioning your data with inheritance. While you’ll have to wait a little until 9.5 is available, this feature clearer can make the scale out process in Postgres a bit more comfortable for all.
Michael Paquier
PostgreSQL Data Sync 15.3 Released
PostgreSQL.​org   #news 
Sorting by Popularity (Reddit-style) with Ruby, PostgreSQL and Elasticsearch
First part of a series showing how we can sort items by popularity in a Ruby application following the Reddit style, using PostgreSQL and Elasticsearch.
Flavio Granero
Vector Tiles
Following on from a debate about the naming of Mapbox Vector Tiles, this post instead digs right into where they’re valuable and gets hands on with them. A great overview.
Javi Santana
An Awesome Way To Migrate to PostgreSQL from MySQL
Deven Phillips
cstore_fdw 1.2: Fast columnar store for analytics with PostgreSQL.
CStore - The fast and open source columnar store for analytics with PostgreSQL just received a new release which features some nice improvements. If you haven’t played with it yet, this is a good excuse.
Citus Data   #code 
Why Not Postgres? #1: Multi-Consumer FIFO Push Queue
Any article that starts off “PostgreSQL is so much more than a simple relational data store” makes me happy. A look at how Postgres is not only a great relational database, but can also work as a very solid queue for your application.
DistDepot
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.