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 188 — January 4, 2017

We hope you had a good time over the holidays and we look forward to an exciting year for Postgres in 2017. We're looking at updating the design and approach of the newsletter a little soon, so if you have any suggestions or feedback, just hit reply and we'll take it all into account :-)

Controlling Autovacuum
Autovacuum performs recycling of old rows and updates optimizer statistics but can slow things down while it runs. Bruce looks at how to encourage autovacuum to run more during idle periods and less during busy moments.
Bruce Momjian
Generating YouTube-Like IDs Using PL/V8 and Hashids
An alternative to exposing numeric IDs or lengthy UUIDs. There’s also a native Postgres extension to do this called pg_hashids.
Abe Voelker
Solving a Classic Puzzle using Postgres and Advanced SQL
Love puzzles and got quite a bit of time on your hands? This is a fascinating journey.
Quassnoi
Real-time Postgres performance monitoring
Graph and correlate hits, commits, and deadlocks (and more!) with metrics and events from the rest of your infrastructure. Start monitoring in minutes.
Datadog    #sponsored 
Postgres 10 Highlight - Checkpoint Skip Logic
Michael Paquier
How to Generate A Pivoted CROSS JOIN Where The Resulting Table Definition Is Unknown
An interesting question and set of answers that looks into using Postgres’ ‘crosstab’ function as well as other approaches.
Stack Exchange
How to Protect Your Data with Constraints
Nathan Long
Why is array_agg() Slower than the Plain SQL Equivalent?
Stack Exchange
An Introduction to Stolon: Cloud Native Postgres High Availability
A manager for providing high availability Postgres using streaming replication.
Simone Gotti   #tools 
SQLBoiler: Generate a Go(lang) ORM Tailored to Your Schema
Vattle   #tools 
PgRebase: Manage Functions/Triggers/Types/Views As Plain Files
Olivier El Mekki   #tools 
pg_themis: Postgres Extension for Encryption/Decryption with Themis
Themis is a high-level cross-language general cryptography library.
Cossack Labs   #code 
DreamFactory open source REST API platform
Develop apps faster. DreamFactory automatically turns any database 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.