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 119 — August 19, 2015
'Big Data' Features Coming in PostgreSQL 9.5
Postgres 9.5 will be here soon and here’s a rundown of the features that help with dealing with big data and performance.
LWN
Codeship Interview: Peter van Hardenberg (Heroku Postgres)
Heroku Postgres is one, if not the largest, fleet of Postgres databases in the world. If you want an inside look at some of the lessons learned and how the team has scaled it to what it is here’s a great behind the scenes look.
Amanda Hackwith
Want to work on new projects? Make more money? Try a new stack? Relocate?
On Hired, we'll bring the options to you. With over 2,000 pre-screened tech companies in 10 cities in the US UK, you'll be sure to find what you're looking for. Join Hired today.
Hired.​com    #sponsored 
Estimating Needed Memory for a Sort
Some Postgres settings are simple and straight forward, others can have big impact and be harder to know what the perfect setting is such as work_mem. This guide walks through how much memory you use in a sort, and helps you properly set a good work_mem value.
Julien Rouhard   #code 
PostgreSQL Conference Silicon Valley Session List
PGConf Silicon Valley is a few months away, so there’s still time to grab your ticket and plan to attend. In case you need extra motivation the list of talks is now live, and they look great.
pgconfsv.​com
Approximate counts in Postgres
Under the covers Postgres has a mechanism of tracking a rough count of the rows in a table, but it includes querying some under the hood catalog tables. Though with this handy function you can now easily query any table for a rough count.
David Detter
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.