PgCon 2012 Developer Meeting

From PostgreSQL wiki

Revision as of 10:18, 5 May 2012 by Simon (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 (

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, 2012 - 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]
  • 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]
  • 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 Subtransactions [Simon]
  • 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.


Time Item Presenter
08:00 Breakfast
08:45 - 09:00 Welcome and introductions Dave Page
10:30 - 10:45 Coffee break
12:30 - 13:30 Lunch
15:00 - 15:15 Tea break
16:45 - 17:00 Any other business/group photo Dave Page
17:00 Finish


Personal tools