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 175 — September 21, 2016
Dynamic Pivot Tables with JSON and PostgreSQL
When doing data analysis you don’t always have to resort to Excel or Hadoop. This post shows a simple way to do Pivot tables, which is extremely common when looking to analyze data.
Andrew Bender
BedquiltDB v2: A JSON Document Store Built on Postgres
Version 2 includes new query operators for matching JSON documents, and you can now get up and running fast with a simple Docker image.
Shane Kilkelly   #news 
Improve PostgreSQL On Windows Performance by 100%
Most running Postgres know to tune shared buffers, but if you’re on Windows there’s one more setting to pay attention to. This article demonstrates using update_process_title for significant performance gains on Windows.
David Rader
Itching for a rewrite? Try a Code Inspection™ from Corgibytes first.
We know the frustration. You see all the places your app could be so much better, but you can't seem to convince your boss. Next time, mention Corgibytes. Our Code Inspection™ can help you explain technical improvements in a way executives can understand.
Corgibytes    #sponsored 
All About PostgreSQL Streaming Replication
Streaming replication is the official approach from much of the community, which streams updates over the write ahead log to another instance. This guide provides a good overview of what you need to know and how to get started.
RapidLoop
Aiven Brings Easy Hosted PostgreSQL to Microsoft Azure
Postgresql.​org   #news 
BDR Is Coming to PostgreSQL 9.6
BDR is bi-directional replication.
Craig Ringer   #news 
BRIN Indexes in Postgres 9.5
BRIN (or block range indexes) can be useful on large tables in certain cases, depending on the data and what you need. Here’s an explanation.
Sortable Engineering   #tutorial 
Interview: Uber’s Postgres Problems with Evan Klitzke
A 50 minute podcast chat about the recent story on Uber’s switch from Postgres to MySQL.
Software Engineering Daily
sQucumber-redshift: A Framework for Defining and Executing SQL Integration & Acceptance Tests on AWS Redshift
Stefanie Grunwald   #tools 
One More Time About Collation In PostgreSQL
Collation isn’t something you always need to worry about, but if ignored on a fresh OS install, it can bite you later. Here’s some advice on how to set up collation correctly when starting anew, and the impact it can have.
Vladimir Borodin   #code 
Executing Custom SQL in Django Migrations
For a long time Django lacked native migrations, instead developers opted for an add-on library. Now it’s fully integrated but there’s still more you can do than just what is labeled on the box, such as executing custom migrations as highlighted here.
Szymon Lipiński   #code 
pgslice: Easy Postgres Partitioning
Works for both new and existing tables, with no downtime and minimal app changes.
Andrew Kane   #code 
Stop Applying to Jobs - Let Companies Come To You
On Hired, engineers typically get 5+ job offers in 1 week. Find that new opportunity you've been craving and get access to 4,000+ companies instantly.
Hired.​com    #sponsored 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.