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 192 — February 1, 2017
pgwatch2: A Simple But Versatile Postgres Monitoring Tool
There is no shortage of database monitoring tools, but that doesn’t mean new ones don’t have their place. Pgwatch doesn’t require an agent and comes with some good out of the box insights for monitoring your database.
Kaarel Moppel   #tools 
GitLab's Database Incident
A very transparent timeline and retrospective of a database incident involving Postgres, resulting in a multi-hour outage of the code hosting site.
GitLab
PostGIS 2.3.2 & 2.2.5: Spatial and Geographic Objects for Postgres
The focus is on bug fixes and patches in both cases. 2.2.5 here.
PostGIS Developers
Clever Cloud: The End of Server Management
Cloud hosting for developers by developers. Polyglot and scalable, saving thousands of souls from server management since 2010 in America and Europe.
Clever Cloud    #sponsored 
Postgres 10 Highlight: Compression Support in pg_receivexlog
On-the-fly zlib compression and .gz file storage of WAL records.
Michael Paquier   #news 
Inserting JSONB Data in Postgres 9.6
Rubens Souza   #tutorial 
What Does pg_start_backup() Do?
Simon Riggs   #tutorial 
A Potential Postgres Case-Sensitivity Tripping Point
Postgres can appear case-insensitive to table or column names in many situations, but sometimes you’ll encounter a subtlety of how it really works.
Paul Lefebvre   #tutorial 
pgBadger v9.1: A PostgreSQL Performance Analyzer
postgresql.​org   #tools 
Getting Started with GitHub Event Data on Citus
Getting an example dataset to test out a new database can be as much work as trying the database itself. This example uses GitHub data to guide through how Citus and sharding works.
Citus Data   #code 
postpy: Utilities for ETL and Data Analysis from Python
Censible   #code 
DreamFactory REST API platform for Postgres
Develop apps faster. DreamFactory automatically turns Postgres into a REST API platform in minutes.
DreamFactory    #sponsored 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.