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 118 — August 12, 2015
PostgreSQL 9.5 Alpha 2 Released
The second alpha release of PostgreSQL 9.5 is available for download with numerous bugs and issues fixed since the first alpha. The final release will be late in the year.
postgresql.​org   #news 
PostgreSQL 9.5 New Features with Examples [PDF]
Postgres 9.5 is just around the corner, and if you want to hit the ground running with all the new features such as upsert, here’s a great run down with hands on examples. (77 page PDF)
Hewlett Packard Japan
VividCortex and PostgreSQL Monitoring
VividCortex is the easiest, safest, and most detailed way to monitor PostgreSQL. Unlike other tools that just capture a few status metrics, VividCortex measures every query, every process, and every metric on your entire system, down to the microsecond to improve performance.
VividCortex    #sponsored 
How to Use Heroku PGBackups
If you care at all about you data, you want to have a solid story around your backups. If you’re on Heroku Postgres then it can become quite easy for you with PGBackups, here’s a walkthrough in what you need to know
Barry Jones
Please, Security Test Our Code
In response to Oracle’s ‘stop checking our code for vulnerabilities’ debacle, Postgres’ Josh Berkus openly invites people to security test Postgres.
Josh Berkus
Postgres 9.6 feature highlight: pg_basebackup and replication slots
The replication story of Postgres continues to get better and better, with primitives rapidly improving. Here’s on of the first to land in Postgres 9.6, though we’ve got a while before we’ll see it land if you’re operating Postgres this is worth a look.
Michael Paquier
Postgres Tricks in .NET
Peter Shaw
Don't Test with SQLite When You Use Postgres in Production
It should go without saying that using two different database systems in different environments is a recipe for trouble, but Michael explains why.
Michael Robellard
Understanding Unintuitive TABLESAMPLE Results
Want to sample the stats in your Postgres to get a rough count of records? There’s a great way to do that… just on some small tables you might be a bit surprised by the results, here’s the background on how it works to explain why.
Database Soup
Using Postgres in Go
Many web frameworks have rich ORMs, some of which support Postgres specific features, some less so. For many though Go is much more direct in how you access Postgres, but this should help you get pointed in the right direction.
Jim Walker   #tutorial 
Minimalistic Docker Container with Postgres
Michael Paquier
cstore_fdw 1.3 Release for Columnar Store PostgreSQL
Cstore the open source columnar (which popular databases such as Vertical and Redshift are as well) extension has a new update. The update is primarily around better I/O and disk usage.
postgresql.​org
Intercom is looking for Software Engineers for our product team in Dublin, Ireland
Our product teams are multidisciplinary with design, frontend and backend engineering combined. While specialisation is important, we dislike pigeonholing. Great engineers pick the best tools to build the best product.
Intercom    #job 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.