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 206 — May 10, 2017
Building JSON API Responses With Postgres CTEs
A neat demonstration of using common table expressions to provide extra assistance to other queries.
Eric Satterwhite
When Postgres Is Not Enough
Postgres is great but it doesn’t solve all data problems. Here’s a balanced perspective of how Postgres wasn’t working in every aspect for one team, but still remained a key part of their stack.
Leonardo Brito   #opinion 
Scaling Connections in Postgres
One issue that comes when running Postgres at a high scale is managing large numbers of database connections. Here we see how to assess your connection count number and what to do about it.
citusdata
How One Preschool is using PostgreSQL and Redis on Compose
One Preschool is making preschooling both accessible and practical throughout the world. We spoke with them to hear about their startup, mission and how they are using Compose hosted PostgreSQL and Redis to make this happen.
Compose    #sponsored 
Testing Huge PostgreSQL Backups for 37 Cents a Day
Some clever rigging up of WAL-E, S3, and EC2 for backing up a Postgres database and then testing that it restores correctly every day.
Ben Ubois
Schedule for PGDay UK 2017 (July 3-4, London)
PGDay UK is coming up again in several weeks - the schedule is live and if you’re in Europe it’s worth checking out.
PGDay UK   #news 
Amazon RDS for Postgres Now Supports Minor Versions 9.6.2, 9.5.6, 9.4.11 and 9.3.16
Amazon Web Services   #news 
Deep Dive Into Postgres Stats: pg_stat_all_tables
In the continuing series about Postgres stats is a look at data Postgres keeps about sequential scans and autovacuum.
Alexey Lesovsky
Who Contributes to Postgres Development?
Robert Haas went through Postgres’ 2016 commit log to see who the biggest contributors to the project are.
Robert Haas
A Postgres Response to Uber [PDF]
Last year Uber switched from Postgres to MySQL, here Christophe Pettus goes through the reasons why.
Christophe Pettus
Benchmarking Complex Query Performance in CrateDB vs Postgres
The benchmarks are by the Crate team themselves, but the open source distributed SQL database may be worth investigating for certain use cases.
CrateDB   #opinion 
pglogical 2.0: Logical Replication as a PostgreSQL Extension
2ndQuadrant   #tools 
PostGraphQL: Create GraphQL Schemas from Postgres Schemas
PostGraphQL   #tools 
Support Modern Digital Apps & DevOps with Your Legacy IT
Hands-on workshops, DBA/developer tracks at Postgres Vision. Attend for $200 off with code PGWEEK by May 19.
Postgres Vision 2017    #sponsored 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.