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 198 — March 15, 2017
Google Cloud SQL for PostgreSQL
Now in beta, Google Cloud SQL has added support for PostgreSQL. Make sure to give it a try.
Google Cloud Platform   #news 
Parallel Query v2: What Is (and Might Be) Coming in Postgres 10
Postgres 10 is starting to come together and there are a lot of exciting changes. At the top of the list there’s a number of Parallelism improvements, some already committed and some hopefully still to be committed.
Robert Haas
How to Scale PostgreSQL on AWS
Citus extends Postgres to easily shard your data. They launched a managed service on top of AWS a year ago and here’s a number of the learnings from running a database as a service.
Citus Data
[Case Study] Sales Loft
Read this case study to hear how a sales development software company was able to decrease its use of temporary tables by 90%
VividCortex    #sponsored 
Acra: An Open Source Postgres Protection Suite
Tools to secure PG databases in distributed environments. Selectively encrypt records and detect potential intrusions and SQL injections. Mongo & MySQL support promised soon. More here.
Cossack Labs   #tools 
How to Deploy a HA Postgres Cluster on Kubernetes
Sergey Nuzhdin
A Multi-Tenant Sharding Tutorial
Citus Data
Getting Started with JSONB in Postgres
Some basics to using Postgres’s powerful binary JSON datatype.
Craig Kerstiens
Simple and Manual Sharding on Postgres
Combining foreign table inheritance with the postgres_fdw extension.
Emanuel Calvo
Metrics Maven: Exponentially Weighted Moving Average in PostgreSQL
In this episode of our MM series we'll show you how to calculate an exponentially weighted moving average.
Compose    #sponsored 
Modifying Files Outside of PG While Maintaining Transaction Safety
“What to do when things get too big to be stored inline in the database but we still want all that juicy transaction safety and read-write locks without building your own gatekeeping solution?”
Matthaus Woolard
Wait Event Reporting in 9.6
The wait_event_type and wait_event columns on the pg_stat_activity view make it possible to find what’s causing query delays.
Bruce Momjian
Queues in Postgres [PDF]
Thomas Munro
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.