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 138 — January 6, 2016
The FILTER Clause in Postgres 9.4
Postgres 9.4 is a year old now, and while we’ve covered many features we’ve given no lip service to this one. The filter clause allows you to show how many results were omitted my some clause, which for validating data or otherwise can be very handy.
Anderson Dias
UPSERT on Postgres 9.5
Postgres 9.5 is due to land soon with a host of awesome features. The highlight will undoubtedly be 'upsert' - if you’re not familiar with it, this is a great primer.
andrebarbosa.​co
What's New in PostgreSQL 9.5
Postgres 9.5 follows a recent trend of feature-packed releases for Postgres. Get the preview of what’s coming with the work in progress what’s new on the wiki, including: JSONB improvements, BRIN indexes, pg_rewind, and more.
postgresql.​org
Comprehensive PostgreSQL Administration (Live Virtual Training)
This special 1-week course (Jan 11-15) combines the core topics from Foundations of Postgres Administration and Advanced PostgreSQL Administration, with significant savings over list price. It is designed for database professionals who are responsible for administration and maintenance of PostgreSQL. Register now - use promo code COMB-WEB-161 to get an additional 20% off.
EnterpriseDB    #sponsored 
From Postgres to Cassandra
Hopefully readers have no doubt that Postgres is a great option as a database, but sometimes Postgres outgrows a single node. At that point there’s a few options such as something like pg_shard or other data solutions such as Cassandra. This guide helps show where something like Cassandra might play in.
Rimas Silkaitis
dbHero for PostgreSQL & MySQL
The list of options seem to keep growing for GUI editors for Postgres. dbHero looks to be a simple and clean option that looks great for OSX users.
dbHero
Is Bi-Directional Replication (BDR) in Postgres Transactional?
Bidirectional replication isn’t extremely common, but allows for potential multi-master setups with Postgres. Though as highlighted here, there’s a few new ways you need to approach transactional semantics as you do put it in place.
Riley Berton
pome: A Postgres Metrics Dashboard Written in Go
If you’re running and managing your own Postgres instance chances are you want some dashboarding and tooling around it. If you don’t already have one setup or want to take a look at another pome is a simple but elegant dashboard for PG in Go.
Rach Belaid   #tools #code 
pglogical: Next Generation Replication for Postgres
The foundation for logical replication landed in Postgres 9.4, and now there’s a great solution to help you take advantage of it with plenty of supporting tooling.
2nd Quadrant   #tools 
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.