twittering on 2010-05-22

Lightning talks from PgCon 2010

Thanks again to all the folks that volunteered to give five minute talks during the Lightning talks session at PgCon!

Our lightning talks this year were:

  • PostgreSQL Developer Meeting in Five Minutes – Bruce Momjian
  • Slony 1 => 2.0 – Steve Singer
  • PostgreSQL and Twisted – Jan Urbanski
  • The FlyMine Project – Matthew Wakeling
  • Enhanced Tools for PostgreSQL – Tomonari Katsumata
  • Servoy – Christophe Pettus
  • Tail_n_mail – Greg Sabino Mullane
  • GSOC – Robert Treat
  • Pg Staging – Dimitri Fontaine
  • Serializable Transaction Isolation – Kevin Grittner
  • 10 ways to wreck your database – Josh Berkus

All presentations are downloadable from: http://wiki.postgresql.org/wiki/PgCon_2010_Lightning_talks

Image Copyright © 2010 Richard Guy Briggs from here and used by permission.

twittering on 2010-05-21

  • mongodb: "running with scissors by default" -@Crad #pgcon #
  • New config options 4 hot standby: wal_level – controls what gets logged in the write ahead log; max_wal_senders – match #of standbys #pgcon #
  • New config opts 4 hot standby: max_standby_delay – how long 2 wait before killing conflicting queries on standby #pgcon #
  • New config opts 4 hot standby: wal_keep_segments – number of wal segments to preserve before recycling during streaming rep #
  • excited to hear that @ahockley is organizing a photowalk during @osbridge. #
  • OH: "I've poked the system and threatened it with a rewrite in Haskell." #
  • listening to Greg Smith go over what the heck datums are in pg core code #pgcon #
  • Listening in on Cedric's explanation of pgfincore: http://pgfoundry.org/projects/pgfincore/ #
  • settling in to heckle @robertmhaas about the query planner #pgcon #
  • fun @enterprisedb party. great to meet karen, spend some time with @timbunce and generally make trouble. yay! #pgcon #

Need reviewers – preparing for the first commitfest for 9.1

Now is the perfect time to get involved in Postgres development!

Starting June 15, we’re going to have a “reviewfest”, as a prelude to the first commitfest in July. We’ve already got 28 patches in the queue, and all need reviewers.

Think you’re not qualified to review patches? Think again!

From the Reviewing a Patch documentation:

If you can apply a patch and you can use the new feature, you’re already qualified to start reviewing it.

We will formally kick off a reviewfest on June 15.

We will assign reviewers and get all the patches that are queued up for 9.1 reviewed while the final touches are being applied to the 9.0 release. Have a look at Review A Patch guidelines for information about how to conduct your review. We also have a mailing list to track and recruit reviewers – pgsql-rrreviewers. (The extra R’s are for ’round-robin’)

Please subscribe to the list, and post if there is a particular patch you are interested in reviewing!

twittering on 2010-05-20

  • /me just shook Marc Fournier's hand. #pgcon #
  • all Gregs have arrived at the developer meeting. #pgcon #
  • Rousing approval for alpha release process! yay for @petereisentraut and others who worked on making this happen last year #pgcon #
  • CVS to GIT throwdown about to start. #pgcon #
  • OMG PostgreSQL is moving to git! august/september-ish! #pgcon #
  • listening to koichi-san talk about snapshot cloning #pgcon #
  • now talking about a generalized data queue inside of Postgres http://tinyurl.com/2b8st6k #pgcon #
  • ideas being floated for exposing transaction commit order to client applications (make it lookup-able by LSN?) #pgcon #
  • and now we're talking about DDL triggers with Jan Wieck #ftw #pgcon #
  • a status report on modules (except we call them extensions now) from Dimitri Fontaine #pgcon #
  • looks like Jan is going to pursue DDL trigger-ish functionality through existing code hooks. #sweet #pgcon #
  • hearing about SQL/MED and plans to move forward – making dblink extensible, COPY FROM and planner support (tweak of relkind) #pgcon #
  • Postgres yearly developer meeting! http://tinyurl.com/2a7ps6q #pgcon #

twittering on 2010-05-20

  • /me just shook Marc Fournier's hand. #pgcon #
  • all Gregs have arrived at the developer meeting. #pgcon #
  • Rousing approval for alpha release process! yay for @petereisentraut and others who worked on making this happen last year #pgcon #
  • CVS to GIT throwdown about to start. #pgcon #
  • OMG PostgreSQL is moving to git! august/september-ish! #pgcon #
  • listening to koichi-san talk about snapshot cloning #pgcon #
  • now talking about a generalized data queue inside of Postgres http://tinyurl.com/2b8st6k #pgcon #
  • ideas being floated for exposing transaction commit order to client applications (make it lookup-able by LSN?) #pgcon #
  • and now we're talking about DDL triggers with Jan Wieck #ftw #pgcon #
  • a status report on modules (except we call them extensions now) from Dimitri Fontaine #pgcon #
  • looks like Jan is going to pursue DDL trigger-ish functionality through existing code hooks. #sweet #pgcon #
  • hearing about SQL/MED and plans to move forward – making dblink extensible, COPY FROM and planner support (tweak of relkind) #pgcon #
  • Postgres yearly developer meeting! http://tinyurl.com/2a7ps6q #pgcon #

PgCon Day 1: Developer meeting

Jan, talking about DDL triggers

I’m back from the developer meeting where we blasted through eight hours of presentations and discussions from key members of the PostgreSQL developer community.

One great outcome from the meeting is that WE ARE MOVING TO GIT.

There’s lots of other great stuff on that wiki notes – like a list of possible features for 9.1, plans for DDL triggers, and a continued discussion of snapshot cloning.

There was also much approval voiced for the alpha process that Peter Eisentraut championed last year.

I volunteered to steer our next “reviewfest” – kicking off June 15! And I’m trying to rope another developer into the next commitfest, which we anticipate starting on July 15. The plan is to stick with our development schedule from last year.

And I’m working with Josh Berkus to put together an open issues list for 9.0. I think I went a bit overboard, and many of the things I listed are probably resolved – hopefully committers will make quick work of the list, and we’ll be speeding along toward releasing 9.0 in June!

I missed out on the group picture, so I look forward to someone’s photo editing efforts in the near future. :)

CivicIdeas for greater portland meetup May 27th, 6-8pm

From: http://civicapps.org/news/important-upcoming-events-civicapps

CivicApps Ideas scheduled for Thursday, May 27th, at the Portland Building Auditorium is a two-hour discussion of ideas and datasets between data providers and citizens. As a precursor to the CiviCode Day Event, scheduled one week later at Open Source Bridge, this meeting is your chance to initiate the discussion surrounding your project ideas and data needs with others.

Join us -> http://civicideas.eventbrite.com/