PgCon 2012 Developer Meeting

From PostgreSQL wiki

Revision as of 12:51, 9 May 2012 by Dpage (Talk | contribs)

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 (dpage@pgadmin.org).

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.

Contents

Time & Location

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

Novotel Ottawa
33 Nicholas Street
Ottawa
Ontario
K1N 9M7

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

View on Google Maps

Attendees

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
  • Priorities for 9.3 [All]
    • Description: discuss what people are working on and what's likely to be in 9.3.
    • Goals: set expectations and coordinate work schedules for 9.3.
  • 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
  • The MERGE statement: 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?
  • Summarise Commitments at End of Play [Simon]
    • For roadmap and planning purposes, confirm who is doing what, assign interested reviewers at start
    • Check gaps, identif priorities early on in cycle

Agenda

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

Minutes

Personal tools