What I’m going to see at PostgreSQL Conference West

lifeline
“I’d like to use my lifeline to figure out what to go to at PostgreSQL Conference West…”*

PostgreSQL Conference West is coming up this October 10-12, and the schedule was just published. Unfortunately, it’s a little tricky to navigate the list of talks on the site, so I decided to post my itinerary to help you if you’re looking for a guide!

So, I cheated a little and included some things that I won’t be able to see – but there’s really a lot of good stuff.

I’m so happy to see so many Portland locals presenting at this conference! All the Portlanders called out below are members of PDXPUG. Our next meeting is on October 16, 2008, 7pm at FreeGeek.

It shows how strong our community is that we were able to support two PostgreSQL-specific conferences (the earlier was PDXPUG day before OSCON) IN PORTLAND this year!!! Yay for us.

Here’s what I’ll be attending:

Continue reading

Filesystem I/O at the Linux Plumbers Conference

http://osdldbt.sourceforge.net/dl380/4disk/sraid10/ext3/read-write/
graph from software raid, RAID10, no partition table, ext3, read-write load

If you haven’t heard, the Linux Plumbers Conference is happening September 17-19, 2008 in Portland, OR. It’s a gathering designed to attract Linux developers – kernel hackers, tool developers and problem solvers.

A few of us that met through the Portland PostgreSQL User Group (PDXPUG) pitched an idea for a talk on filesystem performance. We wanted to examine performance conventional wisdom and put it to the test on some sweet new hardware, recently donated for performance testing Postgres. We’re asking questions like: Is RAID5 really the worst performing configuration for a database? How much does partition alignment really matter? Is there one Linux filesystem that a DBA should always choose for best performance under any load? Is adaptive readahead all that?

Our talk was accepted, so we’ve been furiously gathering data, and drawing interesting conclusions, ever since. Gabrielle Roth and I are presenting, using the results of extensive testing conducted by Mark Wong, a database benchmarking expert and author of pg_top. We’ll be sharing 6 different assumptions about filesystem performance, tested on five different filesystems, under five types of loads generated by fio, a benchmarking tool designed by kernel hacker Jens Axboe to test I/O.

User Groups redux

lousy cup!
actually, i love this cup. thanks, eric! 🙂

It’s a bit late for an “announcement”, but Gabrielle and I are re-presenting the User Groups talk to the Portland Linux Users Group tonight. We’re all about audience participation, and so we’re going to focus on helping PLUG pick a few topics and presenters for upcoming meetings. And whatever else they want to talk about 🙂

Meeting starts at 7pm and here’s where:

Fariborz Maseeh College of Engineering & Computer Science Building
Room FAB 86-01 (This is in the basement.)
The building is on SW 4th across from SW College Street.
See location H-10 on map at http://pdxLinux.org/campus_map.jpg

Beer afterward at Jax!

Jax Bar And Restaurant
826 SW 2nd Avenue

Leaving US PostgreSQL Assoc. – what’s next for me?

A smiling pug
image credit to bugbunnybambam

A few weeks ago, I decided to resign from the United States PostgreSQL Association board. Shortly after, I left for a long vacation where I thought about what I wanted to do next – both professionally and in a volunteer capacity.

Looking back, I started volunteering for PostgreSQL two years ago. I’ve led PDXPUG, staffed many conference booths, given nearly a dozen talks and run conferences. Of the work I’ve done, I’ve been most surprised by the creation of the PUGS website and all the user groups that followed.

This may sound silly – but I was so incredibly proud to see user groups in Oklahoma, Toronto, Los Angeles and the D.C.-area (BWPUG) hold meetings, share their experiences and publish fantastic presentation slideshows. All while I was out of the country!

That’s a true sign of success to me: groups of people leading themselves and sharing their knowledge with each other. It’s open community, with minimal bureaucracy, and (I hope) maximum fun.

With that in mind, I’ve decided to make this next year’s volunteer work focused on a simple idea:

Enable people to connect and learn directly from each other.

So what you can expect from me over the next year is more of the same, but now with that end goal in mind: more PostgreSQL user groups (for as long as the postgresql.org folks would like me to stay), more ways to connect people directly to each other, more authentic community building through un-conferences, and more contributions – through code, testing and presenting of that work.

To give you an idea — here’s what I’m up to over the next couple of months:

  • Linux Plumber’s Conference, September 17-19 – with Gabrielle Roth, we’ll be presenting information about databases (PostgreSQL specifically) and filesystem performance using data gathered from the recently installed PostgreSQL performance lab.
  • PostgreSQL Conference West, October 10-12 – I’m not organizing this year, but I’m organizing a session on hacking PostgreSQL, led by some PostgreSQL hackers!
  • WhereCampPDX, October 17-19 – I’m helping organize this un-conference for geography-specific tech – practicioners, professionals, enthusiasts, artists! We’ve got some great ideas and hope to publish details in the next week about the awesome folks involved, the venue and the parties!

Hope to see you at these events!

I haven’t talked about my work much in this blog, and probably will continue not to do that much here – but I also wanted to share that I’ve taken a position with End Point Corporation, a fantastic company that works on open source software, and provides support for PostgreSQL. I’ll be focusing on PostgreSQL, and doing a little Perl development here and there.

