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 149 — March 23, 2016
These Are a Few of My Favorite (psql) Things
It’s not much of a secret I love psql, the command line based utility for interacting with Postgres. If you think you need a graphical editor, though, first try exploring all psql has to offer.
Lauren Ellsworth
Join the Postgres Community on Slack
Love Postgres? Can’t wait each week to get your regular fix? Or just have an issue you want some input on? Join the Postgres Slack live chat group and join others in conversation around all things Postgres.
Postgres Slack
Scan and aggregate 81 GB table in 5 seconds!
Vitesse DB Enterprise Edition is PostgreSQL enhanced with built-in multi-threading, LLVM JIT and compressed column store. Check out the TPC-H 100 numbers, and discover why PostgreSQL is ready for reporting and data warehouse.
Vitesse Data    #sponsored 
Parallel Aggregation Support for Postgres 9.6
Up until now Postgres on a single node only couldn’t take advantage of parallelism. Postgres 9.6 is starting to shape up as the release to improve that.
Robert Haas   #news 
PostgreSQL Upsert; A Few Bad Apples
A look at some real-world problems a developer ran into when using the new ‘upsert’ functionality in Postgres.
David Toomey
Approaches to High Availability for Postgres [PDF]
You want to be up 24/7 - part of that is having your database up too. When it comes to high availability there’s no shortage of options but they all have tradeoffs. Take a look at a rundown of pros and cons of various approaches here.
Christophe Pettus
Fast Search Using PostgreSQL Trigram Indexes
When you want to have free form search on text, full-text search is usually the solution. Postgres has powerful built-in search features, and GitLab highlights here how they used it to improve the experience of their service.
Yorick Peterse   #tutorial 
Troubleshooting Waits in PostgreSQL
Amit Kapila   #tutorial 
Understanding Distributed Postgres BDR
A slide presentation on Postgres BDR, which continues to be in the works. You’ll find background information necessary to understand different Postgres Distributed modes of operation and a high-level of what BDR is.
Chris Meyers   #opinion 
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.​com    #job 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.