Issue #55: This Week's PostgreSQL News (#55)

Postgres Weekly Issue 55 - April 23, 2014

Postgres Weekly

Issue 55
April 23, 2014

As always, thanks to Craig Kerstiens for continuing to curate Postgres Weekly :-)

'UPSERT' (essentially 'insert or update') missed making it into the 9.4 release but people still have ways to replicate its functionality today. Here’s a look at the potential ways of implementing UPSERT-style behavior, some detail on the risks, and performance of each.

johto's lair

Differences between Warm, Hot Standby and Streaming Replication

Postgres has had a variety of options when it comes to replication for years, but not all replication options work similarly. If you’re unclear when DBAs or others talk about warm vs. hot vs. streaming, here’s a clear cut explanation.

Baji Shaik

Coming in 9.4: Getting Medians/Quantiles/Percentiles from a Single Query

Ordered set aggregates are coming in Postgres 9.4. If you’re not entirely sure what that means, here’s one example showing how you can easily get median or event percentiles (e.g. 95/99) within a query.

David Fetter

Why is this postgres query doing a bitmap heap scan after the index scan?

A deep dive into why the Postgres planner uses one type of scan vs. another. Here’s a thorough reproducible example as well as a look into why Postgres does what it does in this case.

Markus Winand

Broadcasting PostgreSQL NOTIFY messages to Websocket Clients

Listen/Notify or Pub/Sub directly in Postgres can be powerful and useful, but most applications and frameworks don’t take advantage of it. Here’s a great example of using it with Spring.

Database Patterns

PostgreSQL Tour De Force (for .NET Developers)

Peter Shaw and Rob Sullivan present a thorough introduction to Postgres, what makes it unique, why you might want to use it as a .NET database and how to use it in a simple .NET entity framework application. (Note: No video till 1:39.)

YouTube

NoSQL No More

Why does a relational system (PostgreSQL) more cost-effectively and better meet Revolv’s needs?

Matt Butcher

Curated by Craig Kerstiens and published by Cooper Press.
Want to sponsor an issue? See our media kit.

© 2017 Cooper Press Ltd. Email policy Privacy policy
Office 30, Fairfield Enterprise Centre, Louth, LN11 0LS, UK

Update your email address
or unsubscribe here

Issue 54 #55 Issue 56