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 143 — February 10, 2016
Migrating Postgres to Amazon RDS Without Downtime
The maturity of database-as-a-service providers has improved a lot. Whether Heroku Postgres or Amazon RDS, there are now fewer reasons to manage your own. Here’s a guide on how The Guardian migrated with no downtime from their own hosted instance to RDS.
The Guardian
Performance Tuning Queries in PostgreSQL
Database performance tuning still remains a magical art for many developers, but this post walks through everything you need to know to get started assessing and improving queries.
Brady Holt
Finally, 100TB PostgreSQL Data Warehouse Has Arrived
Vitesse DB Enterprise Edition is PostgreSQL for OLAP/BI enhanced with builtin multi-threading, LLVM JIT and compressed column store. Find out how this PostgreSQL solution for Data Warehouse or Data Mart can work for you.
Vitesse Data    #sponsored 
Creating a Document-Store Hybrid in Postgres 9.5
We’ve linked to a few ‘Postgres as a Document Store using JSONB’ posts. Here’s another that takes it one step further and converts some of those documents back to normalized data.
Nathan Fritz
Explaining the Postgres Query Optimizer [video]
Bruce Momjian   #video 
PostgreSQL Logical Decoding
Logical decoding has laid some great groundwork for things you can do with Postgres. This deck from Postgres Open walks through what logical decoding is and some example uses of it.
Álvaro Hernández
go-dberror: Parsing Postgres Errors in Go
Postgres’s error messages aren’t always as intelligible as they could be. Here’s a convenient Go package to help you make sense of some of them.
Shyp   #code 
Records: SQL for Humans (in Python)
If you’re using a framework you likely already have an ORM. If you’re using more a more direct approach in Python, however, this package aims to make working with Postgres directly simpler.
Kenneth Reitz   #code 
Building Full Text Search For Your App with Postgres
Most people jump to Elasticsearch or Solr for advanced search cases, yet Postgres can do a fine job of it itself.
Adailyz
PostgreSQL Developers, Consultants & Support DBAs at 2ndQuadrant
We're in demand ....and that means you could be too! Due to our continued growth we're looking for people with relevant PostgreSQL skills and experience. Check out our vacancies.
2ndQuadrant    #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.​com    #job 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.