Hello JPUG

It wasn't without minor issues (FinnAir pilots got ill, had to replace crew, hello 2 hour delay. Missed bus at the airport, hello to another 45 minutes. Turned out the hotel was big enough to have three separate receptions - naturally, I didn't go to the right one), I managed to meet up with Hiroshi Saito at my hotel. It wasn't even too late for a quick lunch with him before he had to leave.

Got some email done, and some final polishing on my slides. Now I just need to figure out what to say...

Had dinner and a beer at the skybar. The Tokyo skyline is really impressive at night - especially for someone who lives in a country that has extremely few highrisers. And yes, I forgot my camera. Maybe another day.

The jetlag is starting to take it's toll now - I need to head to bed. It's about 28 hours ago since I got up [HTML_REMOVED]this morning[HTML_REMOVED]...

Tomorrow's the big day. See you in the reception, Ishikawa-san :-)

Google analytics makes pretty graphs

A couple of days ago, we enabled Google Analytics on the postgresql.org website (possibly temporary, haven't decided on that yet) to collect some statistics primarily about the languages our visitors have configured in their browsers. The method google uses (client-side javascript) makes it very easy to integrate in our distributed platform with 4 different mirrors handling the main site, spread across the world.

And I have to say, it certainly makes for some pretty graphs that I'm sure would impress the hell out of a lot of PHBs and market analysts. Take this, for example:

It shows the languages of people visiting the postgresql.org website, with a highlight on the people who prefer Japanese.

The statistics themselves are also very interesting - only (and I do think this is only) just over half the visitors have english configured as their primary language. No other languages are very big, but there are a lot of them (107 combinations in total). The most common other languages (German, Brazilian Portuguese, Japanese, Spanish, French) are not very surprising either, given how our community looks.

One interesting piece of statistics around the languages is that for the mailinglist archives, it's very different - English is of course even more common, almost all other languages are less common, but Spanish increases up to about 10%25. I have no explanation for this, but it's interesting..

When you instead look at the top URLs, there's some further interesting stuff going on:

Not surprising, the frontpage is the most loaded page. And the main docs page is second, with a couple of different download links following that. However, in 7th place with 1.6%25 of the total pagehits is the download for 8.2.3 win32 binaries. That's more than the people browsing for source, let alone those who download it. And this does not include the people who just grab it from their local mirror. Interesting.

The final piece of statistics today will be browsers and platforms used. First, browser:

Not really surprising, Firefox is the big leader, with well over 50%25. Internet Explorer has about a third of our visitors. Most other browsers are very small.

Now, moving on to platforms:

Slightly more surprising here. Even though PostgreSQL is very Unix-centric, we still have almost three quarters of our visitors using Windows. Unlike many other sites, though, we have a lot more Linux users than Mac - but that comes with the usage pattern.

We've also got NTT DoCoMo showing up as a top browser, which is also interesting. I beleive that's a mobile phone browser used in Japan. Our site is definitly not mobile-adapted, but obviously good enough for some.

That ends todays list of (possibly meaningless) statistics and pretty graphs.

Todays funny quote from the lists

This one was just so good I had to put it here - if you're already reading the pgsql-general list, just ignore this post. On a thread about stupid benchmarks (comparing databases with default settings without changing anything, comparing MyISAM with a transactional engine, etc), Tom Lane gave us this gem:

I think it's a fine analogy, precisely because they're both good in their respective problem domains. Try to carry 500 people from Los Angeles to Tokyo in an F-15. No? Try to win a dogfight in a 747. No? But they both fly, so it must be useful to compare them... especially on the basis of the most simplistic test case you can think of. For extra points, use only one test case. Perhaps this paper can be described as "comparing an F-15 to a 747 on the basis of required runway length".

That's a good one, Tom! And can we please have proper benchmarks instead of this kind. (I'm intentionaly not linking to the actual benchmark in question)

And so it begins

This is an indication of the first patch I've committed directly to the PostgreSQL source tree. Yes, that means I'm now a committer, something I find very exciting. It will give me a lot of opportunities to make brand new kinds of mistakes. Hopefully I will also be able to help take the load off the other committers as well.

To the guys who decided - thanks for the vote of confidence! I'll try not to mess up /mha/templates/default/img/emoticons/smile.png alt=":-)" style="display: inline; vertical-align: bottom;" class="emoticon" /

Fixed security releases out now

Unfortunately, the security releases published monday had a pretty bad regression in them that broke a lot of scenarios, affecting 8.0, 8.1 and 8.2. New releases out today fixes this.

So. If you installed the security fix Monday, be sure to get the new version. If you didn't, be even more sure to get the new version so you get the security fix!

Most of the major distributions have updated their packages with the fixed fixes by now, but make sure yours does - you might need to wait a day or two in some cases.

Docbot integration with websearch

