PgCon 2012 Developer Meeting

From PostgreSQL wiki
Revision as of 03:29, 10 May 2012 by Gsmith (talk | contribs) (Rearrange to put longer "Goals.." section at end)
Jump to: navigation, search

A meeting of the most active PostgreSQL developers is being planned for Wednesday 16th May, 2012 near the University of Ottawa, prior to pgCon 2012. In order to keep the numbers manageable, this meeting is by invitation only. Unfortunately it is quite possible that we've overlooked important code developers during the planning of the event - if you feel you fall into this category and would like to attend, please contact Dave Page (

Please note that this year the attendee numbers have been cut to try to keep the meeting more productive. Invitations have been sent only to developers that have been highly active on the database server over the 9.2 release cycle. We have not invited any contributors based on their contributions to related projects, or seniority in regional user groups or sponsoring companies, unlike in previous years.

This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.

Time & Location

The meeting will be from 9AM to 5PM, and will be in the "Red Experience" room at:

Novotel Ottawa
33 Nicholas Street
K1N 9M7

Food and drink will be provided throughout the day, including breakfast from 8AM.

View on Google Maps


The following people have RSVPed to the meeting (in alphabetical order, by surname):

  • Oleg Bartunov
  • Josh Berkus (Secretary)
  • Jeff Davis
  • Andrew Dunstan
  • Dimitri Fontaine
  • Stephen Frost
  • Peter Geoghegan
  • Kevin Grittner
  • Robert Haas
  • Magnus Hagander
  • Shigeru Hanada
  • Hitoshi Harada
  • KaiGai Kohei
  • Tom Lane
  • Noah Misch
  • Bruce Momjian
  • Dave Page (Chair)
  • Simon Riggs
  • Teodor Sigaev
  • Greg Smith

Proposed Agenda Items

Please list proposed agenda items here:

  • Agree CommitFest schedule for 9.3 (Strawman from Simon)
    • CF1 June 15, 2012 - 1 month
    • CF2 Sep 15, 2012 - 1 month
    • CF3 Nov 15, 2012 - 1 month
    • CF4 Jan 15, 2013 - 2 months
  • Queuing [Dimitri, Kevin]
    • Description: efficient and transactional queuing is a very common need for application using databases, and could help implementing some internal features
    • Goals: get an agreement that core is the right place where to solve that problem, and what parts of it we want in core exactly
  • Materialized views [Kevin]
    • Description: Declarative materialized views are a frequently requested feature, but means many things to many people. It's not likely that an initial implementation will address everything. We need a base set of functionality on which to build.
    • Goals: Reach consensus on what a minimum feature set for commit would be.
  • Partitioning and Segment Exclusion [Dimitri]
    • Description: to solve partitioning, we need to agree on a global approach
    • Goals: agreeing on SE as a basis for better partitioning, having a "GO" on working on SE
  • MERGE: Challenges and priorities [Peter G]
    • Description: Implementing the MERGE statement for 9.3. It is envisaged specifically as an atomic "upsert" operation.
    • Goals: To get buy-in on various aspects of the feature's development, and, ideally, to secure reviewer resources or other support. Because of the complexity of the feature, early interest from reviewers is preferable.
  • Row-level Access Control and SELinux [KaiGai]
    • Security label on user tables
    • Dynamic expandable enum data types
    • Enforcement of triggers by extension
  • Enhancement of FDW at v9.3 [KaiGai]
    • Writable foreign tables
    • Stuffs to be pushed down (Join, Aggregate, Sort, ...)
    • Inheritance of foreign/regular tables
    • Constraint (PK/FK) & Trigger support.
  • Type registry [Andrew]
    • Provide for known OIDs for non-builtin types, and possibly for their IO functions too
    • Would make it possible to write code in core or in extension X that handles a type defined in extension Y.
  • Ending CommitFests in a timely fashion, especially the last one. Avoiding a crush of massive feature patches at the end of the cycle. Handling big patches that aren't quite ready yet. Getting more people to help with patch review. [Robert]
  • What Developers Want [Josh]
    • Description: a top-5 list of features and obstacles to developer adoption of PostgreSQL (with slides)
    • Goal: to set priorities for some features aimed at application users
  • In-Place Upgrades & Checksums [Greg Smith, Simon]
    • Description: Revisit in-place upgrades of the page format, now that pg_upgrade is available and multiple checksum implementations needing it have been proposed.
    • Goal: Nail down some incremental milestones for 9.3 development to aim at.
  • Autonomous Transactions [Simon]
    • Overview of idea, relationship to stored procedures
    • Feedback, buy-in and/or alternatives
  • Parallel Query [Bruce Momjian]
    • Hope to get buy-in for what parallel operations we are hoping to add in upcoming releases
  • Report from Clustering Meeting [Josh] (10 min)
    • Description: to summarize the discussions of the cluster-hackers meeting from the previous day
    • Goal: inter-team synchronization. Possibly, decisions requested on specific in-core features.
  • Double Write Buffers [Simon]
    • Is anyone committing to do that for 9.3?
  • Goals, priorities, and resources for 9.3 [All]
    • For roadmap and planning purposes, set expectations and coordinate work schedules for 9.3. Confirm who is doing what, identify interested reviewers at start, and check for gaps.


Time Item Presenter
08:00 Breakfast
08:30 - 08:45 Welcome and introductions Dave Page
08:45 - 09:15 Autonomous transactions Simon Riggs
09:15 - 09:40 Queuing Dimitri Fontaine/Kevin Grittner
09:40 - 09:50 Report from the Clustering Meeting Josh Berkus
09:50 - 10:10 Type registry Andrew Dunstan
10:10 - 10:30 Access control and SELinux KaiGai Kohei
10:30 - 10:45 Coffee break
10:45 - 11:15 Enhancement of FDWs in 9.3 KaiGai Kohei
11:15 - 11:30 What developers want Josh Berkus
11:30 - 12:00 Parallel Query Bruce Momjian
12:00 - 12:30 MERGE: Challenges and priorities Peter Geoghegan
12:30 - 13:30 Lunch
13:30 - 14:00 Materialised views Kevin Grittner
14:00 - 14:20 In place upgrades and checksums Simon Riggs/Greg Smith
14:20 - 14:45 Partitioning and segment exclusion Dimitri Fontaine
14:45 - 15:00 Commitfest Schedule All
15:00 - 15:15 Tea break
15:15 - 15:40 Commitfest management Robert Haas
15:40 - 16:45 Goals, priorities, and resources for 9.3 All
16:45 - 17:00 Any other business/group photo Dave Page
17:00 Finish