1,659 reputation
23
bio website wiki.postgresql.org/wiki/…
location Madison, WI
age 59
visits member for 2 years, 7 months
seen Nov 8 at 14:58

I've been making my living working with computers since 1972. In 1980 I founded a consulting company I ran until 2005; during that time I worked with a wide variety of applications, organizations, and technical environments. I'm now with EnterpriseDB as a database architect. I'm a committer for the free, open source version of PostgreSQL, and an active member of that community.

By far the largest patch I've worked on for PostgreSQL has been the Serializable Snapshot Isolation (SSI) implementation which went into PostgreSQL version 9.1. This was a joint project with Dan R.K. Ports of MIT, with helpful input and support from many in the PostgreSQL community. Our paper on that effort can be found here:

http://vldb.org/pvldb/vol5/p1850_danrkports_vldb2012.pdf

For the PostgreSQL docs on the feature, see:

http://www.postgresql.org/docs/current/interactive/transaction-iso.html

For a number of examples see:

http://wiki.postgresql.org/wiki/SSI

More recently I've added support for creating and refreshing materialized views to PostgreSQL, and am in the process of adding support for incremental maintenance based on the view's declaration.


Apr
11
awarded  Yearling
Apr
11
awarded  Yearling
May
18
comment Should 'trivia' questions be off-topic
The odds are that the decision was made years ago at a user group meeting or over beers at a pub local to a conference. It's not that I feel all that strongly about including questions like that here, it just seems like some seem to be making assumptions about database development, support, and DBAs that don't hold for all products; so I'm trying to clarify a bit. If you want to build PostgreSQL and brand it with a different name and sell it commercially with your own logo you can. Less extreme, if a group of users wants to put up a PostgreSQL-related web site and use a new logo, they can.
May
18
comment Should 'trivia' questions be off-topic
I think this meta question was the result of the "PostgreSQL turtle" question. With PostgreSQL there is no company which controls such decisions; the members of the affected community can choose to promote PostgreSQL as they like, and the Japanese community chose to use a different symbol. The fact that they made such a decision and that no corporate approval was needed might, on it's own, be interesting to DBAs, as an insight into the nature of the product; or possibly to DBAs with some other cultural issue who might want to do something similar in their own community.
May
17
comment Should 'trivia' questions be off-topic
I think the key points here are whether the answer to the question would be interesting to many of the intended users of the site, whether it would be likely to not already be known to many of them, whether there it is indeed an answerable question, and whether such questions are posted in moderation. A site need not be dry to be useful. I've seen studies showing that breaks from dry content (in various forms) refresh the mind and improve people's problem-solving abilities. As long as it's the break and not the body of content. :-)
May
17
awarded  Supporter
May
17
awarded  Critic
Apr
11
awarded  Autobiographer