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 95 — March 4, 2015
The History of Replication in PostgreSQL
A lack of replication support in Postgres was a key reason for people picking MySQL over Postgres until about 5 years ago. Since then, Postgres has come a long way with replication and here’s a look at how it all came together.
Peter Eisentraut
Document Storage Gymnastics with Postgres
For single-node deployments Postgres is now a clear winner when it comes to document storage (versus MongoDB). This deep dive looks at how to take advantage of Postgres’ document storage, how to use indexes for optimization and also highlights cases where Postgres particularly excels.
Rob Conery
Resolve Database Performance Issues Quickly
AppDynamics' self-learning platform allows you to analyze actual database performance and detect anomalies automatically. It takes the guesswork out of defining optimal performance. Installs in Minutes. Start Free Monitoring
AppDynamics    #sponsored 
PoWA 2: Finding the Missing Index
The first major update to the Postgres workload analyzer (PoWA) includes the ability to identify missing indexes your app would benefit from.
Postgresql.​org
Tree Structure Query with PostgreSQL
Hierarchical structures are common in apps but don’t lend themselves to simple representations in relational databases. Fortunately, Postgres has a few tools to make things a bit smoother for you.
Trường TX
Is PostgreSQL Your Next JSON Database?
A look at how JSON in Postgres can work well for you.
Compose
It’s Time To Get Over That Stored Procedure Aversion You Have
A provoking opinion piece. “Stored Procedures are not inherently bad – you’ve been told this because someone thinks you’re not capable of thinking for yourself.”
Rob Conery
PostgreSQL Performance Tuning
This older post is still very relevant if you’re running Postgres on your own hardware. The short version is that Postgres generally works well out of the box, but if you’re configuring your own system there are some useful things to pay attention to.
Bruce Momjian
Job: Software Engineer @ Blue Apron (New York, NY)
If you're passionate about food and building supply chain and warehouse management systems from the ground up, give us a look. Our team's at 16 developers and growing...quickly.
Blue Apron    #sponsored 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.