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 169 — August 10, 2016
Benchmarking Postgres on Multiple Linux Kernel Versions
Comparing Postgres performance across different memory or CPU configurations is common, but does the Linux kernel version used make a difference under otherwise similar conditions? To a point, yes.
Tomas Vondra   #opinion 
Sharding A Multi-Tenant App with Postgres
If you reach a point that you need to scale beyond a single node, sharding becomes an appealing option. If you have a multi-tenant application, this post will help with how you should approach modelling your data.
Citus Data
A Look at Postgres' Index Internals
Postgres is rich with index types, B-Tree for standard tables, GIN for full text search and JSONB, GiST for PostGIS. And if you’re curious on what actuallly happens under the covers there’s much more you can learn. This PgCon talk (videos and slides available) is a great guide to how the internals of index types work.
Heikki Linnakangas
Try Compose PostgreSQL, get a free tshirt!
This month only, we're giving away free tshirts for all new deployments of Compose PostgreSQL. It takes just a couple minutes to signup and deploy a HA, 3-node Postgres cluster with daily backups and autoscaling. Give it a try.
Compose    #sponsored 
Thoughts on Uber’s List of Postgres Limitations
In what may be the last of the responses to Uber’s post on moving from Postgres to MySQL, Simon Riggs of the Postgres core team takes a look at each of the major issues, provides a response, and best of all gives some insight for how Postgres roadmap may help address them.
Simon Riggs
A 'Simple Moving Objects' Database with Postgres
A guide for how you can deal with geospatial objects and track them over time.
Gašper Žejn   #tutorial 
Backing Up Tablespaces and Streaming WAL with PGHoard
Version 1.4.0 of PGHoard arrives with support for PostgreSQL 9.6 beta3, StatsD and DataDog metric support and more.
Oskari Saarenmaa
Scheduled Postgres to Redshift Copy with a Simple Heroku App
Federico Rebora   #tutorial 
1M Rows/s from Postgres to Python
A look at a new Python Postgres client focused on speed that reaches some impressive numbers for reading data.
Elvis Pranskevichus and Yury Selivanov
Advanced SQL in Rails
ORMs can be nice to work with and you don’t always have to sacrifice the power of SQL when working with them. Here’s the first part of a series looking at taking advantage of more powerful SQL, like window functions, within Rails.
brewhouse
Stop Applying to Jobs - Let Companies Come To You
On Hired, engineers typically get 5+ job offers in 1 week. Find that new opportunity you've been craving and get access to 4,000+ companies instantly.
Hired.​com    #job 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.