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 139 — January 13, 2016
PostgreSQL 9.5 Released
Postgres 9.5’s headline features include UPSERT, row level security, and extra ‘big data’ features like BRIN indexing, improved foreign data wrappers, and TABLESAMPLE, an SQL clause for statistical sampling of large tables.
PostgreSQL   #news 
PGCon 2016 Call for Papers Open (Ottawa, May 19-20)
PGCon, the premiere conference for Postgres hackers, is back. If you’re doing something interesting either down in the core, as an extension, or even as an end user the CFP is open to come and speak.
PGCon
Postgres Monitoring
Visualize system resources, connections, locks, transactions, and indexes for full-stack, realtime performance correlation.
Datadog    #sponsored 
Here's Postgres 9.5: Now Available on Heroku
If you’re looking to take Postgres 9.5 for a spin and down want to spin it up yourself on a server, Heroku has an answer. Supporting 9.5 on its beta release day, a single click can bring you a 9.5-powered database to explore.
Heroku   #news 
PostgreSQL Past, Present, and Future: Moving The Goalposts
A few years back MySQL had a few legs up on Postgres with simple replication setup, upsert… but now that list of missing features is virtually nonexistent. So with Postgres moving not just to feature parity but beyond, here’s some good speculation on what the future might hold.
Robert Haas
PostgreSQL 9.6 Wish List
Now that 9.5 has been released, it’s time to start speculating about the future. Here’s one developers wish list of what they’d like to see for 9.6 - what’s yours?
Neil McGuigan
Writing More Legible SQL
Writing SQL is one thing, but when it comes to reading other’s SQL, things can get tricky. These few tips will help to make your SQL much more understandable by others.
Craig Kerstiens
Using the Ltree Datatype in Postgres
Nested or hierarchical structures in a database aren’t overly common, and can provide numerous frustrations when you try to implement them, but Postgres has one option that can work quite well: Ltree.
Kris Schultz
Using CTEs and Unions to Compute Running Totals
Here’s a great use that combines CTEs with unions to give not just grouped results, but also side by side results with the overall aggregate.
Periscope
Heroku Data Infrastructure Engineer
Join the Heroku Data team and learn about supporting and operating database systems at scale.
Heroku    #job 
Postgres Skills are in demand.
Indeed Prime is an elite new program from Indeed.com that presents in-demand tech talent like you to top employers. Indeed Prime opens the door to exciting career opportunities with one simple application. Join today.
Indeed    #job 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.