---
title: "This Week's PostgreSQL News (#55)"
publication: "Postgres Weekly"
issue: 55
published_at: "2014-04-23"
canonical_url: "https://postgresweekly.com/issues/55"
---

Postgres Weekly Issue 55 - April 23, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/55)**Postgres Weekly****Issue 55**
April 23, 2014As always, thanks to [Craig Kerstiens](https://twitter.com/craigkerstiens) for continuing to curate Postgres Weekly :-)[UPSERTisms in Postgres](http://johtopg.blogspot.se/2014/04/upsertisms-in-postgres.html?utm_source=postgresweekly&utm_medium=email)'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](http://bajis-postgres.blogspot.com/2014/04/difference-between-warm-hot-standby-and.html?utm_source=postgresweekly&utm_medium=email)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](http://people.planetpostgresql.org/dfetter/index.php?/archives/75-9.4-Quantiles!.html?utm_source=postgresweekly&utm_medium=email)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?](http://ask.use-the-index-luke.com/questions/148/why-is-this-postgres-query-doing-a-bitmap-heap-scan-after-the-index-scan?page=1?utm_source=postgresweekly&utm_medium=email)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](http://blog.databasepatterns.com/2014/04/postgresql-nofify-websocket-spring-mvc.html?utm_source=postgresweekly&utm_medium=email)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)](https://www.youtube.com/watch?v=SQYKhaQrwska?utm_source=postgresweekly&utm_medium=email)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](http://technosophos.com/2014/04/11/nosql-no-more.html?utm_source=postgresweekly&utm_medium=email)Why does a relational system (PostgreSQL) more cost-effectively and better meet Revolv’s needs?_Matt Butcher_Curated by [Craig Kerstiens](http://craigkerstiens.com/) and published by [Cooper Press](https://cooperpress.com/).
Want to sponsor an issue? See our [media kit.](https://cooperpress.com/mediakit2014q2.pdf)

 © 2017 Cooper Press Ltd. [Email policy](https://cooperpress.com/spam.html) [Privacy policy](https://cooperpress.com/privacy.html)
Office 30, Fairfield Enterprise Centre, Louth, LN11 0LS, UK[Update your email address](*|UPDATE_PROFILE|*)
or [unsubscribe here](*|UNSUB|*)