DragonFly BSD now best platform for PostgreSQL and database hosting

[40hz]

The latest edition of DragonFly BSD has just been released. And it's developers/maintainers are reporting some interesting news (emphasis added):

The 3.2.1 release of DragonFly BSD is available now. Significant work has gone into the scheduler to improve performance, using postgres benchmarking as a measure. See the PDF of graphed results to see the improvements. DragonFly should be now one of the best selections for PostgreSQL and other databases. USB4BSD has been incorporated into this release. More USB devices are compatible with DragonFly, and xhci (USB 3.0) users may be able to take full advantage of their newer hardware.

They've posted a PDF of the performance graph. Link here.

If you are running an SQL database server, or responsible for administrating or deploying them, that claim may be a little too promising to simply ignore.
 

[Tuxman]

We all know that BSD is the better server system. 

[40hz]

...

[Tuxman]

 

[Shades]

In my experience, companies are not thrilled to leap from server OS to server OS for a few percent points of extra performance. And even if they want a new server there are such things as central management systems that may or may not have problems with this new version of DragonFly BSD.

Personally I do like PostgeSQL and whatever speed gains people can get out of it. In syntax very similar to Oracle, which is the beast I have most memorable (both good and bad) experience with. Just crossed the border of 0.5TByte databases with that one.

[40hz]

In my experience, companies are not thrilled to leap from server OS to server OS for a few percent points of extra performance. And even if they want a new server there are such things as central management systems that may or may not have problems with this new version of DragonFly BSD.

-Shades (November 04, 2012, 10:41 AM)

It's usually more that IT is not thrilled rather than management.

But more seriously, DragonFly is BSD even though it's now technically a fork. So it shouldn't be a cultural or paradigm shift for most IT departments with BSD or Unix experience. And I really can't imagine any good reason for not running PostgreSQL (or MySQL or most any other non-Microsoft SQL database server) on anything other than a BSD core if a version is available for it. The cost savings can be significant. And BSD is as rock solid as an OS can get.

But maybe that's just me?

[Tuxman]

But more seriously, DragonFly is BSD even though it's now technically a fork.

-40hz (November 04, 2012, 01:22 PM)

All current BSDs are forks.