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 133 — November 25, 2015
The Unofficial Guide to JSONB Operators in Postgres, Part 1
JSONB, or binary JSON, is the best improvement to come to Postgres in several years. Just as valuable are all the operators that come with it, here’s a rundown of them.
Balaji Rao
Introduction to pg_stat_activity to Monitor DB Processes in Real Time
pg_stat_activity provides a SQL-accessible view of Postgres’ various processes and user activity.
Ilya Kosmodemiansky
PostgreSQL, The PCI Compliant Database [PDF]
Slides from a PGConf Silicon Valley talk looking at how Postgres can be made PCI compliant (so that payment card processors won’t hate or block you).
Christophe Pettus
Instant, deep Postgres monitoring
Datadog natively collects hundreds of Postgres metrics: system resources, connections, locks, transactions, indexes, and more. Pre-built, fully customizable visualizations, alerts, and full-stack performance correlation. 14 day unlimited trial.
Datadog    #sponsored 
HyperLogLog in Pure SQL
Hyperloglog is a very interesting algorithm and you can have an extremely efficient version directly in Postgres. And if you’re not up for building and pulling in your own extensions here’s a raw SQL implementation of it.
Periscope
pg_paxos: High Availability Data Replication for PostgreSQL
The pg_paxos extension demonstrates how the Paxos algorithm can be used for fault-tolerant, consistent table replication in Postgres.
Citus Data
Organize Complex Queries Using SQL's 'WITH'
Common table expressions or more commonly known as WITH clauses are very useful in Postgres. Not only can you do recursive queries, they also make simpler queries more readable.
Markus Winand
RDS PostgreSQL Supports Point-and-Click Upgrade From 9.3 to 9.4
Amazon   #news 
Autovacuum, Explained for Engineers
Vacuum and Autovacuum have gotten much better over the years in Postgres, but their behavior can be misunderstood. Here’s an up to date slidedeck that walks you through the ins and outs.
Ilya Kosmodemiansky
Get Multiple Job Offers in One Week
Companies are looking to hire someone with your skillset. Stop applying and let companies come to you with offers, which include salary and other benefit information upfront.
Hired.​com    #job 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.