Re: DICE News Article Comment - Mailing list pgsql-advocacy

From Michael Paquier
Subject Re: DICE News Article Comment
Date
Msg-id CAB7nPqRqbk+vnwFf3WCrhdKfBPCi1qRKhBNyWUuKNzmiu+De_w@mail.gmail.com
Whole thread Raw
In response to DICE News Article Comment  (Joshua Kramer <joskra42.list@gmail.com>)
Responses Re: DICE News Article Comment  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
List pgsql-advocacy
On Mon, Mar 23, 2015 at 9:49 AM, Joshua Kramer <joskra42.list@gmail.com> wrote:
> Did anyone catch this comment?
>
> http://news.dice.com/2015/03/19/why-i-choose-postgresql-over-mysqlmariadb/#comment-2638712
>
> Given the stories I've heard about Postgres working well in that type of
> application, I'm wondering what out-of-the-ordinary thing that application
> did to cause Postgres to lock up as he said it did.

This comment does not mention the version used, but it mentions the
JSON features of a "couple of months back", so I would guess that they
tried with 9.4.0 and jsonb. Now I recall as well the following bug:
http://www.postgresql.org/message-id/20140731233051.GN17765@andrew-ThinkPad-X230

And it has been fixed by Alvaro here, included in 9.4.1:
commit: 0e3a1f71dfb31527c07a80ccba815b2928d70d8f
author: Alvaro Herrera <alvherre@alvh.no-ip.org>
date: Fri, 26 Dec 2014 13:52:27 -0300
Grab heavyweight tuple lock only before sleeping

So perhaps it was the problem they faced?
Regards,
--
Michael


pgsql-advocacy by date:

Previous
From: Joshua Kramer
Date:
Subject: DICE News Article Comment
Next
From: Gavin Flower
Date:
Subject: Re: DICE News Article Comment