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 243 — February 14, 2018
PostgreSQL 10.2, 9.6.7, 9.5.11, 9.4.16, and 9.3.21 Released
Releases that fix two security issues regarding partition keys and temporary files, plus fixes for VACUUM, GIN indexes, and hash indexes that could lead to data corruption.
PostgreSQL.​org   #news 
Postgres Log Monitoring Basics
Postgres log files are a treasure trove of useful data to analyze to help you make your install faster.
Lukas Fittl
PostgresConf US 2018: Growing the Open Source and Postgres Ecosystem
PostgresConf US 2018 aims to provide resources for the rapidly growing Open Source and Postgres worlds through training, breakout sessions, workshops, and social events, April 16-20 at the Westin Jersey City Newport. Register today.
PostgresConf.​org    #sponsored 
Introduction to PostgreSQL Automatic Failover
PAF is a ‘resource agent’ that allows Pacemaker, a high availability resource manager, to interact with Postgres.
Stefan Fercot
An Advanced SQL Window Function Quiz
“A lot has changed since SQL-92,” they say, so why not test out your knowledge.
Andy Boot   #tools 
Securing Postgres with Let's Encrypt
Bringing together the Let’s Encrypt SSL certificate service with Postgres running inside Docker with Caddy handling the HTTP request from Let’s Encrypt.
Stephan Brauer
Checking Postgres Availability with Pure Ruby
Play with the PG wire protocol at the lowest level, as well as do something useful with it.
Michał Młoźniak
PostgreSQL 10 Associate Certification Now Available. Test Your Skills
EnterpriseDB Training & Certification    #sponsored 
Easy Postgres Performance Stats with pgHero and Docker
“pgHero makes a great quick-check tool for PostgreSQL, offering results in easily consumable form”
Dj Walker-Morgan
Postgres's LATERAL Join Type
A walk through a conversion funnel analysis that wasn’t possible using pure SQL in Postgres prior to version 9.3.
Dan Robinson
Calculating Tupper’s Self-Referential Formula with SQL
Geeky but very cool, with a workaround for Postgres’s lack of precision in calculations involving very large numbers.
JooQ
PostgreSQL at 20TB and Beyond
Slide that present a high level look at how one company handles analytics at a large scale on Postgres.
Chris Travers
We Manage Your Data So You Can Manage Your Business: CMD 24/7 Support
Command Prompt, Inc.​    #sponsored 
pg_query: Use Postgres's SQL Parser from Ruby
Lukas Fittl   #code 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.