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 106 — May 20, 2015
Postgres Job Queues and Failure By MVCC
Postgres can provide great queue-like functionality for your application but sometimes the locking mechanisms required can create pain on production load systems.
Brandur
PostgreSQL Conference Europe 2015 Call for Papers
It’s going to be in Austria this October.
postgresql.​org
Using PostgreSQL Explain
Every time a query is run, Postgres forms a ‘plan’ of how it will execute it. You can look at this plan with EXPLAIN - here’s a post that provides an overview of its use.
Bitpop
The New Data Center Standard
A New Gartner report predicts open source databases will overtake proprietary solutions. By 2018, 70% of new apps will be deployed on OS databases with Postgres playing a huge role. Download the report. (Registration Required.)
EnterpriseDB    #sponsored 
Postgres Toolkit 0.2 Released
A collection of scripts and queries that any DBA should keep handy to help monitor and maintain a Postgres database.
Satoshi Nagayasu
New JSONB Features for 9.5
Postgres 9.5 is coming and the final set of features are making their way in. Here’s the rundown of improvements to JSONB with a new awesome operator to concatenate two JSONB values.
Andrew Dunstan
Announcing VividCortex's Free Network Analyzer Tools for MySQL and PostgreSQL
VividCortex   #tools 
Waiting for 9.5 – Add Support for INSERT … ON CONFLICT DO NOTHING/UPDATE
Last week we looked at how ‘upsert’ functionality was finally landing in Postgres (in 9.5). This article takes another look at how it will work with an in-depth dive.
Hubert depesz Lubaczewski
ERAlchemy: Entity Relation Diagrams Generation Tool
Visualizing your data model can often provide some clarity as to how you’re interacting with it. ERAlchemy is a tool that makes generating Entity Relation Diagrams simple and easy.
Alexis Benoist   #code 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.