Pluggable architecture, not just for code

hands

photo from Chris Zakorchemny

One OSCON session that made me think was “Does Open Source need to be organic?” The panel contained Brian Aker (MySQL), Rob Lanphier (Linden Lab), Stephen O’Grady (Redmonk), Theodore Ts’o (Linux Foundation). The session was less about business vs. community, and more about how to increase community involvement in your projects.

Brian Aker mentioned Launchpad, and the way that it handles code forks. Forks are integrated into the system using a new revision control system – Bazaar. The forks are front and center – allowing all developers on the project to add forks and update them, incorporating them in with the primary code distribution point. This model reinforces the idea that forks are natural and can be positive evolutions in open source projects.

My big take-away: If you want to increase community contribution to open source projects, provide public and easy-to use interfaces. Publish your API early and create pluggable interfaces! Let developers add functionality and publish their add-ons easily, both in your project’s development space and on their own.

The same principal can be applied to the people side of open source projects. In your organization, make roles, tasks and responsibilities transparent. Let everyone – inside AND outside the project – know what they could be doing to get things done. The mistake that many projects make is assuming that people know what they could be doing.

Think of the people-side of projects the same way as you think about the code. Documented APIs are the same as public mailing lists, blog entries and wikis that reveal what your organization is actually doing, and how new people can get involved. Roles and titles that are meaningful let people know who they should bring their ideas to. And that lowers barriers to participation.

Leadership is not just telling people what to do – it’s inspiring, facilitating and then getting out of the way of people who are willing and capable of doing things on their own. Community grown from inspiration, and then fed by encouragement, fun and recognition of accomplishment, are the ones that last. And these communities are the ones that I want to be part of.

Running a Successful User Group

running a successful user group

After the People For Geeks talk, I presented “Running a Successful User Group” with Gabrielle Roth on Wednesday. You can find our slides and our presentation handout over on Bacon and Tech. The handout is pretty cool, take a minute and print it out!

FOSCON Live Coding competition

The Portland Ruby Brigade is cooking up a great FOSCON this year, hosted at Cubespace. It’s all happening on Wednesday, July 23, 2008 from 6pm-9pm.

I’m going to miss some of FOSCON this year, but I’m hoping to catch some of the Live Coding Competition. In Drupal’s corner, Jakob Perry (of Ubercart fame) is leading the charge with Joshua Brauer. Ruby on Rails will be represented, as will a couple other web frameworks or content management system.

Rumor has it, Jakob and Joshua are going to rock this competition. If you’re a Drupal enthusiast, see if you can make it over to Cubespace to cheer them on Wednesday.

PDXPUG Day on July 20 – Register now!

pgday 2007

photo courtesy of Dan Browning

Registration for PDXPUG Day on July 20, 2008 is open! Please sign up and let us know what size t-shirt you’d like. We’re requesting a $20 donation (by cash or check) at the door. All proceeds to to Software in the Public Interest, a 501(c)3 organization that is used to fund PostgreSQL advocacy.

Registration for OSCON is not required to attend.

Registering also gets you in the door at the Gotham Tavern, our after-party location close to the convention center!

Our line-up of talks includes:

PostgreSQL Unit Testing with pgTAP – David Wheeler
Inside the PostgreSQL Shared Buffer Cache – Greg Smith
Muldis D – Portable Databases At Full Power – Darren Duncan
A Streaming Database Talk – Rafael J. Fernández-Moctezuma
Using GLORP to connect Squeak Smalltalk to PostgreSQL – RandalSchwartz
Fighting Disease with PostgreSQL Full Text Search and JRuby on Rails – Mike Herrick
All Your GIS Are Belong to You – Abe Gillespie
What’s PgUS – Joshua Drake

Sign up today!

Drupal + PostgreSQL: review some patches, folks!

baseball bat
am i the girl, the bat or the heart? you decide!

I’ve been working on a site that uses Drupal for a few months now. And I’m living dangerously with CCK, Views and, as of last week, Organic Groups.

I found this sharp moderation module (Modr8) last week, and then quickly realized that I wanted to be able to provide this moderation tool any conferences that wanted it! Enter the Organic Groups.

I’m using PostgreSQL for the back-end database, and so I’m used to being a second-class database citizen in Druplandia. This means that I frequently have to patch modules so that they use SEQUENCE instead of AUTO_INCREMENT, or get rid of the (8) after an INT type. So, when Organic Groups and the og_modr8 modules caused this bug to rear up, and I suddenly had a full-scale “blogs running backwards” problem on my hands, I wasn’t surprised.

Thank goodness for Brenda Wallace’s patch, which fixed everything up a short while later. What got me, however, was that the problem has had a fix (although not Brenda’s ultimate patch) for over a year, but it hasn’t been added to core. Particularly when the problem causes nodes to be presented out of order, site-wide.

Apparently there’s a shortage of PostgreSQL reviewers in the Drupal community.

Fortunately, if you’d like to help get patches applied to core, there’s a page of Patches To Be Reviewed, and a few people are trying to add a postgresql tag to bugs. If you’re a Drupaler and use PostgreSQL, please take a few minutes to review a patch.