Posts Tagged ‘PostgreSQL’

Tab Sweep – 7 August 2017

Not quite a “tab sweep”, this is me dumping out my OmniFocus todos!

  • QOTD: “Yesterday, you said tomorrow.” – Nike
  • Do you think about using MariaDB ColumnStore? Back in January, there was an interesting Twitter thread. It is in French, and things have improved, but this is a colourful description.
  • A PostgreSQL response to Uber is the Hacker News discussion, slides from Christophe Pettus presented at Percona Live Santa Clara 2017. Well worth reading, this wasn’t an easy talk to get on the agenda, and the commentary is also particularly interesting.

CFP for Percona Live Europe Dublin 2017 closes July 17 2017!

I’ve always enjoyed the Percona Live Europe events, because I consider them to be a lot more intimate than the event in Santa Clara. It started in London, had a smashing success last year in Amsterdam (conference sold out), and by design the travelling conference is now in Dublin from September 25-27 2017.

So what are you waiting for when it comes to submitting to Percona Live Europe Dublin 2017? Call for presentations close on July 17 2017, the conference has a pretty diverse topic structure (MySQL [and its diverse ecosystem including MariaDB Server naturally], MongoDB and other open source databases including PostgreSQL, time series stores, and more).

And I think we also have a pretty diverse conference committee in terms of expertise. You can also register now. Early bird registration ends August 8 2017.

I look forward to seeing you in Dublin, so we can share a pint of Guinness. Sláinte.

CfP for Percona Live Santa Clara closes November 13!

At Percona Live Amsterdam recently, the conference expanded beyond just its focus areas of MySQL & its ecosystem and MongoDB to also include PostgreSQL and other open source databases (just look at the recent poll). The event was a sold out success.

This will continue for Percona Live Santa Clara 2017, happening April 24-27 2017 – and the call for papers is open till November 13 2016, so what are you waiting for? Submit already!

I am on the conference committee and am looking forward to making the best program possible. Looking forward to your submissions!

Percona Live Europe Amsterdam PostgreSQL Day

This is my very first post on Planet PostgreSQL, so thank you for having me here! I’m not sure if you’re aware, but the PostgreSQL Events page lists the conference as something that should be of interest to PostgreSQL users and developers.

There is a PostgreSQL Day on October 4 2016 in Amsterdam, and if you’re planning on just attending a single day, use code PostgreSQLRocks and it will only cost €200+VAT.

I for one am excited to see Patroni: PostgreSQL High Availability made easy, Relational Databases at Uber: MySQL & Postgres, and Linux tuning to improve PostgreSQL performance: from hardware to postgresql.conf.

I’ll write notes here, if time permits we’ll do a database hackers lunch gathering (its good to mingle with everyone), and I reckon if you’re coming for PostgreSQL day, don’t forget to also signup to the Community Dinner at

osquery is neat

Facebook recently made opensource, osquery. It gives you operating system data via SQL queries! Its very neat, and you can test this even on MacOSX (it works on that platform & Linux). It is by far the project with the most advanced functionality, linked here in this post.

I noticed that rather quickly, there was a PostgreSQL project, called pgosquery, based on Foreign Data Wrappers with a similar idea. (apparently it was written in less than 15 minutes; so a much lower learning curve than the regular MySQL storage engine interface)

I immediately thought about an older MySQL project, by Chip Turner (then at Google, now at Facebook), called mysql-filesystem-engine. This idea was kicking around in 2008. I was intrigued by hearing about this at a talk (probably at the MySQL Conference & Expo); it’s a pity no one took this further.

On a similar tangent, did you also know that there is the option to use MySQL as storage via FUSE (see: mysqlfs)? An article by Ben Martin shows some practical examples.

At its heyday, MySQL had many storage engines (maybe around 50). Wikipedia has an incomplete list. I see some engines on that list, and think that some of these folk are also creating MongoDB backends — competition. At MariaDB we are probably shipping the most storage engines of any MySQL-based distribution, however I think we could be doing an even better job at working with upstream vendors, and figuring out how to support & augment business around it.

MySQL vs. PostgreSQL

We were at the Sun+Zend party last night, and it was a blast (thank you Jesse Silver!). If you’re a PostgreSQL or MySQL user/developer or just a general database geek, you should’ve been there. Why?

(watch the video if its stripped in your feed reader)

Monty Widenius (MySQL) and Josh Berkus (PostgreSQL), decided to start sumo wrestling! It ended with a 5-0 score, advantage MySQL.

An attendee Tim Moore twittered: “Postgres is totally losing the sumo match. I’m migrating all of my databases to MySQL tomorrow.”

Monty says, this is what we do to people that leave Sun! In fact, if you didn’t already know, Josh Berkus, my esteemed colleague in the Database Group at Sun Microsystems, is leaving his post as the PostgreSQL Team Lead. We met for the first time, face to face at last year, and all I can say is I’m truly saddened to see him leave. But thanks to the magic of the open source world, we’ll still be interacting, I’m sure. Good luck Josh! (and better sumo practising next time, mmmkay?)