The EDB Blog

The latest thought leadership pieces from EDB, including company and PostgreSQL announcements

Recent Posts

Why The Clock is Ticking for MongoDB

Robert Haas April 16, 2014

Last month, ZDNet published an interview with MongoDB CEO Max Schireson which took the position that the document databases, such as MongoDB, are...

Postgres Gets the Business

Bruce Momjian April 6, 2014

I just returned from attending PGConf NYC. They had 259 participants, more than double last year's total. The conference was in a hotel near Wall...

Subtly Bad Things Linux May Be Doing To PostgreSQL

Robert Haas April 2, 2014

In addition to talking about PostgreSQL at LSF/MM and Collab, I also learned a few things about the Linux kernel that I had not known before, some of which could have implications for PostgreSQL performance. These are issues which I haven't heard discussed before in the PostgreSQL community, and they are somewhat subtle, so I thought it would be worth writing about them.

Back from LSF/MM and Collab

Robert Haas March 31, 2014

Last week, I attended the Linux Storage, Filesystems, and Memory Management summit (LSF/MM) on Monday and Tuesday, and the Linux Collaboration Summit...

PostgreSQL Now Has Logical Decoding

Robert Haas March 18, 2014

A few weeks ago, Josh Berkus wrote a blog post on Why HStore2/jsonb is the most important patch of 9.4. Everybody's going to have their own opinion on these kinds of questions, but for what it's worth, I think the most important new feature in 9.4 is going to turn out to be logical decoding, the result of a lot of hard work mostly by Andres Freund.

Write Scalability for UPDATE Operations

Robert Haas March 13, 2014

Yesterday, Heikki Linnakangas committed this patch: commit a3115f0d9ec1ac93b82156535dc00b10172a4fe7 Author: Heikki Linnakangas Date: Wed Mar 12 22:46:04 2014 +0200 Only WAL-log the modified portion in an UPDATE, if possible. When a row is updated, and the new tuple version is put on the same page as

Postgres: The Open Database Foundation

enterprisedb enterprisedb March 12, 2014

A decade ago, most companies faced financial challenges related to the dot-com bubble burst. Today, we’ve just gone through what was likely the worst...

Linux's fsync() woes are getting some attention

Robert Haas March 10, 2014

In two weeks, I'm headed to LSF/MM and the Linux Collaboration Summit, by invitation of some Linux kernel hackers, to discuss how the Linux kernel can...

EnterpriseDB Celebrates 10 Years

Ed Boyajian March 5, 2014

EnterpriseDB is 10 years old this year and we marked this milestone with a record 70 percent increase in subscription revenue growth. In fact, the...

VACUUM FULL doesn't mean "VACUUM, but better"

Robert Haas March 4, 2014

There's a persistent belief among some users of PostgreSQL that VACUUM and VACUUM FULL do the same thing, but that VACUUM FULL does it better. If VACUUM is the moral equivalent of running the Dust Buster across the room a few times, VACUUM FULL must be the equivalent of hiring a professional cleaning crew to shampoo the carpets, and maybe repaint the walls as well. Unfortunately, this mental model is not accurate.