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 113 — July 8, 2015
PostgreSQL 9.5 Alpha 1 Released
This release contains previews of all of the features which will be available in the final release of version 9.5 (e.g. Block-Range Indexes, UPSERT, Row-Level Security).
Postgresql.​org   #news 
Test PostgreSQL 9.5 Alpha in a Docker container
Postgres 9.5 is around the corner and if you don’t want to wait until it’s fully released to start playing here’s a Docker container to get you up and running with it.
databasesoup.​com
Slow PostgreSQL Performance? Don't Forget to Vacuum your Database
Under the covers Postgres is a giant append only log. This means even when you delete it’s still there, though it does come back through and clean up. Generally this works fine out of the box, but sometimes on large and busy tables you need to do a little yourself.
Marcus Gartner
Time for a Database Checkup?
Over time, conditions change including data growth, usage patterns, and the amount of resources available to the database. Periodic tuning is part of Postgres DBAs role to ensure that things continue to run smoothly. Learn how to optimize performance or get help with a database check up.
EnterpriseDB    #sponsored 
How About Hypothetical Indexes?
Hypothetical indexes we featured last week. If you haven’t given it a spin yet then you can get a deeper run down of how the extension works and the features that are available with it.
Julien Rouhaud   #code 
PipelineDB: The Streaming SQL Database
An open-source relational database (based on PostgreSQL 9.4) that runs SQL queries continuously on streams, incrementally storing results in tables.
PipelineDB
Beyond Upsert - Coming in PostgreSQL 9.5
Yes, we all know upsert is coming to Postgres 9.5, but that’s not all that’s included. Check out a rundown of a few of the other top features that we can expect with the next release.
DJ Walker-Morgan
Postgres 9.5 Feature Highlight: New JSONB Functions and Operators
If you’re curious to dive even deeper on the features in Postgres 9.5 than just beyond the high level here’s your run through of the improvements to JSONB. These new functions and operators continue to make Postgres and JSON as powerful as ever.
Michael Paquier
100x Faster Postgres Performance by Changing 1 Line (2013)
In a specific sort of query, that is.
Datadog   #tutorial 
Freelance with Companies like Airbnb, IDEO, JPMorgan
Work with top clients, set your own rates, and work from anywhere as an elite Toptal developer. Join the most exclusive network of top software engineers in the world.
Toptal    #job 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.