Blogs

RedMonk

Skip to content

An Interesting MySQL to Postgres Migration Story

As is probably common knowledge by now, I’ve migrated from Bloglines – my former feed reader of choice – to the shiny new Ajax client Feedlounge. You may remember Feedlounge from such posts as Greasemonkey and Gmail, Revisited, The Bucks Start Here, and Bye For Now, Bloglines.[1] Some of you might also know – seeing as I mentioned it only a few days ago – that I’ve been hearing good things about Postgres from a variety of sources. As it turns out, the two are not unrelated.

As we heard from Alex yesterday, the cause of the downtime over the weekend was so that Feedlounge could be cut over from MySQL to Postgres. Among the reasons for the switch were a marginal major savings in total storage and major savings in DB load time. Throw in some better memory utilization and the attraction of some Postgres bells and whistles, and it made sense for Alex and Scott to make the move.

Is Postgres always going to be the better choice? Not at all. But when I said that Sun was choosing to support Postgres at an interesting time, it’s case studies like these that back that up.

Update: Alex was kind enough to point out that the total storage savings was anything but marginal. I had misread the savings as 10+ GB’s in MySQL to 9.6 in Postgres when the actual numbers were 34 GBs in MySQL to the aforementioned 9.6 in Postgres – a sizable difference. Appreciate the correction.

[1] For the Simpsons fans in the audience, yes, the phrasing was intentional.

Categories: Open Source.

Comment Feed

7 Responses

  1. I’d say that 3.5x is a pretty significant (as opposed to “marginal”) saving in storage.

  2. Sigh… And here I got all excited that perhaps Feedlounge was out of private alpha… ah, well… :(…

    rick gregoryNovember 21, 2005 @ 9:44 pmReply
  3. Not yet, but we’re another big step in the right direction. :)

  4. hey rick – don’t feel bad. i haven’t seen it yet either, and I work with Stephen…

  5. Stephen,

    You’ve gotta treat poor James better… sheesh, man.

    Alex,

    Must. Have. now! :)

    BTW, it would be interesting to know what issues you ran into with the MyISAM tables. I’d have thought that they’d work fine for your app (in general since I’ve, er, cough, cough… not seen it yet… ).

    rick gregoryNovember 22, 2005 @ 7:29 pmReply



Some HTML is OK

or, reply to this post via trackback.

Continuing the Discussion

  1. Sun: putting the dot in web 2.0

    I am sure neither Sun nor the market at large particularly wants to be reminded of the dotcom boom and subsequent bust. And yet… There do seem to be substantive changes going on in the market, that are worth noting. I don’t…

  2. Sun: putting the dot in web 2.0

    I am sure neither Sun nor the market at large particularly wants to be reminded of the dotcom boom and subsequent bust. And yet… There do seem to be substantive changes going on in the market, that are worth noting. I don’t…