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 199 — March 22, 2017
First Impressions of Google Cloud SQL for PostgreSQL
One of the most exciting announcements of Google Next was Postgres support for Cloud SQL. Now that it’s available here’s a rundown of how it measures up.
Payal Singh   #opinion 
Timescale: A Postgres-Compatible Open Source Time-Series Database
SQL made scalable for time-series data. It’s Postgres compatible and optimized for fast ingest and complex queries.
Timescale   #tools 
Postgres-BDR: Multi Master Replication Solution for PostgreSQL
Postgres-BDR is a multi-master replication system for geographically distributed clusters using highly efficient, asynchronous logical replication. It supports anything from 2 to more than 48 nodes in a distributed database.
2ndQuadrant PostgreSQL Products    #sponsored 
Find Your Way with The Power of PostGIS and PgRouting
PostGIS is one of the most powerful GIS databases around. PgRouting is the part that helps you find paths and routes from one area to the other, and here’s how you can use it.
Patryk Pastewski   #tutorial 
Unit Testing in Postgres with PLV8
Equinox is a testing framework built on top of PLV8 & Node.js where all tests are written in JS.
Jerry Sievert   #tutorial 
Troubleshooting Streaming Replication [Slides]
A slidedeck from the recent PGConf RU conference in Moscow looking at troubleshooting streaming replication, and how you can quickly find/eliminate replication problems.
Alexey Lesovsky
The Proliferation of NUMERIC
NUMERIC is often used as a primary key type in Postgres due to automated migrations from Oracle. While mapping Oracle’s NUMBER to NUMERIC is easy, it can result in poor performance.
Jim Mlodgenski   #opinion 
postgres_fdw Estimated Overhead
A perf analysis of FDW (Foreign Data Wrapper) overhead on intensive transaction workloads.
Emanuel Calvo   #opinion 
Are Hash Indexes Faster Than Btree Indexes?
Postgres supports a variety of index types. Here’s a look at the performance differences between hash and Btree (though be careful using them before Postgres 10 gets here).
Amit Kapila   #opinion 
Get Instant REST APIs for Postgres
DreamFactory turns your Postgres database into a comprehensive REST API. Free and open source, try it now.
DreamFactory    #sponsored 
Postgres Joins and Django Querysets
ORMs don’t always generate the most performant queries. This article looks at an example from Django and how it can be optimized.
Lucas Roesler
Creating Tables 'dum' and 'dee' in Postgres
For the more theoretical amongst you.
JOOQ   #tutorial 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.