Category Archives: postgresql

community, open source, pdxpug, postgres, postgresql, user groups , , , , , ,

A year of PDXPUG

Last year was the third year that PDXPUG has been operating in Portland, and I decided to look back at our year of meetings. Here goes:

January 11 – 10 things you can use in PostgreSQL 8.3
February 26 – Extreme Database Makeover: RT
March 20 – Managing Internet Services: Using the right tool for the job
April 17 – Rails on PostgreSQL
May 15 – PostgreSQL for Pythoneers
June 19 – The relational model
July 20 – PDXPUG DAY!, and the schedule
August 21 – Tsearch2 and Materialized Views (Guest speaker from Seattle!!)
September 18 – The Visual Planner
October 16 – Point In Time Recovery
November 20 – Reviewed 8.4 features with the help of depesz’s blog
December – Coder’s Social

Thanks everyone who gave talks and attended meetings! User groups are only as good as the people who participate in them, and this list shows just how talented, diverse and fun the Postgres community is in Portland. I love you guys!

Looking forward – once again, we’ve already scheduled talks through the next four months! I feel like the group is running on its own momentum, and that is a fabulous feeling. We have a data visualization talk, another Extreme Database Makeover, and hopefully a presentation about teaching database theory with PostgreSQL.

Our next meeting is on January 15, 7pm with Stephen Jazdzewski traveling all the way from Eugene to present SplendidCRM, a formerly Microsoft SQL-only system that is now compatible with PostgreSQL. I am happy to see more of our Microsoft colleagues joining and presenting to the user group communities, as I’ve always felt they are underrepresented in our groups. Also, I’m happy to host another out-of-town presenter here in Portland! Hope to see you on the 15th.

postgres, postgresql , , , ,

Postgres mailing list traffic over time

Code vs. Docs

Graph by Magnus Hagander

Spurred on by Bruce’s recent blog post, I spotted a fun thread on pgsql-general:

http://archives.postgresql.org/pgsql-general/2008-11/msg01026.php

A few core contributors have been examining their archives and speculating why it is that some feel that they can’t keep up with mailing list traffic as well as they used to.

Reasons tossed around included:

  • More people involved
  • More patches
  • Contributors are just getting older
  • More in-depth questions. Tom said: “Fewer, How do you pronounce Postgres? and more, Explain the various isolation levels for transactions and how does that affect my particular situation?”

Out came the graphs! Tom Lane kicked things off initially with a plot of mailing list messages since 1998:

Tom Lane

I shared one of Magnus’ graphs about Code vs. Documentation at the top. There are several more graphs shared in that thread that are worth checking out, along with pointers to resources like MarkMail, graphs from Ron Mayer, and Ohloh. Enjoy!

community, conference, gender, open source, postgres, postgresql, womenintech , , , , , , , , 7 Comments

Mentor Summit Report for PostgreSQL

mentor summit

Update: Fixed the etherboot wiki link.

I attended the Google Summer of Code Mentor Summit this past weekend on behalf of PostgreSQL. We met at the Google campus in Mountain View.

This event was an unconference and so, none of the sessions were determined in advance.

Some of the highlights were:

  • Leslie Hawthorn and Chris DiBona went into some detail with the whole group about the selection process for GSOC. This session made me feel as though PostgreSQL had relatively good chances for being accepted again next year. Google, however, does not pre-announce projects/products, so there is no sure thing about our (or any other project’s) involvement.
  • I met MusicBrainz guys and was pleased to receive many bars of chocolate they requested to be distributed to SFPUG and PDXPUG members as thanks for making an great database.
  • Attended three sessions concerning recruitment and retention of students. This is a topic that many people were interested in, but that few people feel they have a proper strategy for.

I also led a session on recruitment and retention of students to open source projects. Some of the ideas that came out of that and the related sessions were:

  • Determine what makes you personally need to be part of Postgres (joy of learning, scratching a technical itch, making a tool for your job, fame). Find out which of those things your student also needs or wants and try to give that or help your student achieve that thing.
  • Have a clearly defined method for students to keep journals. Several projects simply used MediaWiki and templates.
  • Use git (or other distributed revision control), and have students commit early and often to a branch that mentors have access to.
  • The Etherboot project has a great system: http://etherboot.org/wiki/soc/2008/start
  • Hold weekly meetings over IRC. These can be brief, but help get students accustomed to your project’s culture and way of doing things.
  • Ask the student: “are you on track?”, ask the mentor: “do you think the student is on track?” on a weekly basis
  • If you want students to stick around, find incremental responsibilities to assign that are driven by their enthusiasm.
  • Interview on the phone all your students ahead of time, not just the ones you think might be a problem.
  • Require a phone number on the application for the student.
  • Require a secondary contact so that if the student “disappears” there’s a backup person to contact. (and contact that person BEFORE SoC starts)