Robert has committed the code to integrate the docbot (familiar to users in the #postgresql IRC channel) with the web search. Basically it does a very simple keyword matching against a limited set of keywords, and presents those hits before we show the full-text searches. Try it out for example by searching for lock.

Hopefully this will help out when people search for really ambigous things (like lock in the example) where a full text search can give too many and too unrelated results.

Thanks, Rob, now I didn't have to do that. But I'll steal your fame by blogging about it first.

Todays insanely funny quote

Got this from Stefan:

(21:49:25) Stefan Kaltenbrunner: my niece (13 year old) just asked me what I'm doing right now

(21:49:56) Stefan Kaltenbrunner: I answered "well working for a project I'm part of" - look at www.postgresql.org for more information

(21:50:19) Stefan Kaltenbrunner: and she came back with "ok so this is a website about an elephant called fujitsu?"

Going home

I'm currently at the airport waiting for my flight home from SolutionsLinux (I really like how you an finally expect an airport to have proper wireless coverage in all seating areas in an airport, and not just a tiny wireless hotspot with 5 seats and 200 people. About time. It's not free yet, but hopefully that will also happen)

In summary, it was a really great show. Lots of interesting people to chat with, both from "the team" (meaning the postgresqlfr guys, Devrim, Greg and Heikki - group picture in Guillaumes blog), people in the other booths and the people who came to visit our booth. There were a lot of interesting situations people brought up that they needed help with. Everything from configuring tsearch2 for special-case usage in french (I learned a little more about the French language, but mostly that I really don't know enough about the language to help with that. And I could learn a few more things about tsearch2 as well there) to tuning postgresql and stored procs for loading large amounts of data (no, it's not acceptable that it takes 2-3 months to load six million rows of master data and related subdata, even if you do a whole lot of checks on it). Hopefully we could be of help to some of these people, and managed to refer the rest of them to the proper place to ask more.

I would also like to add that I think the business/non-profit mix in the PostgreSQL booth worked really well. I've heard some people who have concerns about PostgreSQL company representatives (in this case, Dalibo, CommandPrompt and EnterpriseDB) manning a non-profit booth. But really, I see no problem. They are all in "community first" mode. Sure, they get to hand out their little flyers and business cards (of course they do!), but the primary work is to help the users as a part of the community. I can see how people can feel it could be a problem in theory, but if you work with the right people (which I have the feeling that we generaly do in the PostgreSQL community, given the representatives I've met from the pg companies - both now and earlier) it's just not going to be a problem in reality. (But Greg, pouring coffee over the competition may not be an acceptable thing. Try not to make a habit out of it)

So to sign off from that, a big thanks to the french people at postgresqlfr for inviting me and making me feel really welcome here, to Dalibo for taking care of the travel costs, to Devrim for a nice couple of days hanging out, and to all the people I met here for having a great time! I will definitely do this again next year if given the chance /mha/templates/default/img/emoticons/smile.png alt=":-)" style="display: inline; vertical-align: bottom;" class="emoticon" /

Oh, and some free marketing for these guys for providing free wireless internet so we could communicate with the world, since our hotel didn't have one (hello, Gavin).

People everywhere

Third and final day of SolutionsLinux 2007 today. There's interesting people all over to meet yet again - and no, we haven't exhausted the supply yet.

As planned, Greg Heikki from EDB showed up - they actually managed to get here before me and Devrim, even though we weren't that late. Nice to meet Greg again, and I've never med Heikki before. But they're both good pg hackers, and when you meet such people, interesting discussions are always going to happen.

Had a nice chat with a guy from Ingres, and also with some of the guys from fon. Jean-Paul led the track of OSS databases in the "commercial talks" before lunch. I'm told there was a very good talk on migration to PostgreSQL, but I didn't even bother pretending to go there since it was all in French.

And I got to do the good deed of the day fairly early - taught the salesguy from Continuent that there is no such thing as Postgre. There are many options for how to say it, but that's not one of them. And since he's selling a product based on it, he should know. Which he now does...

(Oh, Devrim - when will you fix the date problem on planet?)

More meetups happening tomorrow

So it looks like we'll have even more international PostgreSQL people showing up for SolutionsLinux tomorrow - Greg Stark and Heikki Linnakangas of EnterpriseDB UK should be showing up in the morning and hang out for a day. Not sure how long they'll be around in the evening, but it'll be nice getting a chance to meet them again.

And yes, we're back at the beer-bar with free WiFi - it helps when you don't have any in the hotel. The PostgreSQLFR guys just had their yearly meeting to approve next years plans and things like that. Unfortunately it was all in French, so I can't really comment on the contents.

And yes, this is very blog-intensive times. But I blame it all on Devrim, and maybe a little on the great elephant-cookies served in our booth.

Oh yeah, and Gavin - thanks, man. I'm sure you know what I mean. If not, you will soon enough...


I speak at and organize conferences around Open Source in general and PostgreSQL in particular.


PGConf.EU 2020
Oct 20-23, 2020
Berlin, Germany


Warsaw User Group
Jun 29, 2020
Virtual, Virtual
Postgres Vision
Jun 23-24, 2020
Online, Virtual
PGCon 2020
May 26-29, 2020
Online, Virtual
pgDay.paris 2020
Mar 26, 2020
Paris, France
Nordic PGDay 2020
Mar 24, 2020
Helsinki, Finland
More past conferences