PgCon 2012 Developer Meeting
From PostgreSQL wiki
|Line 125:||Line 125:|
|09:00 - 09:30
|09:00 - 09:30
|Goals for 9.3
|Goals for 9.3
Revision as of 12:51, 9 May 2012
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 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.
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
|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|