I made good connections with members of Git, Parrot, WorldForge, Ruby and many other community leaders. I was particularly impressed by the ideas and stories from the current Debian project leader, Steve McIntyre and Gentoo council member Donnie Berkholz. Donnie recommended some books about recruitment that I plan to read and review in the next few weeks.

The issue of mailing list moderation and the number of people required to keep mailing lists functioning properly came up frequently. If you know a moderator for a Postgres mailing list, please consider thanking them for doing a very tedious, extremely important and often thankless job.

I also spent some time discussing with Leslie Hawthorn and Cat Allman how to increase the total number of women mentors and students next year. Leslie and I shared some ideas and I offered to help implement them next year. One thing the crowd asked for was explicit training on how to recruit and manage female students. Realistically, this information will apply to all students, and I hope this training helps us recruit more students overall.

I thought the conference went quite well. I hope PostgreSQL is accepted next year, and that one of our mentors is able to attend this conference. And, if you go, be sure to register for the hotel early, and stay at the Wild Palms.

conference, european union, international, italy, postgres, postgresql , , , ,

PgDay EU – Best conference ever?

PgEU conference Photo
Smiling, PostgreSQL-using conference goers

Anyone who went will likely tell you how much they enjoyed PGDay EU 2008. My biggest regret this year is that I was unable to attend.

Magnus Hagander’s Planet blog is still missing, so I’m blogging the link to his fabulous photos for him. If you see any pictures with missing names or labels, please let him know at magnus -at- hagander (dot) net.

This conference was once again led by Gabriele Bartolini, and a large supporting team – including the other board members of PgEU – Magnus Hagander, Jean-Paul Argudo and Andreas Scherbaum. PgEU (for those that don’t know) is a non-profit dedicated to promoting PostgreSQL in European nations. Next year, this conference will be held somewhere in France! Stay tuned to planet.postgresql.org for details!

Update:

My favorite photo:
lolcats and greg stark

community, conference, pgconference, postgres, postgresql , , , , 2 Comments

October is a month of many conferences

wherecamp

I just blogged about WhereCampPDX, and am enjoying a few days of quiet before heading out to Google for the Summer of Code Mentor’s summit this coming weekend.

I was so busy I didn’t have much time to blog about the PostgreSQL Conference West. It was great to see everyone, and I came away more sure than ever that PostgreSQL has the best developer and user community. We had so much fun, and I really enjoyed seeing the creative ways people are using PostgreSQL – for business (Proprietary to PostgreSQL), education (Visual Planner) and as a hobby (PL/LOLCODE).

WhereCampPDX was amazing! I had a couple fantastic conversations with Webb Sprague, a regular PostGIS presenter for PDXPUG and Portland PostgreSQL conferences. He’s interested in getting people together to talk about anthropology and tech, and how to better meet the needs of the people who will actually end up using disaster management software in a crisis. Look for a fabulous event from him this spring!

As far as GSOC, I’m hoping to take a lead role in this next year with Josh Berkus‘ help. He’s managed Summer of Code for at least two years, and has worked hard to match mentors and students, and we’ve ended up with several excellent contributions.

My plan for PostgreSQL is to start early on recruitment and project proposals, so that we have an excellent turnout next year. So, if you know of a project you want worked on, or know of students who would be good candidates – let’s get in touch now and start recruiting!

conference, postgres, postgresql, user groups , , , ,

PostgreSQL Conference: Friday night dinner

taking shots
How to have fun, PostgreSQL-style

Those of you in town on Friday evening are welcome to join us at Paddy’s at 6pm for dinner:

Paddy’s Bar & Grill
65 SW Yamhill St
Portland, OR 97204

The reservation is under ‘Selena’, and we’ll be sitting in the front. The MAX runs directly in front of the restaurant.

Food is good – vegetarian-friendly, but not necessarily vegan or gluten-free. Those looking for those types of food options, let me know – there are actually excellent places nearby to eat, and you could join us a little later for socializing after a proper meal.

I’ll be directing those that want dinner at the Code Sprint over there – so I asked for 20 seats. Please comment or email me if you plan to attend, so that I can ask for more space if we fill up.

This isn’t a sponsored dinner – so we’ll all go dutch, unless a generous member of a company would like to sponsor us 🙂

I imagine several members of PDXPUG will be there. Can’t wait to see you all!

conference, portland, postgres, postgresql , , , , 2 Comments

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 →

postgres, postgresql, presentation, speaking , , , , , , 1 Comment

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.

community, open source, postgres, postgresql , , , , , 3 Comments

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.