PgCon 2012 Developer Meeting
From PostgreSQL wiki
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 (firstname.lastname@example.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.
Time & Location
The meeting will be from 8:30AM 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.
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.
|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|