http://wiki.postgresql.org/index.php?title=Special:Contributions&feed=atom&target=DpagePostgreSQL wiki - User contributions [en]2013-05-24T12:05:02ZFrom PostgreSQL wikiMediaWiki 1.15.5-2squeeze5http://wiki.postgresql.org/wiki/PgCon_2013_Developer_MeetingPgCon 2013 Developer Meeting2013-05-22T17:26:15Z<p>Dpage: /* Proposed Agenda Items */</p>
<hr />
<div>A meeting of the most active PostgreSQL developers is being planned for Wednesday 22nd May, 2013 near the University of Ottawa, prior to pgCon 2013. 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). <br />
<br />
Please note that this year the attendee numbers have been kept low in order 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.3 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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 8:30AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Josh Berkus (secretary)<br />
* Jeff Davis<br />
* Andrew Dunstan<br />
* Peter Eisentraut<br />
* Dimitri Fontaine<br />
* Andres Freund<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Robert Haas<br />
* Magnus Hagander<br />
* KaiGai Kohei<br />
* Alexander Korotkov<br />
* Tom Lane<br />
* Fujii Masao<br />
* Noah Misch<br />
* Bruce Momjian<br />
* Dave Page (chair)<br />
* Simon Riggs<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* 9.4 Commitfest schedule and Commitfest tools.<br />
* [http://wiki.postgresql.org/wiki/Parallel_Query_Execution Parallel Query Execution] (Bruce, Noah)<br />
* logical changeset generation review & integration (Andres)<br />
* utilization of upcoming non-volatile RAM device (Kaigai)<br />
* pluggable plan/exec nodes (Kaigai)<br />
** to offload targetlist calculation, sorting, aggregates, ...<br />
* [[GIN generalization]] (Alexander)<br />
* An Extensibility Roadmap (dim) (http://pgsql.tapoueh.org/temp/extensibility.pdf) (15 min)<br />
* Representing severity - derive severity from SQLSTATE (Peter Geoghegan - see http://www.postgresql.org/message-id/CA+TgmoZEjq7va+SfDZQwk6E4emEWThENNyxfqEGhB3iuoT1OJw@mail.gmail.com) (10 min)<br />
* Error logging infrastructure - store normalized statistics about errors in a circular buffer (Peter Geoghegan). Arguably this could be discussed alongside SQLSTATE item. (10 min)<br />
* Failback with backup (Fujii Masao - related discussion is: http://www.postgresql.org/message-id/CAF8Q-Gxg3PQTf71NVECe-6OzRaew5pWhk7yQtbJgWrFu513s+Q@mail.gmail.com)<br />
* Volume Management (Stephen Frost - wiki page will be forthcoming before the meeting)<br />
* AXLE Project - Big data analytics for Postgres (Simon Riggs) - an overview of the feature plan, how project works and what community can expect (15 min)<br />
* Incremental maintenance of materialized views (Kevin) - differential REFRESH and infrastructure for ''counting'' algorithm (30 min)<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:30 - 08:45<br />
|Welcome and introductions<br />
|Dave Page<br />
<br />
|-<br />
|08:45 - 09:45<br />
|Parallel Query Execution<br />
|Bruce/Noah<br />
<br />
|-<br />
|09:45 - 10:15<br />
|Pluggable plan/exec nodes<br />
|KaiGai<br />
<br />
|-<br />
|10:15 - 10:30<br />
|Volume Management<br />
|Stephen Frost<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
<br />
|-<br />
|10:45 - 11:00<br />
|Utilization of upcoming non-volatile RAM devices<br />
|KaiGai<br />
<br />
|-<br />
|11:00 - 11:30<br />
|Logical changeset generation review & integration<br />
|Andres<br />
<br />
|-<br />
|11:30 - 11:40<br />
|Representing severity<br />
|Peter G.<br />
<br />
|-<br />
|11:40 - 11:50<br />
|Error logging infrastructure<br />
|Peter G.<br />
<br />
|-<br />
|11:50 - 12:30<br />
|Incremental maintenance of materialized views<br />
|Kevin<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
<br />
|-<br />
|13:30 - 14:15<br />
|GIN generalization<br />
|Alexander<br />
<br />
|-<br />
|14:15 - 14:30<br />
|An Extensibility Roadmap<br />
|Dimitri<br />
<br />
|-<br />
|14:30 - 15:00<br />
|Failback with backup<br />
|Fujii<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
<br />
|-<br />
|15:15 - 15:45<br />
|9.4 Commitfest schedule and tools<br />
|Josh<br />
<br />
|-<br />
|15:45 - 16:45<br />
|Goals, priorities, and resources for 9.4<br />
|All<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}<br />
<br />
== Notes ==<br />
<br />
Attending:<br />
<br />
* Dave Page, EnterpriseDB<br />
* Andres Freund, 2ndQuadrant<br />
* Kevin Grittner, EnterpriseDB<br />
* Dimitri Fontaine, 2ndQuadrant<br />
* Andrew Dunstan, PostgreSQL Experts<br />
* Noah Misch, EnterpriseDB<br />
* Bruce Momjian, EnterpriseDB<br />
* Fujii Masao, NTT Data<br />
* Tom Lane, Salesforce<br />
* Magnus Hagander, Redpill Linpro<br />
* Robert Haas, EnterpriseDB<br />
* Josh Berkus, PostgreSQL Experts<br />
* Kaigai Kohei, NEC<br />
* Jeff Davis, Teradata<br />
* Alexander Korotkov<br />
* Peter Geoghegan, Heroku<br />
* Peter Eisentraut, Meetme<br />
* Stephen Frost<br />
<br />
=== Parallelism ===<br />
<br />
Bruce Momjian is looking at where Postgres is and hardware changes, and it's time to look at parallelism. Unlike the Windows port and pgUpgrade, there's no clear "done" with Parallelism. We're going to have to do a lot of small things, but not one big feature. Concern anout code cleanliness and stability. What is going to have to happen is that we'll attack one small thing, and build the infrastructure for parallelism.<br />
<br />
Robert Haas is talking about EnterpriseDB's commitment to parallelism. The two things EDB wants is materialized views and parallel query. The way we're approaching this is the same way as 2Q approached logical replication for the last release cycle. We're doing this as a company, and we have buy-in from our management. So far there's a wiki page on parallel sort and Noah's posted some stuff to pgsql-hackers. The first part is to get a credible worker system in place, and then we can tackle parallelising particular things.<br />
<br />
Stephen Frost pointed out that users are currently ad-hoc implementing parallelism in their middleware code. Bruce said that there was a basic set of steps for all parallel tasks. There's a false sense that threads automatically give you infrastructure for parallelism. Bruce doesn't think that's true. Having the worker/marshalling stuff sprinkles all over the code would be really bad, so we want central infrastructure.<br />
<br />
Jeff Davis pointed out that there were different approaches to parallelism. One is "cluster parallelism". Do we know what approaches were taking? Cluster parallelism involves making the parallel tasks according to data partitions. It's popular in data warehousing. Robert Haas doesn't expect to get that far in one release cycle.<br />
<br />
Haas: People come up with great ideas for PostgreSQL, and they do two things: either they figure out how to do it without modifing the query planner, or they fail. So we looked at index building, which wouldn't require dealing with the query planner. But the general problem of parallel query planning, we have to solve harder problems. I don't want to get bogged down in those sorts of questions at the outset, because there's a bunch of stuff to get done to execute parallel jobs in general.<br />
<br />
Josh Berkus suggested implementing a framework for parallel function execution because then users could implement parallel code for themselves. It would help the Geo folks. Noah thinks this is possible today, but isn't specific how. Tom argues against exposing it to users in early iterations because the API will change.<br />
<br />
There's a few things you need:<br />
* and efficient way for passing data to the parallel backends, probably using a shared memory facility, because sockets are too slow.<br />
* some logic for starting and stopping worker processes. Custom background workers aren't quite what we need for this. Also different from Autovacuum, which is a bit kludgy.<br />
* you need to be able to do stuff in the worker processes as if they were the parent process. They need to share the parent worker's state, and there are a lot of state things which are not shared. If the master takes new snapshots or acquires extra XIDs, not sure how to share that. Some things will need to be prohibited in parallel mode. Threads don't solve this. Syscache lookups are also a problem, but we need them.<br />
<br />
Noah wants to target parallel sort, specifically parallel memory sort. This hits a lot of the areas we need to tackle to make parallelism work in general. We need a cost model as well. How are we going to mark the functions which are safe to run in a parallel worker. We don't want to just call functions *_parallel because that will change. Maybe there will be an internal column in pgproc, as a short-term solution.<br />
<br />
Peter E. asked about timeline. For 9.4, we want to at least have an index build which runs a user-specified amount of parallelism. It needs to be reasonably fast.<br />
<br />
Peter G. asked about having a cost model for parallelism. Right now we don't have costing for how long it takes to sort things based on the number of rows. Sorting a text column in bad collation can be 1000X as expensive as sorting integers, for example. We might pick a single operator and make that the cost reference operator. Perfect costing isn't possible, but we can do some approximates. The initial operations we choose for parallelism will be very long operations. Startup costs are too high otherwise. We're not going to parallelize something that's 200ms. Something that takes 10s or a minute or a couple minutes.<br />
<br />
Haas thinks that a lot of people will be appalled for starting up a parallel worker. That can be optimized later. It's OK for the initial version to be unoptimized. Even if it takes a full second to start up a new backend, there are sorting tasks which take large numbers of seconds. Those are existing issues which we'll hammer on as we get into this space; we may fix starting up a new connection speed in the process.<br />
<br />
Josh pointed out that taking a hour to build an index, it's probably an external sort. Noah posted a patch to allow larger internal sorts, over 1GB. Andrew pointed out that a process model would tie us to certain large operations. Threads would add a lot of overhead to everything, though. We'd have to rewrite palloc. Haas things we can get the minimum unit down to something fairly small. Andrew pointed out that on windows process creation is very expensive. Haas doesn't want rewrite the entire internal infrastructure.<br />
<br />
With Threads, everything is shared by default, with processes, everything is unshared by default. The process model and explicit sharing is a shorter path from where we are currently. Parallelism helps with CPU-bound processes, but not IO. Josh argued with Kevin that there are some types of storage where this isn't true. Kevin just pointed out that if the resource you're using the most of isn't bottlenecked, then it's not helpful to parallelize. Haas pointed out that parallelizing seq scan on a single rotating disk won't help, as opposed to parallelizing scan from memory, which would be much faster. Our cost model isn't up to this; we might even have to have a recheck model where the executor notices things are slow and switches approaches.<br />
<br />
Bruce pointed out how Informix switched to threads between 5 and 7 and it killed the database. Parallelism will take Postgres into new markets.<br />
<br />
Andrew pointed out that prefork backends will help us form new connections if we can get it to work. Haas pointed out that we're going to have to cut nonessential issues to avoid taking forever.<br />
<br />
=== Pluggable plan/exec nodes ===<br />
<br />
Kaigai is working on GPU execution. When he worked on writable FDW, pseudo-column approach for foreign scan node returning an already computed value, but that was rejected, because the scan plan needs to return the data structure as its definition. So Kaigai wants to add an API to add a plan node to the exeuction node, allowing executor to run extension code during query execution. When plan tree tries to scan large table with sequential scan, and the target list has a complex calculation, we can have a pseudo-column which does this calculation on a GPU.<br />
<br />
Kaigai is talking about planner and executor. Haas doesn't understand how we would have pluggable planner nodes, as opposed to executor nodes. How would you allow it generate completely new types of plan nodes? We can replace existing plan nodes, but new types of nodes would require a new extensibility infrastructure. To do this, we need two new infrastructures to inject plan nodes and executor nodes. But Kaigai is mainly focused on is replacing existing scans and sort nodes. He didn't investigate the difficulty on planner extension yet.<br />
<br />
Peter E. pointed out that 65% of the work will be the ability to add new nodes at all. Replacement will be MUCH easier. However, the ability to add new nodes would be very useful to PostgreSQL in general. Tom thinks that it could be done. Haas pointed out that we have a lot of wierd optimizations about what plan node connects to which other plan node. Tom doesn't think that we have that many. Noah says we'll probably use a hook.<br />
<br />
For a new executor node we have a dispatch table, it's easy. Plan nodes could use a jump table too. Right now we have function volatility markers; for nodes we'll need the same thing. But that's a problem only for expression nodes.<br />
<br />
This was discussed in the cluster meeting. PostgresXC wanted pluggable nodes for cluster scan, as do some other people. So a general pluggability infrastructure would be good. If we have pluggable scan nodes, we can plug in cluster scan as well as GPU scan.<br />
<br />
Jeff Davis pointed out that range join could be our first pluggable node. Haas pointed out that opclass support requirements might make it difficult; there are easier cases. Range join might need to be hardcoded. Pluggable planner stuff is hard.<br />
<br />
This would also maybe get people who fork Postgres to stay closer to the core project and implement extensions instead of having an incompatible fork which then doesn't work with others.<br />
<br />
=== Volume Management ===<br />
<br />
Right now we have tablespaces. Having some more automation around using them would help. Like we want the indexes on a separate tablespace from the heap; there ought to be automation for this. Somebody hacked up something like this ... maybe Depesz, in 2007.<br />
<br />
Haas asked if having indexes on a separate volume was actually faster. Frost asserted that it was. Josh brought up that with new small fast storage there's reasons to want stuff to move around again. Also, index-only scans. If I only have one column, then I can do index-only scans, so I want to put the index on faster storage. Josh pointed out that indexes-separate worked back when at OSDL.<br />
<br />
Stephen Frost pointed out that they have pairs of drives, with a whole lot of pairs. Stephen asked about whether or not we'll ever have things like Oracle Volumes. Kevin said that that configuration works on raw devices, but not so much on complex filesystems. FRost says that for specific workloads, it really works to parallelize everything for massive joins.<br />
<br />
Several people asserted that modern RAID is fairly efficient. Josh asked if any default automated rules would work for a general class.<br />
<br />
Frost explained Oracle Volumes. They can be used to go to raw drives. Volumes are disks or drives or files. You can have multiple volumes under a single tablespace, and Oracle will manage them together. Do we want to do that? Maybe we should just use LVM.<br />
<br />
There's also some other things we could do with volumes, like compressed volumes. Noah has seen tablespaces abused 5 times as much as used properly. We should be careful that what we're adding is really useful. People want things like encrypted & compressed tablespaces. Every time something like this comes up, Tom or someone says "use a filesystem which provides that." There are some advantages to having the database do that, but there's a lot of development effort.<br />
<br />
Noah suggested that event triggers would do this. Frost says that they already have code, they want to simplify it. Josh points out that there aren't simple rules for this; most DWs don't have rules which are as simple as "indexes go here, tables go there". A lot of this is misplaced Oracle knowledge. Josh brought up the backup issue again.<br />
<br />
<br />
[[Category:PostgreSQL Events]]</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2013_Developer_MeetingPgCon 2013 Developer Meeting2013-05-22T13:47:37Z<p>Dpage: /* Agenda */</p>
<hr />
<div>A meeting of the most active PostgreSQL developers is being planned for Wednesday 22nd May, 2013 near the University of Ottawa, prior to pgCon 2013. 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). <br />
<br />
Please note that this year the attendee numbers have been kept low in order 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.3 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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 8:30AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Josh Berkus (secretary)<br />
* Jeff Davis<br />
* Andrew Dunstan<br />
* Peter Eisentraut<br />
* Dimitri Fontaine<br />
* Andres Freund<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Robert Haas<br />
* Magnus Hagander<br />
* KaiGai Kohei<br />
* Alexander Korotkov<br />
* Tom Lane<br />
* Fujii Masao<br />
* Noah Misch<br />
* Bruce Momjian<br />
* Dave Page (chair)<br />
* Simon Riggs<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* 9.4 Commitfest schedule and Commitfest tools.<br />
* [http://wiki.postgresql.org/wiki/Parallel_Query_Execution Parallel Query Execution] (Bruce, Noah)<br />
* logical changeset generation review & integration (Andres)<br />
* utilization of upcoming non-volatile RAM device (Kaigai)<br />
* pluggable plan/exec nodes (Kaigai)<br />
** to offload targetlist calculation, sorting, aggregates, ...<br />
* [[GIN generalization]] (Alexander)<br />
* An Extensibility Roadmap (dim) (15 min)<br />
* Representing severity - derive severity from SQLSTATE (Peter Geoghegan - see http://www.postgresql.org/message-id/CA+TgmoZEjq7va+SfDZQwk6E4emEWThENNyxfqEGhB3iuoT1OJw@mail.gmail.com) (10 min)<br />
* Error logging infrastructure - store normalized statistics about errors in a circular buffer (Peter Geoghegan). Arguably this could be discussed alongside SQLSTATE item. (10 min)<br />
* Failback with backup (Fujii Masao - related discussion is: http://www.postgresql.org/message-id/CAF8Q-Gxg3PQTf71NVECe-6OzRaew5pWhk7yQtbJgWrFu513s+Q@mail.gmail.com)<br />
* Volume Management (Stephen Frost - wiki page will be forthcoming before the meeting)<br />
* AXLE Project - Big data analytics for Postgres (Simon Riggs) - an overview of the feature plan, how project works and what community can expect (15 min)<br />
* Incremental maintenance of materialized views (Kevin) - differential REFRESH and infrastructure for ''counting'' algorithm (30 min)<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:30 - 08:45<br />
|Welcome and introductions<br />
|Dave Page<br />
<br />
|-<br />
|08:45 - 09:45<br />
|Parallel Query Execution<br />
|Bruce/Noah<br />
<br />
|-<br />
|09:45 - 10:15<br />
|Pluggable plan/exec nodes<br />
|KaiGai<br />
<br />
|-<br />
|10:15 - 10:30<br />
|Volume Management<br />
|Stephen Frost<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
<br />
|-<br />
|10:45 - 11:00<br />
|Utilization of upcoming non-volatile RAM devices<br />
|KaiGai<br />
<br />
|-<br />
|11:00 - 11:30<br />
|Logical changeset generation review & integration<br />
|Andres<br />
<br />
|-<br />
|11:30 - 11:40<br />
|Representing severity<br />
|Peter G.<br />
<br />
|-<br />
|11:40 - 11:50<br />
|Error logging infrastructure<br />
|Peter G.<br />
<br />
|-<br />
|11:50 - 12:30<br />
|Incremental maintenance of materialized views<br />
|Kevin<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
<br />
|-<br />
|13:30 - 14:15<br />
|GIN generalization<br />
|Alexander<br />
<br />
|-<br />
|14:15 - 14:30<br />
|An Extensibility Roadmap<br />
|Dimitri<br />
<br />
|-<br />
|14:30 - 15:00<br />
|Failback with backup<br />
|Fujii<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
<br />
|-<br />
|15:15 - 15:45<br />
|9.4 Commitfest schedule and tools<br />
|Josh<br />
<br />
|-<br />
|15:45 - 16:45<br />
|Goals, priorities, and resources for 9.4<br />
|All<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}<br />
<br />
[[Category:PostgreSQL Events]]</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2013_Developer_MeetingPgCon 2013 Developer Meeting2013-05-16T08:43:57Z<p>Dpage: /* Agenda */</p>
<hr />
<div>A meeting of the most active PostgreSQL developers is being planned for Wednesday 22nd May, 2013 near the University of Ottawa, prior to pgCon 2013. 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). <br />
<br />
Please note that this year the attendee numbers have been kept low in order 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.3 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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 8:30AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Josh Berkus (secretary)<br />
* Jeff Davis<br />
* Andrew Dunstan<br />
* Peter Eisentraut<br />
* Dimitri Fontaine<br />
* Andres Freund<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Robert Haas<br />
* Magnus Hagander<br />
* KaiGai Kohei<br />
* Alexander Korotkov<br />
* Tom Lane<br />
* Fujii Masao<br />
* Noah Misch<br />
* Bruce Momjian<br />
* Dave Page (chair)<br />
* Simon Riggs<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* 9.4 Commitfest schedule and Commitfest tools.<br />
* [http://wiki.postgresql.org/wiki/Parallel_Query_Execution Parallel Query Execution] (Bruce, Noah)<br />
* logical changeset generation review & integration (Andres)<br />
* utilization of upcoming non-volatile RAM device (Kaigai)<br />
* pluggable plan/exec nodes (Kaigai)<br />
** to offload targetlist calculation, sorting, aggregates, ...<br />
* [[GIN generalization]] (Alexander)<br />
* An Extensibility Roadmap (dim) (15 min)<br />
* Representing severity - derive severity from SQLSTATE (Peter Geoghegan - see http://www.postgresql.org/message-id/CA+TgmoZEjq7va+SfDZQwk6E4emEWThENNyxfqEGhB3iuoT1OJw@mail.gmail.com) (10 min)<br />
* Error logging infrastructure - store normalized statistics about errors in a circular buffer (Peter Geoghegan). Arguably this could be discussed alongside SQLSTATE item. (10 min)<br />
* Failback with backup (Fujii Masao - related discussion is: http://www.postgresql.org/message-id/CAF8Q-Gxg3PQTf71NVECe-6OzRaew5pWhk7yQtbJgWrFu513s+Q@mail.gmail.com)<br />
* Volume Management (Stephen Frost - wiki page will be forthcoming before the meeting)<br />
* AXLE Project - Big data analytics for Postgres (Simon Riggs) - an overview of the feature plan, how project works and what community can expect (15 min)<br />
* Incremental maintenance of materialized views (Kevin) - differential REFRESH and infrastructure for ''counting'' algorithm (30 min)<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:30 - 08:45<br />
|Welcome and introductions<br />
|Dave Page<br />
<br />
|-<br />
|08:45 - 09:45<br />
|Parallel Query Execution<br />
|Bruce/Noah<br />
<br />
|-<br />
|09:45 - 10:15<br />
|Pluggable plan/exec nodes<br />
|KaiGai<br />
<br />
|-<br />
|10:15 - 10:30<br />
|AXLE Project - Big data analytics for Postgres<br />
|Simon<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
<br />
|-<br />
|10:45 - 11:00<br />
|Utilization of upcoming non-volatile RAM devices<br />
|KaiGai<br />
<br />
|-<br />
|11:00 - 11:30<br />
|Logical changeset generation review & integration<br />
|Andres<br />
<br />
|-<br />
|11:30 - 11:40<br />
|Representing severity<br />
|Peter G.<br />
<br />
|-<br />
|11:40 - 11:50<br />
|Error logging infrastructure<br />
|Peter G.<br />
<br />
|-<br />
|11:50 - 12:30<br />
|Incremental maintenance of materialized views<br />
|Kevin<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
<br />
|-<br />
|13:30 - 14:15<br />
|GIN generalization<br />
|Alexander<br />
<br />
|-<br />
|14:15 - 14:30<br />
|An Extensibility Roadmap<br />
|Dimitri<br />
<br />
|-<br />
|14:30 - 15:00<br />
|Failback with backup<br />
|Fujii<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
<br />
|-<br />
|15:15 - 15:45<br />
|9.4 Commitfest schedule and tools<br />
|Josh<br />
<br />
|-<br />
|15:45 - 16:45<br />
|Goals, priorities, and resources for 9.4<br />
|All<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2013_Developer_MeetingPgCon 2013 Developer Meeting2013-05-16T08:41:10Z<p>Dpage: /* Agenda */</p>
<hr />
<div>A meeting of the most active PostgreSQL developers is being planned for Wednesday 22nd May, 2013 near the University of Ottawa, prior to pgCon 2013. 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). <br />
<br />
Please note that this year the attendee numbers have been kept low in order 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.3 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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 8:30AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Josh Berkus (secretary)<br />
* Jeff Davis<br />
* Andrew Dunstan<br />
* Peter Eisentraut<br />
* Dimitri Fontaine<br />
* Andres Freund<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Robert Haas<br />
* Magnus Hagander<br />
* KaiGai Kohei<br />
* Alexander Korotkov<br />
* Tom Lane<br />
* Fujii Masao<br />
* Noah Misch<br />
* Bruce Momjian<br />
* Dave Page (chair)<br />
* Simon Riggs<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* 9.4 Commitfest schedule and Commitfest tools.<br />
* [http://wiki.postgresql.org/wiki/Parallel_Query_Execution Parallel Query Execution] (Bruce, Noah)<br />
* logical changeset generation review & integration (Andres)<br />
* utilization of upcoming non-volatile RAM device (Kaigai)<br />
* pluggable plan/exec nodes (Kaigai)<br />
** to offload targetlist calculation, sorting, aggregates, ...<br />
* [[GIN generalization]] (Alexander)<br />
* An Extensibility Roadmap (dim) (15 min)<br />
* Representing severity - derive severity from SQLSTATE (Peter Geoghegan - see http://www.postgresql.org/message-id/CA+TgmoZEjq7va+SfDZQwk6E4emEWThENNyxfqEGhB3iuoT1OJw@mail.gmail.com) (10 min)<br />
* Error logging infrastructure - store normalized statistics about errors in a circular buffer (Peter Geoghegan). Arguably this could be discussed alongside SQLSTATE item. (10 min)<br />
* Failback with backup (Fujii Masao - related discussion is: http://www.postgresql.org/message-id/CAF8Q-Gxg3PQTf71NVECe-6OzRaew5pWhk7yQtbJgWrFu513s+Q@mail.gmail.com)<br />
* Volume Management (Stephen Frost - wiki page will be forthcoming before the meeting)<br />
* AXLE Project - Big data analytics for Postgres (Simon Riggs) - an overview of the feature plan, how project works and what community can expect (15 min)<br />
* Incremental maintenance of materialized views (Kevin) - differential REFRESH and infrastructure for ''counting'' algorithm (30 min)<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:30 - 08:45<br />
|Welcome and introductions<br />
|Dave Page<br />
<br />
|-<br />
|08:45 - 09:45<br />
|Parallel Query Execution<br />
|Bruce/Noah<br />
<br />
|-<br />
|09:45 - 10:15<br />
|Pluggable plan/exec nodes<br />
|KaiGai<br />
<br />
|-<br />
|10:15 - 10:30<br />
|AXLE Project - Big data analytics for Postgres<br />
|Simon<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
<br />
|-<br />
|10:45 - 11:00<br />
|Utilization of upcoming non-volatile RAM devices<br />
|KaiGai<br />
<br />
|-<br />
|11:00 - 11:30<br />
|Logical changeset generation review & integration<br />
|Andres<br />
<br />
|-<br />
|11:30 - 11:40<br />
|Representing severity<br />
|Peter G.<br />
<br />
|-<br />
|11:40 - 11:50<br />
|Error logging infrastructure<br />
|Peter G.<br />
<br />
|-<br />
|11:50 - 12:30<br />
|Incremental maintenance of materialized views<br />
|Kevin<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
<br />
|-<br />
|13:30 - 14:15<br />
|GIN generalization<br />
|Alexander<br />
<br />
|-<br />
|14:15 - 14:30<br />
|An Extensibility Roadmap<br />
|Dimitri<br />
<br />
|-<br />
|14:30 - 15:00<br />
|Failback with backup<br />
|Fujii<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
<br />
|-<br />
|15:15 - 15:45<br />
|9.4 Commitfest schedule<br />
|All<br />
<br />
|-<br />
|15:45 - 16:45<br />
|Goals, priorities, and resources for 9.4<br />
|All<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2013_Developer_MeetingPgCon 2013 Developer Meeting2013-05-14T15:31:42Z<p>Dpage: /* Agenda */</p>
<hr />
<div>A meeting of the most active PostgreSQL developers is being planned for Wednesday 22nd May, 2013 near the University of Ottawa, prior to pgCon 2013. 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). <br />
<br />
Please note that this year the attendee numbers have been kept low in order 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.3 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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 8:30AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Josh Berkus (secretary)<br />
* Jeff Davis<br />
* Andrew Dunstan<br />
* Peter Eisentraut<br />
* Dimitri Fontaine<br />
* Andres Freund<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Robert Haas<br />
* Magnus Hagander<br />
* KaiGai Kohei<br />
* Alexander Korotkov<br />
* Tom Lane<br />
* Fujii Masao<br />
* Noah Misch<br />
* Bruce Momjian<br />
* Dave Page (chair)<br />
* Simon Riggs<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* 9.4 Commitfest schedule<br />
* [http://wiki.postgresql.org/wiki/Parallel_Query_Execution Parallel Query Execution] (Bruce, Noah)<br />
* logical changeset generation review & integration (Andres)<br />
* utilization of upcoming non-volatile RAM device (Kaigai)<br />
* pluggable plan/exec nodes (Kaigai)<br />
** to offload targetlist calculation, sorting, aggregates, ...<br />
* [[GIN generalization]] (Alexander)<br />
* An Extensibility Roadmap (dim) (15 min)<br />
* Representing severity - derive severity from SQLSTATE (Peter Geoghegan - see http://www.postgresql.org/message-id/CA+TgmoZEjq7va+SfDZQwk6E4emEWThENNyxfqEGhB3iuoT1OJw@mail.gmail.com) (10 min)<br />
* Error logging infrastructure - store normalized statistics about errors in a circular buffer (Peter Geoghegan). Arguably this could be discussed alongside SQLSTATE item. (10 min)<br />
* Failback with backup (Fujii Masao - related discussion is: http://www.postgresql.org/message-id/CAF8Q-Gxg3PQTf71NVECe-6OzRaew5pWhk7yQtbJgWrFu513s+Q@mail.gmail.com)<br />
* Volume Management (Stephen Frost - wiki page will be forthcoming before the meeting)<br />
* AXLE Project - Big data analytics for Postgres (Simon Riggs) - an overview of the feature plan, how project works and what community can expect (15 min)<br />
* Incremental maintenance of materialized views (Kevin) - differential REFRESH and infrastructure for ''counting'' algorithm (30 min)<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:30 - 08:45<br />
|Welcome and introductions<br />
|Dave Page<br />
<br />
|-<br />
|08:45 - 09:45<br />
|Parallel Query Execution<br />
|Bruce/Noah<br />
<br />
|-<br />
|09:45 - 10:15<br />
|Pluggable plan/exec nodes<br />
|KaiGai<br />
<br />
|-<br />
|10:15 - 10:30<br />
|AXLE Project - Big data analytics for Postgres<br />
|Simon<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
<br />
|-<br />
|10:45 - 11:00<br />
|Utilization of upcoming non-volatile RAM devices<br />
|KaiGai<br />
<br />
|-<br />
|11:00 - 11:30<br />
|Logical changeset generation review & integration<br />
|Andres<br />
<br />
|-<br />
|11:30 - 11:40<br />
|Representing severity<br />
|Peter G.<br />
<br />
|-<br />
|11:40 - 11:50<br />
|Error logging infrastructure<br />
|Peter G.<br />
<br />
|-<br />
|11:50 - 12:30<br />
|Incremental maintenance of materialized views<br />
|Kevin<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
<br />
|-<br />
|13:30 - 14:15<br />
|GIN generalization<br />
|Alexander<br />
<br />
|-<br />
|14:15 - 14:30<br />
|An Extensibility Roadmap<br />
|Dimitri<br />
<br />
|-<br />
|14:30 - 15:00<br />
|Failback with backup<br />
|Fujii<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
<br />
|-<br />
|15:15 - 15:30<br />
|9.4 Commitfest schedule<br />
|All<br />
<br />
|-<br />
|15:30 - 16:45<br />
|Goals, priorities, and resources for 9.4<br />
|All<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2013_Developer_MeetingPgCon 2013 Developer Meeting2013-05-14T13:00:27Z<p>Dpage: /* Agenda */</p>
<hr />
<div>A meeting of the most active PostgreSQL developers is being planned for Wednesday 22nd May, 2013 near the University of Ottawa, prior to pgCon 2013. 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). <br />
<br />
Please note that this year the attendee numbers have been kept low in order 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.3 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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 8:30AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Josh Berkus (secretary)<br />
* Jeff Davis<br />
* Andrew Dunstan<br />
* Peter Eisentraut<br />
* Dimitri Fontaine<br />
* Andres Freund<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Robert Haas<br />
* Magnus Hagander<br />
* KaiGai Kohei<br />
* Alexander Korotkov<br />
* Tom Lane<br />
* Fujii Masao<br />
* Noah Misch<br />
* Bruce Momjian<br />
* Dave Page (chair)<br />
* Simon Riggs<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* 9.4 Commitfest schedule<br />
* [http://wiki.postgresql.org/wiki/Parallel_Query_Execution Parallel Query Execution] (Bruce, Noah)<br />
* logical changeset generation review & integration (Andres)<br />
* utilization of upcoming non-volatile RAM device (Kaigai)<br />
* pluggable plan/exec nodes (Kaigai)<br />
** to offload targetlist calculation, sorting, aggregates, ...<br />
* [[GIN generalization]] (Alexander)<br />
* An Extensibility Roadmap (dim) (15 min)<br />
* Representing severity - derive severity from SQLSTATE (Peter Geoghegan - see http://www.postgresql.org/message-id/CA+TgmoZEjq7va+SfDZQwk6E4emEWThENNyxfqEGhB3iuoT1OJw@mail.gmail.com) (10 min)<br />
* Error logging infrastructure - store normalized statistics about errors in a circular buffer (Peter Geoghegan). Arguably this could be discussed alongside SQLSTATE item. (10 min)<br />
* Failback with backup (Fujii Masao - related discussion is: http://www.postgresql.org/message-id/CAF8Q-Gxg3PQTf71NVECe-6OzRaew5pWhk7yQtbJgWrFu513s+Q@mail.gmail.com)<br />
* Volume Management (Stephen Frost - wiki page will be forthcoming before the meeting)<br />
* AXLE Project - Big data analytics for Postgres (Simon Riggs) - an overview of the feature plan, how project works and what community can expect (15 min)<br />
* Incremental maintenance of materialized views (Kevin) - differential REFRESH and infrastructure for ''counting'' algorithm (30 min)<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:30 - 08:45<br />
|Welcome and introductions<br />
|Dave Page<br />
<br />
|-<br />
|08:45 - 09:45<br />
|Parallel Query Execution<br />
|Bruce/Noah<br />
<br />
|-<br />
|09:45 - 10:15<br />
|Logical changeset generation review & integration<br />
|Andres<br />
<br />
|-<br />
|10:15 - 10:30<br />
|AXLE Project - Big data analytics for Postgres<br />
|Simon<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
<br />
|-<br />
|10:45 - 11:00<br />
|Utilization of upcoming non-volatile RAM devices<br />
|KaiGai<br />
<br />
|-<br />
|11:00 - 11:30<br />
|Pluggable plan/exec nodes<br />
|KaiGai<br />
<br />
|-<br />
|11:30 - 11:40<br />
|Representing severity<br />
|Peter G.<br />
<br />
|-<br />
|11:40 - 11:50<br />
|Error logging infrastructure<br />
|Peter G.<br />
<br />
|-<br />
|11:50 - 12:30<br />
|Incremental maintenance of materialized views<br />
|Kevin<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
<br />
|-<br />
|13:30 - 14:15<br />
|GIN generalization<br />
|Alexander<br />
<br />
|-<br />
|14:15 - 14:30<br />
|An Extensibility Roadmap<br />
|Dimitri<br />
<br />
|-<br />
|14:30 - 15:00<br />
|Failback with backup<br />
|Fujii<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
<br />
|-<br />
|15:15 - 15:30<br />
|9.4 Commitfest schedule<br />
|All<br />
<br />
|-<br />
|15:30 - 16:45<br />
|Goals, priorities, and resources for 9.4<br />
|All<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2013_Developer_MeetingPgCon 2013 Developer Meeting2013-05-14T12:51:09Z<p>Dpage: /* Agenda */</p>
<hr />
<div>A meeting of the most active PostgreSQL developers is being planned for Wednesday 22nd May, 2013 near the University of Ottawa, prior to pgCon 2013. 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). <br />
<br />
Please note that this year the attendee numbers have been kept low in order 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.3 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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 8:30AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Josh Berkus (secretary)<br />
* Jeff Davis<br />
* Andrew Dunstan<br />
* Peter Eisentraut<br />
* Dimitri Fontaine<br />
* Andres Freund<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Robert Haas<br />
* Magnus Hagander<br />
* KaiGai Kohei<br />
* Alexander Korotkov<br />
* Tom Lane<br />
* Fujii Masao<br />
* Noah Misch<br />
* Bruce Momjian<br />
* Dave Page (chair)<br />
* Simon Riggs<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* 9.4 Commitfest schedule<br />
* [http://wiki.postgresql.org/wiki/Parallel_Query_Execution Parallel Query Execution] (Bruce, Noah)<br />
* logical changeset generation review & integration (Andres)<br />
* utilization of upcoming non-volatile RAM device (Kaigai)<br />
* pluggable plan/exec nodes (Kaigai)<br />
** to offload targetlist calculation, sorting, aggregates, ...<br />
* [[GIN generalization]] (Alexander)<br />
* An Extensibility Roadmap (dim) (15 min)<br />
* Representing severity - derive severity from SQLSTATE (Peter Geoghegan - see http://www.postgresql.org/message-id/CA+TgmoZEjq7va+SfDZQwk6E4emEWThENNyxfqEGhB3iuoT1OJw@mail.gmail.com) (10 min)<br />
* Error logging infrastructure - store normalized statistics about errors in a circular buffer (Peter Geoghegan). Arguably this could be discussed alongside SQLSTATE item. (10 min)<br />
* Failback with backup (Fujii Masao - related discussion is: http://www.postgresql.org/message-id/CAF8Q-Gxg3PQTf71NVECe-6OzRaew5pWhk7yQtbJgWrFu513s+Q@mail.gmail.com)<br />
* Volume Management (Stephen Frost - wiki page will be forthcoming before the meeting)<br />
* AXLE Project - Big data analytics for Postgres (Simon Riggs) - an overview of the feature plan, how project works and what community can expect (15 min)<br />
* Incremental maintenance of materialized views (Kevin) - differential REFRESH and infrastructure for ''counting'' algorithm (30 min)<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:30 - 08:45<br />
|Welcome and introductions<br />
|Dave Page<br />
<br />
|-<br />
|08:45 - 09:45<br />
|Parallel Query Execution<br />
|Bruce/Noah<br />
<br />
|-<br />
|09:45 - 10:30<br />
|Logical changeset generation review & integration<br />
|Andres<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
<br />
|-<br />
|10:45 - 11:00<br />
|Utilization of upcoming non-volatile RAM devices<br />
|KaiGai<br />
<br />
|-<br />
|11:00 - 11:30<br />
|Pluggable plan/exec nodes<br />
|KaiGai<br />
<br />
|-<br />
|11:30 - 11:40<br />
|Representing severity<br />
|Peter G.<br />
<br />
|-<br />
|11:40 - 11:50<br />
|Error logging infrastructure<br />
|Peter G.<br />
<br />
|-<br />
|11:50 - 12:30<br />
|Materialised Views<br />
|Kevin<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
<br />
|-<br />
|13:30 - 14:15<br />
|GIN generalization<br />
|Alexander<br />
<br />
|-<br />
|14:15 - 15:00<br />
|An Extensibility Roadmap<br />
|Dimitri<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
<br />
|-<br />
|15:15 - 15:30<br />
|9.4 Commitfest schedule<br />
|All<br />
<br />
|-<br />
|15:30 - 16:45<br />
|Goals, priorities, and resources for 9.4<br />
|All<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2013_Developer_MeetingPgCon 2013 Developer Meeting2013-05-14T08:35:39Z<p>Dpage: /* Proposed Agenda Items */</p>
<hr />
<div>A meeting of the most active PostgreSQL developers is being planned for Wednesday 22nd May, 2013 near the University of Ottawa, prior to pgCon 2013. 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). <br />
<br />
Please note that this year the attendee numbers have been kept low in order 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.3 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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 8:30AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Josh Berkus (secretary)<br />
* Jeff Davis<br />
* Andrew Dunstan<br />
* Peter Eisentraut<br />
* Dimitri Fontaine<br />
* Andres Freund<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Robert Haas<br />
* Magnus Hagander<br />
* KaiGai Kohei<br />
* Alexander Korotkov<br />
* Tom Lane<br />
* Fujii Masao<br />
* Noah Misch<br />
* Bruce Momjian<br />
* Dave Page (chair)<br />
* Simon Riggs<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* 9.4 Commitfest schedule<br />
* [http://wiki.postgresql.org/wiki/Parallel_Query_Execution Parallel Query Execution] (Bruce, Noah)<br />
* logical changeset generation review & integration (Andres)<br />
* utilization of upcoming non-volatile RAM device (Kaigai)<br />
* pluggable plan/exec nodes (Kaigai)<br />
** to offload targetlist calculation, sorting, aggregates, ...<br />
* [[GIN generalization]] (Alexander)<br />
* An Extensibility Roadmap (dim) (15 min)<br />
* Representing severity - derive severity from SQLSTATE (Peter Geoghegan - see http://www.postgresql.org/message-id/CA+TgmoZEjq7va+SfDZQwk6E4emEWThENNyxfqEGhB3iuoT1OJw@mail.gmail.com) (10 min)<br />
* Error logging infrastructure - store normalized statistics about errors in a circular buffer (Peter Geoghegan). Arguably this could be discussed alongside SQLSTATE item. (10 min)<br />
* Failback with backup (Fujii Masao - related discussion is: http://www.postgresql.org/message-id/CAF8Q-Gxg3PQTf71NVECe-6OzRaew5pWhk7yQtbJgWrFu513s+Q@mail.gmail.com)<br />
* Volume Management (Stephen Frost - wiki page will be forthcoming before the meeting)<br />
* AXLE Project - Big data analytics for Postgres (Simon Riggs) - an overview of the feature plan, how project works and what community can expect (15 min)<br />
* Incremental maintenance of materialized views (Kevin) - differential REFRESH and infrastructure for ''counting'' algorithm (30 min)<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:30 - 08:45<br />
|Welcome and introductions<br />
|Dave Page<br />
<br />
|-<br />
|08:45 - 09:45<br />
|Parallel Query Execution<br />
|Bruce/Noah<br />
<br />
|-<br />
|09:45 - 10:30<br />
|Logical changeset generation review & integration<br />
|Andres<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
<br />
|-<br />
|10:45 - 11:00<br />
|Utilization of upcoming non-volatile RAM devices<br />
|KaiGai<br />
<br />
|-<br />
|11:00 - 11:30<br />
|Pluggable plan/exec nodes<br />
|KaiGai<br />
<br />
|-<br />
|11:30 - 11:50<br />
|Representing severity<br />
|Peter G.<br />
<br />
|-<br />
|11:50 - 12:30<br />
|Error logging infrastructure<br />
|Peter G.<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
<br />
|-<br />
|13:30 - 14:15<br />
|GIN generalization<br />
|Alexander<br />
<br />
|-<br />
|14:15 - 15:00<br />
|An Extensibility Roadmap<br />
|Dimitri<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
<br />
|-<br />
|15:15 - 15:30<br />
|9.4 Commitfest schedule<br />
|All<br />
<br />
|-<br />
|15:30 - 16:45<br />
|Goals, priorities, and resources for 9.4<br />
|All<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2013_Developer_MeetingPgCon 2013 Developer Meeting2013-05-14T08:34:02Z<p>Dpage: /* Proposed Agenda Items */</p>
<hr />
<div>A meeting of the most active PostgreSQL developers is being planned for Wednesday 22nd May, 2013 near the University of Ottawa, prior to pgCon 2013. 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). <br />
<br />
Please note that this year the attendee numbers have been kept low in order 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.3 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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 8:30AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Josh Berkus (secretary)<br />
* Jeff Davis<br />
* Andrew Dunstan<br />
* Peter Eisentraut<br />
* Dimitri Fontaine<br />
* Andres Freund<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Robert Haas<br />
* Magnus Hagander<br />
* KaiGai Kohei<br />
* Alexander Korotkov<br />
* Tom Lane<br />
* Fujii Masao<br />
* Noah Misch<br />
* Bruce Momjian<br />
* Dave Page (chair)<br />
* Simon Riggs<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* 9.4 Commitfest schedule<br />
* [http://wiki.postgresql.org/wiki/Parallel_Query_Execution Parallel Query Execution] (Bruce, Noah)<br />
* logical changeset generation review & integration (Andres)<br />
* utilization of upcoming non-volatile RAM device (Kaigai)<br />
* pluggable plan/exec nodes (Kaigai)<br />
** to offload targetlist calculation, sorting, aggregates, ...<br />
* [[GIN generalization]] (Alexander)<br />
* An Extensibility Roadmap (dim) (15 min)<br />
* Representing severity - derive severity from SQLSTATE (Peter Geoghegan - see http://www.postgresql.org/message-id/CA+TgmoZEjq7va+SfDZQwk6E4emEWThENNyxfqEGhB3iuoT1OJw@mail.gmail.com) (15 min)<br />
* Error logging infrastructure - store normalized statistics about errors in a circular buffer (Peter Geoghegan). Arguably this could be discussed alongside SQLSTATE item. (15 min)<br />
* Failback with backup (Fujii Masao - related discussion is: http://www.postgresql.org/message-id/CAF8Q-Gxg3PQTf71NVECe-6OzRaew5pWhk7yQtbJgWrFu513s+Q@mail.gmail.com)<br />
* Volume Management (Stephen Frost - wiki page will be forthcoming before the meeting)<br />
* AXLE Project - Big data analytics for Postgres (Simon Riggs) - an overview of the feature plan, how project works and what community can expect (15 min)<br />
* Incremental maintenance of materialized views (Kevin) - differential REFRESH and infrastructure for ''counting'' algorithm (30 min)<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:30 - 08:45<br />
|Welcome and introductions<br />
|Dave Page<br />
<br />
|-<br />
|08:45 - 09:45<br />
|Parallel Query Execution<br />
|Bruce/Noah<br />
<br />
|-<br />
|09:45 - 10:30<br />
|Logical changeset generation review & integration<br />
|Andres<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
<br />
|-<br />
|10:45 - 11:00<br />
|Utilization of upcoming non-volatile RAM devices<br />
|KaiGai<br />
<br />
|-<br />
|11:00 - 11:30<br />
|Pluggable plan/exec nodes<br />
|KaiGai<br />
<br />
|-<br />
|11:30 - 11:50<br />
|Representing severity<br />
|Peter G.<br />
<br />
|-<br />
|11:50 - 12:30<br />
|Error logging infrastructure<br />
|Peter G.<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
<br />
|-<br />
|13:30 - 14:15<br />
|GIN generalization<br />
|Alexander<br />
<br />
|-<br />
|14:15 - 15:00<br />
|An Extensibility Roadmap<br />
|Dimitri<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
<br />
|-<br />
|15:15 - 15:30<br />
|9.4 Commitfest schedule<br />
|All<br />
<br />
|-<br />
|15:30 - 16:45<br />
|Goals, priorities, and resources for 9.4<br />
|All<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2013_Developer_MeetingPgCon 2013 Developer Meeting2013-05-13T12:40:44Z<p>Dpage: </p>
<hr />
<div>A meeting of the most active PostgreSQL developers is being planned for Wednesday 22nd May, 2013 near the University of Ottawa, prior to pgCon 2013. 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). <br />
<br />
Please note that this year the attendee numbers have been kept low in order 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.3 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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 8:30AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Josh Berkus (secretary)<br />
* Jeff Davis<br />
* Andrew Dunstan<br />
* Peter Eisentraut<br />
* Dimitri Fontaine<br />
* Andres Freund<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Robert Haas<br />
* Magnus Hagander<br />
* Alexander Korotkov<br />
* Fujii Masao<br />
* Noah Misch<br />
* Bruce Momjian<br />
* Tom Lane<br />
* Dave Page (chair)<br />
* Simon Riggs<br />
* KaiGai Kohei<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* 9.4 Commitfest schedule<br />
* [http://wiki.postgresql.org/wiki/Parallel_Query_Execution Parallel Query Execution] (Bruce, Noah)<br />
* logical changeset generation review & integration (Andres)<br />
* utilization of upcoming non-volatile RAM device (Kaigai)<br />
* pluggable plan/exec nodes (Kaigai)<br />
** to offload targetlist calculation, sorting, aggregates, ...<br />
* [[GIN generalization]] (Alexander)<br />
* An Extensibility Roadmap (dim)<br />
* Representing severity - derive severity from SQLSTATE (Peter Geoghegan - see http://www.postgresql.org/message-id/CA+TgmoZEjq7va+SfDZQwk6E4emEWThENNyxfqEGhB3iuoT1OJw@mail.gmail.com)<br />
* Error logging infrastructure - store normalized statistics about errors in a circular buffer (Peter Geoghegan). Arguably this could be discussed alongside SQLSTATE item.<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:30 - 08:45<br />
|Welcome and introductions<br />
|Dave Page<br />
<br />
|-<br />
|08:45 - 09:45<br />
|Parallel Query Execution<br />
|Bruce/Noah<br />
<br />
|-<br />
|09:45 - 10:30<br />
|Logical changeset generation review & integration<br />
|Andres<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
<br />
|-<br />
|10:45 - 11:00<br />
|Utilization of upcoming non-volatile RAM devices<br />
|KaiGai<br />
<br />
|-<br />
|11:00 - 11:30<br />
|Pluggable plan/exec nodes<br />
|KaiGai<br />
<br />
|-<br />
|11:30 - 11:50<br />
|Representing severity<br />
|Peter G.<br />
<br />
|-<br />
|11:50 - 12:30<br />
|Error logging infrastructure<br />
|Peter G.<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
<br />
|-<br />
|13:30 - 14:15<br />
|GIN generalization<br />
|Alexander<br />
<br />
|-<br />
|14:15 - 15:00<br />
|An Extensibility Roadmap<br />
|Dimitri<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
<br />
|-<br />
|15:15 - 15:30<br />
|9.4 Commitfest schedule<br />
|All<br />
<br />
|-<br />
|15:30 - 16:45<br />
|Goals, priorities, and resources for 9.4<br />
|All<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2013_Developer_MeetingPgCon 2013 Developer Meeting2013-04-22T16:39:19Z<p>Dpage: /* Attendees */</p>
<hr />
<div>A meeting of the most active PostgreSQL developers is being planned for Wednesday 22nd May, 2013 near the University of Ottawa, prior to pgCon 2013. 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). <br />
<br />
Please note that this year the attendee numbers have been kept low in order 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.3 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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 8:30AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Jeff Davis<br />
* Andrew Dunstan<br />
* Peter Eisentraut<br />
* Dimitri Fontaine<br />
* Andres Freund<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Robert Haas<br />
* Magnus Hagander<br />
* Alexander Korotkov<br />
* Fujii Masao<br />
* Noah Misch<br />
* Bruce Momjian<br />
* Tom Lane<br />
* Dave Page<br />
* Simon Riggs<br />
* KaiGai Kohei<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* 9.4 Commitfest schedule<br />
* [http://wiki.postgresql.org/wiki/Parallel_Query_Execution Parallel Query Execution] (Bruce)<br />
* logical changeset generation review & integration (Andres)<br />
* utilization of upcoming non-volatile RAM device (Kaigai)<br />
* pluggable plan/exec nodes (Kaigai)<br />
** to offload targetlist calculation, sorting, aggregates, ...<br />
* GIN generalization (Alexander)</div>Dpagehttp://wiki.postgresql.org/wiki/PostgreSQL_Security_Release_Policy_DraftPostgreSQL Security Release Policy Draft2013-04-03T08:12:34Z<p>Dpage: Correct version, remove "Windows" as installers cover multiple platforms, and stop inventing new acronyms.</p>
<hr />
<div>= PostgreSQL Security Release Policy Draft =<br />
Link: [http://www.postgresql.org/support/security/ http://www.postgresql.org/support/security/]<br />
<br />
== Current ==<br />
<br />
If you wish to report a new security vulnerability in PostgreSQL, please send an email to [mailto:security@postgresql.org security@postgresql.org]. For reporting non-security bugs, please see the [http://www.postgresql.org/support/submitbug Report a Bug] page.<br />
<br />
PostgreSQL security updates are primarily made available as [http://www.postgresql.org/support/versioning minor version] upgrades. You are always advised to use the latest minor version available, as it will likely also contain other non-security related fixes. All known security issues are always fixed in the next major release, when it comes out.<br />
<br />
PGDG believes that accuracy, completeness and availability of security information is essential for our users. We choose to pool all information on this one page, allowing easy searching for vulnerabilities by a range of criteria.<br />
<br />
The following table lists all known security issues. Please note that versions prior to 8.3 are no longer supported and vulnerabilities for these versions may not be included in this list. New vulnerabilities in these versions are no longer patched.<br />
<br />
Vulnerabilities list which major releases they were present in, and which version they are fixed in for each. If the vulnerability was exploitable without a valid login, this is also stated. They also list a vulnerability class, but we urge all users to read the description to determine if the bug affects specific installations or not.<br />
<br />
(List of Security Issues + Fixes here)<br />
<br />
== Draft ==<br />
<br />
The PostgreSQL Global Development Group (PGDG) takes security seriously, allowing our users to place their trust in the web sites. applications and infrastructure built around PostgreSQL. Our approach covers fail-safe configuration options, a secure and robust database server as well as good integration with other security infrastructure software.<br />
<br />
=== Reporting a Security Issue ===<br />
<br />
If you wish to report a new security vulnerability in PostgreSQL, please send an email to our Security Team at [mailto:security@postgresql.org security@postgresql.org]. For reporting non-security bugs, please see the [http://www.postgresql.org/support/submitbug Report a Bug] page.<br />
<br />
=== The Security Team ===<br />
<br />
The PostgreSQL Security Team consists of a small number of committers and major contributors to PostgreSQL who work on resolving reported security issues. Members of the Security Team are appointed by the PostgreSQL Core Team, and serve until they resign or are removed for inactivity.<br />
<br />
The Security Team attempts to resolve reported security issues as quickly as possible. Depending on the difficulty of the issue, it can take a few days to a few months to resolve. While known security issues are tracked by the Security Team, the list of pending issues is not available outside of the Team.<br />
<br />
=== The Packagers List ===<br />
<br />
The Packagers List consists of a few dozen people who create PostgreSQL packages for distribution to other users. This includes not only those who create the installers, RPMs, Debs, PPA, Ports and so forth, but also the engineers who do packaging for public Database-As-A-Service (DBaaS) clouds. If you feel that you belong on this list, but are not yet, please email pgsql-core@postgresql.org with a request to be included. This request should include:<br />
<br />
* your full name<br />
* your organization and/or company affiliation<br />
* what platforms or DBaaS cloud you do packaging for<br />
* your contact email<br />
* names of existing trusted PostgreSQL community members who can give you a reference<br />
<br />
For security reasons, the Packagers List needs to stay small, which means that requests which do not present a compelling reason to be on the list will be rejected.<br />
<br />
In order to have packages prepared and ready to download on the day releases are announced, the Packagers list is given access to the source code of the PostgreSQL release 48 to 72 hours before release time.<br />
<br />
=== Release Policy ===<br />
<br />
PostgreSQL security updates are primarily made available as [http://www.postgresql.org/support/versioning minor version] upgrades. You are always advised to use the latest minor version available, as it will likely also contain other non-security related fixes. All known security issues are always fixed in the next major release, when it comes out.<br />
<br />
=== Disclosure Timing ===<br />
<br />
Security issues which are already known to the public or for which demonstrated exploits exist "in the wild" will be discussed, fixed, and patched in the open on the normal PostgreSQL git mirrors and mailing lists. <br />
<br />
Minor security issues are handled simply by delaying commits until 72 hours before expected release time. This narrows the window between the disclosure of security issues in code and the availability of updated packages to one which we feel is reasonable and protects our users.<br />
<br />
If an unpublished security issue is considered sufficiently serious by the Core Team, they will issue a public notice of the date of the upcoming security release one to two weeks before the release so that users can be prepared to update their installations as soon as the release is available. This notice will not contain any details of the security issue. The PostgreSQL main git repository will then be closed to the public for the approximately three days during which packages are being built, in order to avoid premature disclosure. Criteria for seriousness in a security issue includes the number of users likely to be affected, the potential damage from exploits, and the level of existing access and knowledge required by an attacker.<br />
<br />
At this time, we are unable to provide advance notice of security details or code to any PostgreSQL end-users or application vendors, regardless of deployment size. While we understand the desire of some end-users to have access to security information and in-progress patches as soon as they are available, we cannot put the majority of our users, who depend on packages and installers, at risk. The PostgreSQL Project may revisit this policy in the future as our resources and the general thinking around security disclosure evolve.<br />
<br />
=== Supported Versions and Fixed Vulnerabilities ===<br />
<br />
PGDG believes that accuracy, completeness and availability of security information is essential for our users. We choose to pool all information on this one page, allowing easy searching for vulnerabilities by a range of criteria.<br />
<br />
The following table lists all known security issues. Please note that versions prior to 8.4 are no longer supported and vulnerabilities for these versions may not be included in this list. New vulnerabilities in these versions are no longer patched.<br />
<br />
Vulnerabilities list which major releases they were present in, and which version they are fixed in for each. If the vulnerability was exploitable without a valid login, this is also stated. They also list a vulnerability class, but we urge all users to read the description to determine if the bug affects specific installations or not.<br />
<br />
(List of fixes goes here)</div>Dpagehttp://wiki.postgresql.org/wiki/PGDay_NYC_2013_TalksPGDay NYC 2013 Talks2013-03-25T18:05:07Z<p>Dpage: </p>
<hr />
<div>= PGDay NYC 2013 Talks =<br />
<br />
== Friday March 22nd, 2013 ==<br />
<br />
=== Liberty Hall C ===<br />
<br />
* [http://momjian.us/main/writings/pgsql/locking.pdf Understanding the Postgres Lock Manager (Bruce Momjian)]<br />
* [http://plv8-talk.herokuapp.com/ Embracing the Web with JSON and PLV8 (Will Leinweber)]<br />
<br />
=== Liberty Hall A ===<br />
<br />
* [[:File:PPCD.pdf|Postgres Plus Cloud Database (Dave Page)]]<br />
<br />
[[Category:PostgreSQL Events]]</div>Dpagehttp://wiki.postgresql.org/wiki/File:PPCD.pdfFile:PPCD.pdf2013-03-25T18:03:20Z<p>Dpage: Postgres Plus Cloud Database enables you to quickly and cheaply deploy self-healing, elastic, highly available PostgreSQL or Postgres Plus Advanced Server database clusters in cloud and virtualised environments, such as Amazon AWS.
In this talk we'll look at the features offered, including:
- Storage scaling and auto scale-out
- Load balancing and high availability
- Backup and cloning
- Server configurability</p>
<hr />
<div>Postgres Plus Cloud Database enables you to quickly and cheaply deploy self-healing, elastic, highly available PostgreSQL or Postgres Plus Advanced Server database clusters in cloud and virtualised environments, such as Amazon AWS.<br />
<br />
In this talk we'll look at the features offered, including:<br />
<br />
- Storage scaling and auto scale-out<br />
- Load balancing and high availability<br />
- Backup and cloning<br />
- Server configurability</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2013_Developer_MeetingPgCon 2013 Developer Meeting2013-03-22T11:05:58Z<p>Dpage: /* Attendees */</p>
<hr />
<div>A meeting of the most active PostgreSQL developers is being planned for Wednesday 22nd May, 2013 near the University of Ottawa, prior to pgCon 2013. 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). <br />
<br />
Please note that this year the attendee numbers have been kept low in order 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.3 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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 8:30AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Jeff Davis<br />
* Andrew Dunstan<br />
* Peter Eisentraut<br />
* Dimitri Fontaine<br />
* Andres Freund<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Robert Haas<br />
* Magnus Hagander<br />
* Fujii Masao<br />
* Noah Misch<br />
* Bruce Momjian<br />
* Tom Lane<br />
* Dave Page<br />
* Simon Riggs<br />
* KaiGai Kohei<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* 9.4 Commitfest schedule<br />
* [http://wiki.postgresql.org/wiki/Parallel_Query_Execution Parallel Query Execution]</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2013_Developer_MeetingPgCon 2013 Developer Meeting2013-03-05T08:52:33Z<p>Dpage: /* Attendees */</p>
<hr />
<div>A meeting of the most active PostgreSQL developers is being planned for Wednesday 22nd May, 2013 near the University of Ottawa, prior to pgCon 2013. 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). <br />
<br />
Please note that this year the attendee numbers have been kept low in order 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.3 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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 8:30AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Jeff Davis<br />
* Andrew Dunstan<br />
* Peter Eisentraut<br />
* Dimitri Fontaine<br />
* Andres Freund<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Magnus Hagander<br />
* Alvaro Herrera<br />
* Fujii Masao<br />
* Noah Misch<br />
* Bruce Momjian<br />
* Tom Lane<br />
* Dave Page<br />
* Simon Riggs<br />
* KaiGai Kohei<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* 9.4 Commitfest schedule<br />
* [http://wiki.postgresql.org/wiki/Parallel_Query_Execution Parallel Query Execution]</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2013_Developer_MeetingPgCon 2013 Developer Meeting2013-03-01T08:25:09Z<p>Dpage: /* Attendees */</p>
<hr />
<div>A meeting of the most active PostgreSQL developers is being planned for Wednesday 22nd May, 2012 near the University of Ottawa, prior to pgCon 2013. 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). <br />
<br />
Please note that this year the attendee numbers have been kept low in order 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.3 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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 8:30AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Jeff Davis<br />
* Andrew Dunstan<br />
* Peter Eisentraut<br />
* Dimitri Fontaine<br />
* Andres Freund<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Magnus Hagander<br />
* Alvaro Herrera<br />
* Noah Misch<br />
* Bruce Momjian<br />
* Tom Lane<br />
* Dave Page<br />
* Simon Riggs<br />
* KaiGai Kohei<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* 9.4 Commitfest schedule<br />
* [http://wiki.postgresql.org/wiki/Parallel_Query_Execution Parallel Query Execution]</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2013_Developer_MeetingPgCon 2013 Developer Meeting2013-02-28T18:41:59Z<p>Dpage: /* Attendees */</p>
<hr />
<div>A meeting of the most active PostgreSQL developers is being planned for Wednesday 22nd May, 2012 near the University of Ottawa, prior to pgCon 2013. 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). <br />
<br />
Please note that this year the attendee numbers have been kept low in order 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.3 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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 8:30AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Jeff Davis<br />
* Andrew Dunstan<br />
* Dimitri Fontaine<br />
* Andres Freund<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Magnus Hagander<br />
* Alvaro Herrera<br />
* Noah Misch<br />
* Bruce Momjian<br />
* Tom Lane<br />
* Dave Page<br />
* Simon Riggs<br />
* KaiGai Kohei<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* 9.4 Commitfest schedule<br />
* [http://wiki.postgresql.org/wiki/Parallel_Query_Execution Parallel Query Execution]</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2013_Developer_MeetingPgCon 2013 Developer Meeting2013-02-28T16:49:58Z<p>Dpage: /* Attendees */</p>
<hr />
<div>A meeting of the most active PostgreSQL developers is being planned for Wednesday 22nd May, 2012 near the University of Ottawa, prior to pgCon 2013. 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). <br />
<br />
Please note that this year the attendee numbers have been kept low in order 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.3 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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 8:30AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Jeff Davis<br />
* Andrew Dunstan<br />
* Dimitri Fontaine<br />
* Andres Freund<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Magnus Hagander<br />
* Alvaro Herrera<br />
* Noah Misch<br />
* Tom Lane<br />
* Dave Page<br />
* Simon Riggs<br />
* KaiGai Kohei<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* 9.4 Commitfest schedule<br />
* [http://wiki.postgresql.org/wiki/Parallel_Query_Execution Parallel Query Execution]</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2013_Developer_MeetingPgCon 2013 Developer Meeting2013-02-28T16:49:30Z<p>Dpage: /* Attendees */</p>
<hr />
<div>A meeting of the most active PostgreSQL developers is being planned for Wednesday 22nd May, 2012 near the University of Ottawa, prior to pgCon 2013. 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). <br />
<br />
Please note that this year the attendee numbers have been kept low in order 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.3 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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 8:30AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Jeff Davis<br />
* Dimitri Fontaine<br />
* Andres Freund<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Magnus Hagander<br />
* Alvaro Herrera<br />
* Noah Misch<br />
* Tom Lane<br />
* Dave Page<br />
* Simon Riggs<br />
* KaiGai Kohei<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* 9.4 Commitfest schedule<br />
* [http://wiki.postgresql.org/wiki/Parallel_Query_Execution Parallel Query Execution]</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2013_Developer_MeetingPgCon 2013 Developer Meeting2013-02-28T16:05:55Z<p>Dpage: /* Attendees */</p>
<hr />
<div>A meeting of the most active PostgreSQL developers is being planned for Wednesday 22nd May, 2012 near the University of Ottawa, prior to pgCon 2013. 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). <br />
<br />
Please note that this year the attendee numbers have been kept low in order 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.3 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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 8:30AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Jeff Davis<br />
* Dimitri Fontaine<br />
* Andres Freund<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Magnus Hagander<br />
* Noah Misch<br />
* Tom Lane<br />
* Dave Page<br />
* Simon Riggs<br />
* KaiGai Kohei<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* 9.4 Commitfest schedule<br />
* [http://wiki.postgresql.org/wiki/Parallel_Query_Execution Parallel Query Execution]</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2013_Developer_MeetingPgCon 2013 Developer Meeting2013-02-08T09:17:04Z<p>Dpage: /* Attendees */</p>
<hr />
<div>A meeting of the most active PostgreSQL developers is being planned for Wednesday 22nd May, 2012 near the University of Ottawa, prior to pgCon 2013. 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). <br />
<br />
Please note that this year the attendee numbers have been kept low in order 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.3 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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 8:30AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Jeff Davis<br />
* Dimitri Fontaine<br />
* Andres Freund<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Magnus Hagander<br />
* Tom Lane<br />
* Dave Page<br />
* Simon Riggs<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* 9.4 Commitfest schedule<br />
* [http://wiki.postgresql.org/wiki/Parallel_Query_Execution Parallel Query Execution]</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2013_Developer_MeetingPgCon 2013 Developer Meeting2013-02-05T19:37:32Z<p>Dpage: /* Attendees */</p>
<hr />
<div>A meeting of the most active PostgreSQL developers is being planned for Wednesday 22nd May, 2012 near the University of Ottawa, prior to pgCon 2013. 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). <br />
<br />
Please note that this year the attendee numbers have been kept low in order 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.3 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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 8:30AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Dimitri Fontaine<br />
* Andres Freund<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Magnus Hagander<br />
* Tom Lane<br />
* Dave Page<br />
* Simon Riggs<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* 9.4 Commitfest schedule</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2013_Developer_MeetingPgCon 2013 Developer Meeting2013-02-05T19:26:20Z<p>Dpage: /* Attendees */</p>
<hr />
<div>A meeting of the most active PostgreSQL developers is being planned for Wednesday 22nd May, 2012 near the University of Ottawa, prior to pgCon 2013. 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). <br />
<br />
Please note that this year the attendee numbers have been kept low in order 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.3 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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 8:30AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Dimitri Fontaine<br />
* Peter Geoghegan<br />
* Magnus Hagander<br />
* Tom Lane<br />
* Dave Page<br />
* Simon Riggs<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* 9.4 Commitfest schedule</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2013_Developer_MeetingPgCon 2013 Developer Meeting2013-02-05T19:18:37Z<p>Dpage: /* Attendees */</p>
<hr />
<div>A meeting of the most active PostgreSQL developers is being planned for Wednesday 22nd May, 2012 near the University of Ottawa, prior to pgCon 2013. 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). <br />
<br />
Please note that this year the attendee numbers have been kept low in order 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.3 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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 8:30AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Dimitri Fontaine<br />
* Peter Geoghegan<br />
* Magnus Hagander<br />
* Tom Lane<br />
* Dave Page<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* 9.4 Commitfest schedule</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2013_Developer_MeetingPgCon 2013 Developer Meeting2013-02-05T17:17:04Z<p>Dpage: Created page with "A meeting of the most active PostgreSQL developers is being planned for Wednesday 22nd May, 2012 near the University of Ottawa, prior to pgCon 2013. In order to keep the numbers …"</p>
<hr />
<div>A meeting of the most active PostgreSQL developers is being planned for Wednesday 22nd May, 2012 near the University of Ottawa, prior to pgCon 2013. 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). <br />
<br />
Please note that this year the attendee numbers have been kept low in order 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.3 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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 8:30AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Dave Page<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* 9.4 Commitfest schedule</div>Dpagehttp://wiki.postgresql.org/wiki/PGDay_FOSDEM_2013PGDay FOSDEM 20132013-01-07T10:30:38Z<p>Dpage: /* Dinner */</p>
<hr />
<div>= PGDay FOSDEM 2013 =<br />
<br />
This is the first PgDay we hold in Belgium. FOSDEM PGDay 2013 will be held on Feb 1st in Brussels, Belgium, at the Radisson Blu Royal hotel. As an extension to the regular PostgreSQL devroom at FOSDEM, it will cover topics for PostgreSQL users, developers and contributors, and anybody else interested in PostgreSQL<br />
<br />
== Details ==<br />
<br />
* '''Date:''' Feb 01st, 2013 9am-5pm<br />
* '''Venue:''': Radisson Blu Royal Hotel<br />
* '''Coordinator:''': PostgreSQL Europe [mailto:contact@pgconf.eu contact@pgconf.eu]<br />
* '''Website:''': http://fosdem2013.pgconf.eu/<br />
<br />
== Registration ==<br />
<br />
Free attendance, web registration required: http://fosdem2013.pgconf.eu/registration/ (limited seats)<br />
<br />
== Schedule ==<br />
<br />
Schedule is be published at: http://fosdem2013.pgconf.eu/schedule/<br />
<br />
== Location and Venue ==<br />
<br />
http://fosdem2013.pgconf.eu/venue/<br />
<br />
Address: <br />
<br />
http://www.radissonblu.com/royalhotel-brussels/location<br />
<br />
<br />
== Dinner ==<br />
<br />
We are organizing a dinner after the event on Friday 1st, 2013 at Hard Rock Cafe Brussels. We have limited (30) number of seats, so please add your name to this list before going there.<br />
<br />
If you are bringing someone to the event, make sure you enter your name *twice* (or more) on the list, so the attendee count matches!<br />
<br />
Attendees:<br />
<br />
# Devrim Gündüz<br />
# Devrim Gündüz +1<br />
# Magnus Hagander<br />
# Andreas Scherbaum<br />
# Andreas Scherbaum +1<br />
# Jean-Paul Argudo<br />
# Patryk Kordylewski<br />
# Patryk Kordylewski +1<br />
# Dimitri Fontaine<br />
# Julien Rouhaud<br />
# Dave Page<br />
<br />
[[Category:PostgreSQL Events]]</div>Dpagehttp://wiki.postgresql.org/wiki/ReleasePrepReleasePrep2012-09-26T08:52:20Z<p>Dpage: /* 4 Hours Before Announce */</p>
<hr />
<div>Preparation Checklist for Minor Releases<br />
<br />
== 4-5 Days Before Announce ==<br />
<br />
* Contact translators to make sure that all translation strings are in (Peter Eisentraut)<br />
* Contact -packagers and warn them of release<br />
<br />
== 3-4 Days Before Announce ==<br />
<br />
* Upload source code, and notify -packagers<br />
* Have -packagers test source code<br />
* Contact Regional Contacts and warn them of upcoming release<br />
* Decide who's handling what for the release<br />
* Have WWW team prepare updates to the home page<br />
<br />
== 24 Hours Before Announce ==<br />
<br />
* Submit News item and have member of the WWW team check it<br />
* Upload binaries (make sure that Windows packagers are ready!)<br />
<br />
== 8 Hours Before Announce ==<br />
<br />
* Build new docs and commit them<br />
<br />
== 4 Hours Before Announce ==<br />
<br />
* Commit News item<br />
* Commit changes to home page<br />
* Update "What's New" link target on /docs and commit<br />
<br />
== The Announce E-mail ==<br />
<br />
* Must go out under an @postgresql.org e-mail address with no personal footer<br />
* Should be checked by:<br />
** The web team (links)<br />
** The core team & packagers (contents)<br />
* Check that new pages, downloads have propagated before sending out announce<br />
* Check links again!<br />
* If you don't have automatic -announce approval, make sure an -announce moderator is on duty<br />
<br />
== Day After Announce ==<br />
<br />
* Update Sourceforge<br />
* Update Freshmeat<br />
* Update #postgresql topic<br />
* Update version in [http://www.wikipedia.org/wiki/PostgreSQL Wikipedia]<br />
<br />
== Other Comments and Reminders ==<br />
<br />
1. Releases are performed only by community members with @postgresql.org. People known to announce releases are jdrake@postgresql.org, josh@postgresql.org and dpage@postgresql.org .<br />
<br />
2. If the release email has a signature, make sure it is referencing PostgreSQL and not the contributors private interests.<br />
<br />
3. Work with a web contributor or ready a patch for front page and developers/.<br />
<br />
4. Make sure docs are generated.<br />
<br />
* https://pgweb.postgresql.org/browser/trunk/portal/tools/docs/readme.txt<br />
<br />
If you can't get to that site, work with someone who can. (Magnus Hagander, Stefan Kaltenbrunner, Dave Page, Robert Treat)<br />
<br />
5. Ready email from <contributor>@postgresql.org to -general, -advocacy and<br />
-announce. <br />
<br />
* Check http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h just in case it is an initdb forcing release.<br />
<br />
6. Double check that 1,2,5 only contain references to @postgresql.org <br />
<br />
7. Confirm packages and symlinks are on ftp sites and mirrors have begun to propagate. <br />
<br />
8. Get confirmation from -packagers that the web patch looks good. You will need to work with your web contributor or set up a development sandbox for this.<br />
<br />
9. Work with operator on #postgresql to change topic. Commonly logged in operators are linuxpoet (Joshua Drake) and davidfetter (David Fetter)<br />
<br />
10. Once 1-9 are done<br />
<br />
* Get web patch committed. Insure it looks correct on wwwmaster<br />
* Wait for patch to propagate, this takes at least one hour(site gets build every hour at exactly :00) or can be forced through the admin interface on wwwmaster.<br />
* Send announcement to -general, -advocacy and -announce<br />
* If you are not an -announce moderator prepare a moderator in advance. Known moderators are jd@commandprompt.com (Joshua Drake) and xzilla@users.sourceforge.net (Robert Treat)<br />
11. Update SourceForge entry (devrim@gunduz.org)<br />
<br />
12. Update Freshmeat (scrappy@hub.org)<br />
<br />
<br />
<br />
[[Category:Advocacy]]<br />
[[Category:Policies]]</div>Dpagehttp://wiki.postgresql.org/wiki/PostgreSQL_9.2_Open_ItemsPostgreSQL 9.2 Open Items2012-08-31T15:04:12Z<p>Dpage: /* Blockers for 9.2 */</p>
<hr />
<div>== Project Planning ==<br />
See the [[PostgreSQL 9.2 Development Plan]].<br />
<br />
== Meta-Issues ==<br />
* Review "Long Term" list of items from [[PostgreSQL 9.0 Open Items]] and [[PostgreSQL 9.1 Open Items]]<br />
<br />
== Blockers for 9.2 ==<br />
<br />
* [http://archives.postgresql.org/pgsql-hackers/2012-08/msg01075.php pl/perl crash on win32] - pl/perl crashes on win32/MSVC++ builds with ActiveState Perl (the only distribution that we can use with MSVC++).<br />
<br />
== Not Blockers for 9.2 ==<br />
<br />
* [http://archives.postgresql.org/message-id/4E68EED9.3010205@enterprisedb.com Put a bound on memory usage when building large GiST indexes.] (see last paragraph of this mail)<br />
** seems like this is a nice to have, not essential -rhaas<br />
* [http://archives.postgresql.org/message-id/E1S3twb-0004OY-4g@wrigleys.postgresql.org simple_prompt uses wrong charset (Windows)]<br />
** is this bug any worse than any other open bug? we don't usually hold up releases for those. -rhaas<br />
** it's not new in 9.2, either - tgl<br />
* missing replication admin functions<br />
** more discussion and engineering is needed here, and the time for forcing initdb is past -rhaas<br />
* [http://archives.postgresql.org/message-id/25939.1333551641@sss.pgh.pa.us Should we fix tuple limit handling, or redefine 9.x behavior as correct?]<br />
** The consensus seems to be to change the documentation to match the current behavior, so this is just a pre-existing documentation bug, not a blocker.<br />
* [http://archives.postgresql.org/message-id/50066620.7090501@enterprisedb.com Recheck performance claims for checkpointer process split?]<br />
** The [http://archives.postgresql.org/message-id/9247.1342565810@sss.pgh.pa.us failure-to-fsync bug] in the original coding makes the previous measurements entirely untrustworthy. However, that change wasn't sold on pure performance grounds, so we'd probably keep it even if there is some adverse impact.<br />
* [http://archives.postgresql.org/message-id/CAMyN-kAsMj18rV9eshn4JX4Dn-JXbLMzC+eZ6wrnQ76FavaFfA@mail.gmail.com pg_ctl's adjust_data_dir fails on Windows when -D points to config-only directory]<br />
** [http://archives.postgresql.org/message-id/6C0B27F7206C9E4CA54AE035729E9C382852D5D8@szxeml509-mbs proposed patch]<br />
** This is not a regression because pg_ctl never really worked before anyway when -D points to a config-only directory.<br />
<br />
== Resolved Issues ==<br />
* [http://archives.postgresql.org/message-id/CAHGQGwH3ojxHOCrEfF09URojA3o4y+s5s6=fi3yqa53t-fx08Q@mail.gmail.com streaming backup should not be considered as sync standby.]<br />
* [http://archives.postgresql.org/pgsql-docs/2012-03/msg00000.php Documentation needs updating wrt visibility map/index-only scans]<br />
* [http://archives.postgresql.org/message-id/1324540338.7608.85.camel@jdavis change GiST implementation for range types?]<br />
* [http://archives.postgresql.org/message-id/E1S7Nac-0007gI-5X@wrigleys.postgresql.org pglesslog still referenced in docs, but no 9.1 support]<br />
* [http://archives.postgresql.org/message-id/9941.1333992643@sss.pgh.pa.us Should we change the behavior of extract(epoch from timestamp)?]<br />
* [http://archives.postgresql.org/message-id/CA+TgmoaMx5Pa5kRv_1=A9smDUxewn5j3iXqsvJbB8Q00WNejkg@mail.gmail.com search_path behavioral change]<br />
* [http://archives.postgresql.org/message-id/1333795920.26334.7.camel@vanquo.pezone.net Replace bytea_agg with string_agg(bytea,bytea)?]<br />
* [http://archives.postgresql.org/message-id/CAHGQGwEfXLQy4HsVozbkQ6cVc3QYA5U6r+=fpT1o5HFFZPA8Vw@mail.gmail.com pg_size_pretty(numeric)]<br />
* [http://archives.postgresql.org/message-id/CA+TgmoZquUD5Lm0oMEEGDOMWpMAwOtjbA57VBEb5gru2qe8f=w@mail.gmail.com Reconsider the names of valid values of synchronous_commit]<br />
** [http://archives.postgresql.org/message-id/CA+TgmoZ=ieWnQH7xePsQs9hePNyQhc2n8reSuwTzrbFpA6AxKQ@mail.gmail.com call for opinions]<br />
* [http://archives.postgresql.org/message-id/20120416102515.GF22182@tornado.leadboat.com nodes/*funcs.c inconsistencies]<br />
* [http://archives.postgresql.org/message-id/29248.1330468514@sss.pgh.pa.us Parameterized-path costing still needs some work]<br />
* [http://archives.postgresql.org/message-id/CANgU5Zf=8wjAaD7gFD_Q6ZcsKDAKHFBN_MWaFpenYVagdGMk=A@mail.gmail.com Change syntax for non-inherited CHECK constraints?]<br />
* [http://archives.postgresql.org/message-id/20120416205851.GA23994@tornado.leadboat.com Aggressive memory consumption in {ts,array}_typanalyze]<br />
* [http://archives.postgresql.org/message-id/24785.1325888715@sss.pgh.pa.us Auto-ANALYZE can prevent all-visible flags from getting set, leading to failure to use index-only scans]<br />
** I've hacked the regression test case to prevent the intermittent failure. Fixing auto-ANALYZE so that the problem doesn't arise would be nice, but it seems like a research project; added that to TODO.<br />
* [http://archives.postgresql.org/message-id/4F94A185.3010808@wulczer.org patch: plpython triggers are broken for composite-type columns]<br />
* [http://archives.postgresql.org/message-id/CA+TgmoYqLZK7x8UvacTsPq3N76gvQKczSsm4NfrYr7B3V8F2CA@mail.gmail.com Inconsistent units in pg_stat_statements]<br />
* [http://archives.postgresql.org/message-id/20120423163003.GB20512%40tornado.leadboat.com psql omits row count under "\x auto"]<br />
* Update the sample ps output in "monitoring-ps" section of the manual to include the new checkpointer process<br />
* [http://archives.postgresql.org/message-id/14492.1321575230@sss.pgh.pa.us Release-note PL case folding incompatibility]<br />
* [http://archives.postgresql.org/message-id/1333124720-sup-6193@alvh.no-ip.org checkpointer gets confused after crash-and-restart]<br />
** On closer inspection, this was pilot error, namely misuse of the postmaster -T feature.<br />
* Checkpointer latch loop [Simon]<br />
** I've hacked that area of the code until it looks OK to me, is there something else you had in mind? -- tgl - no thats fine - sr<br />
* Double check bgwriter/checkpointer comments<br />
** I made a pass over these, does anyone want to do more? -- tgl<br />
* Check new processes listed correctly in postmaster comments<br />
** I made a pass over these, does anyone want to do more? -- tgl<br />
* Make XLOG_HEAP2_VISIBLE records generate recovery snapshot conflicts so that IndexOnlyScans work on Hot Standby + bug fix by sr<br />
** [http://archives.postgresql.org/message-id/CA+TgmoaRhoYP=13PhkevEXhUDUscu7hjmN4GsRhH=tzGorKNRQ@mail.gmail.com analysis]<br />
** [http://archives.postgresql.org/message-id/E1SNYea-0003fr-JI@gemulon.postgresql.org committed patch] - still would be nice to throw a soft conflict instead of a hard one<br />
* Correct docs for SP-GIST so that example implementations shown/referred to/examples given - unusably opaque at present<br />
** Huh? There is a pointer to the example opclasses, and in general the SPGiST docs seem to me to be at least as good as those for GiST or GIN - tgl<br />
* [http://archives.postgresql.org/message-id/CAHGQGwFim5F61AfdLQH4PvARPr0Ace2=9QH62khYGraWY4E5TQ@mail.gmail.com pg_basebackup -x stream from the standby gets stuck if there is no traffic in the database]<br />
* [http://archives.postgresql.org/message-id/CAA-aLv58L6erSgNpnWU6Q-Ebe3LGajnneUzytePY65KdZYg5NA@mail.gmail.com pg_receivexlog requires manually restarting whenever the sending server restarts]<br />
** A brief discussion offline came up with the suggested options --auto-reconnect --auto-disconnect<br />
* Fix bug about not using InHotStandby when throwing recovery conflicts [Simon]<br />
* [http://archives.postgresql.org/message-id/CABUevEwyxHgFT=-J5udV0gTsS-B7cHtiaTF1ipFE83Q8oogkcw@mail.gmail.com Checkpointer doesn't send stats promptly] [Simon]<br />
* Fix start order: check pointer must start before bgwriter to catch fsync requests [Simon]<br />
* Bgwriter needs to close file handles [Simon]<br />
* [http://archives.postgresql.org/message-id/20120421165202.GA13458%40tornado.leadboat.com B-tree page deletion boundary cases] [Simon]<br />
* [http://archives.postgresql.org/message-id/1336587453.8747.6.camel@vanquo.pezone.net libpq URL syntax needs work for unix-socket addresses]<br />
** [http://archives.postgresql.org/message-id/87bolq3i9o.fsf@commandprompt.com proposed patch], [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=2d612abd4d330cd9d3f5a3f5936b20a6e837a69c commited]<br />
* [http://archives.postgresql.org/message-id/7108.1337992212@sss.pgh.pa.us pg_size_pretty(numeric)]<br />
** decided not to change this<br />
* [http://archives.postgresql.org/message-id/20120429200258.GB14509@tornado.leadboat.com Start warning on CREATE {GLOBAL | LOCAL} TEMPORARY TABLE?] [Simon]<br />
* [http://archives.postgresql.org/message-id/CAHGQGwFbqTDBrw95jek6_RvYG2=E-6o0HOpbeEcP6oWHJTLkUw@mail.gmail.com incorrect handling of the timeout in pg_receivexlog]<br />
* [http://archives.postgresql.org/message-id/CA%2BTgmoYKm5V%2BfCs30CyePg4jJCirpFNyMTjUTYh6DhzeksKLpg%40mail.gmail.com warning on incorrect parameters in libpq URL format is a potential security problem and should be changed to error]<br />
* scary checkpoint stuff<br />
* [http://archives.postgresql.org/pgsql-hackers/2012-06/msg00396.php pg_basebackup/pg_receivexlog vs sync rep]<br />
* [http://archives.postgresql.org/message-id/E1SkvNT-00066C-C4@wrigleys.postgresql.org alter table drop constraint does not work on inherited master table]<br />
* [http://archives.postgresql.org/message-id/1342648177.31327.10.camel@vanquo.pezone.net Reconsider CHECK NO INHERIT syntax?]<br />
* [http://archives.postgresql.org/message-id/20120615182151.GA8723@gmail.com Should we remove libpq row processor callback API in favor of row-at-a-time resultsets?]<br />
* [http://archives.postgresql.org/message-id/17129.1331607036@sss.pgh.pa.us SP-GiST is unsafe for use by hot standby slaves]<br />
* [http://archives.postgresql.org/message-id/CAHGQGwFhgWVVFybHCtO7BoaeLcGQ6Yf=pCUZMA-8P+vfWOQBvg@mail.gmail.com "pg_basebackup --xlog-method stream" may fail to take backup silently]<br />
* [http://archives.postgresql.org/message-id/CAHGQGwGgPO6GUNQ99yry8ykpg6ZHfz1W4OMdvcPWf2vxVcZVtQ@mail.gmail.com WAL files which were restored from the archive are archived again.] [http://archives.postgresql.org/message-id/20120605063730.GA26031@tornado.leadboat.com thread continuation] <br />
** [http://archives.postgresql.org/message-id/CAHGQGwHVYqbX=A+zo+AvFbVHLGoypO9G_QDKbabeXgXBVGd05g@mail.gmail.com proposed patch] [committed by Simon]<br />
* keepalives<br />
* [http://archives.postgresql.org/message-id/13980.1344720184@sss.pgh.pa.us View options are problematic for pg_dump]<br />
* [http://archives.postgresql.org/message-id/9247.1342565810@sss.pgh.pa.us Checkpointer process split broke fsync'ing]<br />
<br />
== Long-term Issues ==<br />
<br />
* [http://archives.postgresql.org/message-id/CAPpHfdvGticGniaj88VCHzHboXJobUhjLm6c09q_Op_u9EoBFg@mail.gmail.com GiST indexes vs fuzzy comparisons used by geometric types]<br />
** Alexander proposed a [http://archives.postgresql.org/message-id/CAPpHfdsgk+N=kf+HUn7CUtg6ThNQcKH6q3VZZwUzsB3zpjpRfA@mail.gmail.com narrow patch] that would support the current behavior, but I don't have a lot of confidence in it - tgl<br />
** The larger issue is whether we should modify or get rid of the whole fuzzy-comparison behavior in these data types.<br />
<br />
[[Category:PostgreSQL 9.2]]</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2012_Developer_MeetingPgCon 2012 Developer Meeting2012-05-16T12:19:02Z<p>Dpage: /* Time & Location */</p>
<hr />
<div>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). <br />
<br />
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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 8:30AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Oleg Bartunov<br />
* Josh Berkus (Secretary)<br />
* Jeff Davis<br />
* Andrew Dunstan<br />
* Dimitri Fontaine<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Robert Haas<br />
* Magnus Hagander<br />
* Shigeru Hanada<br />
* Hitoshi Harada<br />
* KaiGai Kohei<br />
* Tom Lane<br />
* Noah Misch<br />
* Bruce Momjian<br />
* Dave Page (Chair)<br />
* Simon Riggs<br />
* Teodor Sigaev<br />
* Greg Smith<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* Agree CommitFest schedule for 9.3 (Strawman from Simon)<br />
** CF1 June 15, 2012 - 1 month<br />
** CF2 Sep 15, 2012 - 1 month<br />
** CF3 Nov 15, 2012 - 1 month<br />
** CF4 Jan 15, 2013 - 2 months<br />
* Queuing [Dimitri, Kevin]<br />
** Description: efficient and transactional queuing is a very common need for application using databases, and could help implementing some internal features<br />
** 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<br />
* Materialized views [Kevin]<br />
** 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.<br />
** Goals: Reach consensus on what a minimum feature set for commit would be.<br />
* Partitioning and Segment Exclusion [Dimitri]<br />
** Description: to solve partitioning, we need to agree on a global approach<br />
** Goals: agreeing on SE as a basis for better partitioning, having a "GO" on working on SE<br />
* MERGE: Challenges and priorities [Peter G]<br />
** Description: Implementing the MERGE statement for 9.3. It is envisaged specifically as an atomic "upsert" operation.<br />
** 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.<br />
* Row-level Access Control and SELinux [KaiGai]<br />
** Security label on user tables<br />
** Dynamic expandable enum data types<br />
** Enforcement of triggers by extension<br />
* Enhancement of FDW at v9.3 [KaiGai]<br />
** Writable foreign tables<br />
** Stuffs to be pushed down (Join, Aggregate, Sort, ...)<br />
** Inheritance of foreign/regular tables<br />
** Constraint (PK/FK) & Trigger support.<br />
* Type registry [Andrew]<br />
** Provide for known OIDs for non-builtin types, and possibly for their IO functions too<br />
** Would make it possible to write code in core or in extension X that handles a type defined in extension Y.<br />
* 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]<br />
* What Developers Want [Josh]<br />
** Description: a top-5 list of features and obstacles to developer adoption of PostgreSQL (with slides)<br />
** Goal: to set priorities for some features aimed at application users<br />
* In-Place Upgrades & Checksums [Greg Smith, Simon]<br />
** Description: Revisit in-place upgrades of the page format, now that pg_upgrade is available and multiple checksum implementations needing it have been proposed.<br />
** Goal: Nail down some incremental milestones for 9.3 development to aim at.<br />
* Autonomous Transactions [Simon]<br />
** Overview of idea, relationship to stored procedures<br />
** Feedback, buy-in and/or alternatives<br />
* Parallel Query [Bruce Momjian]<br />
** Hope to get buy-in for what parallel operations we are hoping to add in upcoming releases<br />
* Report from Clustering Meeting [Josh] (10 min)<br />
** Description: to summarize the discussions of the cluster-hackers meeting from the previous day<br />
** Goal: inter-team synchronization. Possibly, decisions requested on specific in-core features.<br />
* Double Write Buffers [Simon]<br />
** Is anyone committing to do that for 9.3?<br />
<br />
* Goals, priorities, and resources for 9.3 [All]<br />
** 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.<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:30 - 08:45<br />
|Welcome and introductions<br />
|Dave Page<br />
<br />
|-<br />
|08:45 - 09:15<br />
|Autonomous transactions<br />
|Simon Riggs<br />
<br />
|-<br />
|09:15 - 09:40<br />
|Queuing<br />
|Dimitri Fontaine/Kevin Grittner<br />
<br />
|-<br />
|09:40 - 09:50<br />
|Report from the Clustering Meeting<br />
|Josh Berkus<br />
<br />
|-<br />
|09:50 - 10:10<br />
|Type registry<br />
|Andrew Dunstan<br />
<br />
|-<br />
|10:10 - 10:30<br />
|Access control and SELinux<br />
|KaiGai Kohei<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
<br />
|-<br />
|10:45 - 11:15<br />
|Enhancement of FDWs in 9.3<br />
|KaiGai Kohei<br />
<br />
|-<br />
|11:15 - 11:30<br />
|What developers want<br />
|Josh Berkus<br />
<br />
|-<br />
|11:30 - 12:00<br />
|Parallel Query<br />
|Bruce Momjian<br />
<br />
|-<br />
|12:00 - 12:30<br />
|MERGE: Challenges and priorities<br />
|Peter Geoghegan<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
<br />
|-<br />
|13:30 - 14:00<br />
|Materialised views<br />
|Kevin Grittner<br />
<br />
|-<br />
|14:00 - 14:20<br />
|In place upgrades and checksums<br />
|Simon Riggs/Greg Smith<br />
<br />
|-<br />
|14:20 - 14:45<br />
|Partitioning and segment exclusion<br />
|Dimitri Fontaine<br />
<br />
|-<br />
|14:45 - 15:00<br />
|Commitfest Schedule<br />
|All<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
<br />
|-<br />
|15:15 - 15:40<br />
|Commitfest management<br />
|Robert Haas<br />
<br />
|-<br />
|15:40 - 16:45<br />
|Goals, priorities, and resources for 9.3<br />
|All<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}<br />
<br />
==Minutes==</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2012_Developer_MeetingPgCon 2012 Developer Meeting2012-05-09T15:08:20Z<p>Dpage: /* Agenda */</p>
<hr />
<div>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). <br />
<br />
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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 9AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Oleg Bartunov<br />
* Josh Berkus (Secretary)<br />
* Jeff Davis<br />
* Andrew Dunstan<br />
* Dimitri Fontaine<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Robert Haas<br />
* Magnus Hagander<br />
* Shigeru Hanada<br />
* Hitoshi Harada<br />
* KaiGai Kohei<br />
* Tom Lane<br />
* Noah Misch<br />
* Bruce Momjian<br />
* Dave Page (Chair)<br />
* Simon Riggs<br />
* Teodor Sigaev<br />
* Greg Smith<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* Agree CommitFest schedule for 9.3 (Strawman from Simon)<br />
** CF1 June 15, 2012 - 1 month<br />
** CF2 Sep 15, 2012 - 1 month<br />
** CF3 Nov 15, 2012 - 1 month<br />
** CF4 Jan 15, 2013 - 2 months<br />
* Priorities for 9.3 [All]<br />
** Description: discuss what people are working on and what's likely to be in 9.3.<br />
** Goals: set expectations and coordinate work schedules for 9.3.<br />
* Queuing [Dimitri, Kevin]<br />
** Description: efficient and transactional queuing is a very common need for application using databases, and could help implementing some internal features<br />
** 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<br />
* Materialized views [Kevin]<br />
** 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.<br />
** Goals: Reach consensus on what a minimum feature set for commit would be.<br />
* Partitioning and Segment Exclusion [Dimitri]<br />
** Description: to solve partitioning, we need to agree on a global approach<br />
** Goals: agreeing on SE as a basis for better partitioning, having a "GO" on working on SE<br />
* The MERGE statement: Challenges and priorities [Peter G]<br />
** Description: Implementing the MERGE statement for 9.3. It is envisaged specifically as an atomic "upsert" operation.<br />
** 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.<br />
* Row-level Access Control and SELinux [KaiGai]<br />
** Security label on user tables<br />
** Dynamic expandable enum data types<br />
** Enforcement of triggers by extension<br />
* Enhancement of FDW at v9.3 [KaiGai]<br />
** Writable foreign tables<br />
** Stuffs to be pushed down (Join, Aggregate, Sort, ...)<br />
** Inheritance of foreign/regular tables<br />
** Constraint (PK/FK) & Trigger support.<br />
* Type registry [Andrew]<br />
** Provide for known OIDs for non-builtin types, and possibly for their IO functions too<br />
** Would make it possible to write code in core or in extension X that handles a type defined in extension Y.<br />
* 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]<br />
* What Developers Want [Josh]<br />
** Description: a top-5 list of features and obstacles to developer adoption of PostgreSQL (with slides)<br />
** Goal: to set priorities for some features aimed at application users<br />
* In-Place Upgrades & Checksums [Greg Smith, Simon]<br />
** Description: Revisit in-place upgrades of the page format, now that pg_upgrade is available and multiple checksum implementations needing it have been proposed.<br />
** Goal: Nail down some incremental milestones for 9.3 development to aim at.<br />
* Autonomous Transactions [Simon]<br />
** Overview of idea, relationship to stored procedures<br />
** Feedback, buy-in and/or alternatives<br />
* Parallel Query [Bruce Momjian]<br />
** Hope to get buy-in for what parallel operations we are hoping to add in upcoming releases<br />
* Report from Clustering Meeting [Josh] (10 min)<br />
** Description: to summarize the discussions of the cluster-hackers meeting from the previous day<br />
** Goal: inter-team synchronization. Possibly, decisions requested on specific in-core features.<br />
* Double Write Buffers [Simon]<br />
** Is anyone committing to do that for 9.3?<br />
* Summarise Commitments at End of Play [Simon]<br />
** For roadmap and planning purposes, confirm who is doing what, assign interested reviewers at start<br />
** Check gaps, identif priorities early on in cycle<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:30 - 08:45<br />
|Welcome and introductions<br />
|Dave Page<br />
<br />
|-<br />
|08:45 - 09:10<br />
|Goals for 9.3<br />
|Josh Berkus<br />
<br />
|-<br />
|09:10 - 09:35<br />
|Commitfest management<br />
|Robert Haas<br />
<br />
|-<br />
|09:35 - 09:50<br />
|9.2 commitfest schedule<br />
|Simon Riggs<br />
<br />
|-<br />
|09:50 - 10:10<br />
|Type registry<br />
|Andrew Dunstan<br />
<br />
|-<br />
|10:10 - 10:30<br />
|Access control and SELinux<br />
|KaiGai Kohei<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
<br />
|-<br />
|10:45 - 11:15<br />
|Enhancement of FDWs in 9.3<br />
|KaiGai Kohei<br />
<br />
|-<br />
|11:15 - 11:40<br />
|Autonomous transactions<br />
|Simon Riggs<br />
<br />
|-<br />
|11:40 - 12:05<br />
|Partitioning and segment exclusion<br />
|Dimitri Fontaine<br />
<br />
|-<br />
|12:05 - 12:30<br />
|Queuing<br />
|Dimitri Fontaine/Kevin Grittner<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
<br />
|-<br />
|13:30 - 14:00<br />
|What developers want<br />
|Josh Berkus<br />
<br />
|-<br />
|14:00 - 14:30<br />
|The MERGE statement: Challenges and priorities<br />
|Peter Geogehan<br />
<br />
|-<br />
|14:30 - 15:00<br />
|Materialised views<br />
|Kevin Grittner<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
<br />
|-<br />
|15:15 - 15:45<br />
|In place upgrades and checksums<br />
|Simon Riggs/Greg Smith<br />
<br />
|-<br />
|15:45 - 16:15<br />
|Parallel Query<br />
|Bruce Momjian<br />
<br />
|-<br />
|16:15 - 16:25<br />
|Report from the Clustering Meeting<br />
|Josh Berkus<br />
<br />
|-<br />
|16:25 - 16:45<br />
|Summarise commitments and identify priorities<br />
|Simon Riggs<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}<br />
<br />
==Minutes==</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2012_Developer_MeetingPgCon 2012 Developer Meeting2012-05-09T12:51:02Z<p>Dpage: /* Agenda */</p>
<hr />
<div>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). <br />
<br />
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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 9AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Oleg Bartunov<br />
* Josh Berkus (Secretary)<br />
* Jeff Davis<br />
* Andrew Dunstan<br />
* Dimitri Fontaine<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Robert Haas<br />
* Magnus Hagander<br />
* Shigeru Hanada<br />
* Hitoshi Harada<br />
* KaiGai Kohei<br />
* Tom Lane<br />
* Noah Misch<br />
* Bruce Momjian<br />
* Dave Page (Chair)<br />
* Simon Riggs<br />
* Teodor Sigaev<br />
* Greg Smith<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* Agree CommitFest schedule for 9.3 (Strawman from Simon)<br />
** CF1 June 15, 2012 - 1 month<br />
** CF2 Sep 15, 2012 - 1 month<br />
** CF3 Nov 15, 2012 - 1 month<br />
** CF4 Jan 15, 2013 - 2 months<br />
* Priorities for 9.3 [All]<br />
** Description: discuss what people are working on and what's likely to be in 9.3.<br />
** Goals: set expectations and coordinate work schedules for 9.3.<br />
* Queuing [Dimitri, Kevin]<br />
** Description: efficient and transactional queuing is a very common need for application using databases, and could help implementing some internal features<br />
** 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<br />
* Materialized views [Kevin]<br />
** 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.<br />
** Goals: Reach consensus on what a minimum feature set for commit would be.<br />
* Partitioning and Segment Exclusion [Dimitri]<br />
** Description: to solve partitioning, we need to agree on a global approach<br />
** Goals: agreeing on SE as a basis for better partitioning, having a "GO" on working on SE<br />
* The MERGE statement: Challenges and priorities [Peter G]<br />
** Description: Implementing the MERGE statement for 9.3. It is envisaged specifically as an atomic "upsert" operation.<br />
** 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.<br />
* Row-level Access Control and SELinux [KaiGai]<br />
** Security label on user tables<br />
** Dynamic expandable enum data types<br />
** Enforcement of triggers by extension<br />
* Enhancement of FDW at v9.3 [KaiGai]<br />
** Writable foreign tables<br />
** Stuffs to be pushed down (Join, Aggregate, Sort, ...)<br />
** Inheritance of foreign/regular tables<br />
** Constraint (PK/FK) & Trigger support.<br />
* Type registry [Andrew]<br />
** Provide for known OIDs for non-builtin types, and possibly for their IO functions too<br />
** Would make it possible to write code in core or in extension X that handles a type defined in extension Y.<br />
* 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]<br />
* What Developers Want [Josh]<br />
** Description: a top-5 list of features and obstacles to developer adoption of PostgreSQL (with slides)<br />
** Goal: to set priorities for some features aimed at application users<br />
* In-Place Upgrades & Checksums [Greg Smith, Simon]<br />
** Description: Revisit in-place upgrades of the page format, now that pg_upgrade is available and multiple checksum implementations needing it have been proposed.<br />
** Goal: Nail down some incremental milestones for 9.3 development to aim at.<br />
* Autonomous Transactions [Simon]<br />
** Overview of idea, relationship to stored procedures<br />
** Feedback, buy-in and/or alternatives<br />
* Parallel Query [Bruce Momjian]<br />
** Hope to get buy-in for what parallel operations we are hoping to add in upcoming releases<br />
* Report from Clustering Meeting [Josh] (10 min)<br />
** Description: to summarize the discussions of the cluster-hackers meeting from the previous day<br />
** Goal: inter-team synchronization. Possibly, decisions requested on specific in-core features.<br />
* Double Write Buffers [Simon]<br />
** Is anyone committing to do that for 9.3?<br />
* Summarise Commitments at End of Play [Simon]<br />
** For roadmap and planning purposes, confirm who is doing what, assign interested reviewers at start<br />
** Check gaps, identif priorities early on in cycle<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:30 - 08:45<br />
|Welcome and introductions<br />
|Dave Page<br />
<br />
|-<br />
|08:45 - 09:00<br />
|9.2 commitfest schedule<br />
|Simon Riggs<br />
<br />
|-<br />
|09:00 - 09:30<br />
|Goals for 9.3<br />
|Josh Berkus<br />
<br />
|-<br />
|09:30 - 10:00<br />
|The MERGE statement: Challenges and priorities<br />
|Peter Geogehan<br />
<br />
|-<br />
|10:00 - 10:30<br />
|Materialised views<br />
|Kevin Grittner<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
<br />
|-<br />
|10:45 - 11:15<br />
|Enhancement of FDWs in 9.3<br />
|KaiGai Kohei<br />
<br />
|-<br />
|11:15 - 11:45<br />
|Autonomous transactions<br />
|Simon Riggs<br />
<br />
|-<br />
|11:45 - 12:15<br />
|Partitioning and segment exclusion<br />
|Dimitri Fontaine<br />
<br />
|-<br />
|12:15 - 12:30<br />
|Queuing<br />
|Dimitri Fontaine/Kevin Grittner<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
<br />
|-<br />
|13:30 - 14:00<br />
|What developers want<br />
|Josh Berkus<br />
<br />
|-<br />
|14:00 - 14:20<br />
|Commitfest management<br />
|Robert Haas<br />
<br />
|-<br />
|14:20 - 14:40<br />
|Type registry<br />
|Andrew Dunstan<br />
<br />
|-<br />
|14:40 - 15:00<br />
|Access control and SELinux<br />
|KaiGai Kohei<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
<br />
|-<br />
|15:15 - 15:45<br />
|In place upgrades and checksums<br />
|Simon Riggs/Greg Smith<br />
<br />
|-<br />
|15:45 - 16:15<br />
|Parallel Query<br />
|Bruce Momjian<br />
<br />
|-<br />
|16:15 - 16:25<br />
|Report from the Clustering Meeting<br />
|Josh Berkus<br />
<br />
|-<br />
|16:25 - 16:45<br />
|Summarise commitments and identify priorities<br />
|Simon Riggs<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}<br />
<br />
==Minutes==</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2012_Developer_MeetingPgCon 2012 Developer Meeting2012-05-09T12:49:48Z<p>Dpage: /* Agenda */</p>
<hr />
<div>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). <br />
<br />
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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 9AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Oleg Bartunov<br />
* Josh Berkus (Secretary)<br />
* Jeff Davis<br />
* Andrew Dunstan<br />
* Dimitri Fontaine<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Robert Haas<br />
* Magnus Hagander<br />
* Shigeru Hanada<br />
* Hitoshi Harada<br />
* KaiGai Kohei<br />
* Tom Lane<br />
* Noah Misch<br />
* Bruce Momjian<br />
* Dave Page (Chair)<br />
* Simon Riggs<br />
* Teodor Sigaev<br />
* Greg Smith<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* Agree CommitFest schedule for 9.3 (Strawman from Simon)<br />
** CF1 June 15, 2012 - 1 month<br />
** CF2 Sep 15, 2012 - 1 month<br />
** CF3 Nov 15, 2012 - 1 month<br />
** CF4 Jan 15, 2013 - 2 months<br />
* Priorities for 9.3 [All]<br />
** Description: discuss what people are working on and what's likely to be in 9.3.<br />
** Goals: set expectations and coordinate work schedules for 9.3.<br />
* Queuing [Dimitri, Kevin]<br />
** Description: efficient and transactional queuing is a very common need for application using databases, and could help implementing some internal features<br />
** 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<br />
* Materialized views [Kevin]<br />
** 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.<br />
** Goals: Reach consensus on what a minimum feature set for commit would be.<br />
* Partitioning and Segment Exclusion [Dimitri]<br />
** Description: to solve partitioning, we need to agree on a global approach<br />
** Goals: agreeing on SE as a basis for better partitioning, having a "GO" on working on SE<br />
* The MERGE statement: Challenges and priorities [Peter G]<br />
** Description: Implementing the MERGE statement for 9.3. It is envisaged specifically as an atomic "upsert" operation.<br />
** 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.<br />
* Row-level Access Control and SELinux [KaiGai]<br />
** Security label on user tables<br />
** Dynamic expandable enum data types<br />
** Enforcement of triggers by extension<br />
* Enhancement of FDW at v9.3 [KaiGai]<br />
** Writable foreign tables<br />
** Stuffs to be pushed down (Join, Aggregate, Sort, ...)<br />
** Inheritance of foreign/regular tables<br />
** Constraint (PK/FK) & Trigger support.<br />
* Type registry [Andrew]<br />
** Provide for known OIDs for non-builtin types, and possibly for their IO functions too<br />
** Would make it possible to write code in core or in extension X that handles a type defined in extension Y.<br />
* 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]<br />
* What Developers Want [Josh]<br />
** Description: a top-5 list of features and obstacles to developer adoption of PostgreSQL (with slides)<br />
** Goal: to set priorities for some features aimed at application users<br />
* In-Place Upgrades & Checksums [Greg Smith, Simon]<br />
** Description: Revisit in-place upgrades of the page format, now that pg_upgrade is available and multiple checksum implementations needing it have been proposed.<br />
** Goal: Nail down some incremental milestones for 9.3 development to aim at.<br />
* Autonomous Transactions [Simon]<br />
** Overview of idea, relationship to stored procedures<br />
** Feedback, buy-in and/or alternatives<br />
* Parallel Query [Bruce Momjian]<br />
** Hope to get buy-in for what parallel operations we are hoping to add in upcoming releases<br />
* Report from Clustering Meeting [Josh] (10 min)<br />
** Description: to summarize the discussions of the cluster-hackers meeting from the previous day<br />
** Goal: inter-team synchronization. Possibly, decisions requested on specific in-core features.<br />
* Double Write Buffers [Simon]<br />
** Is anyone committing to do that for 9.3?<br />
* Summarise Commitments at End of Play [Simon]<br />
** For roadmap and planning purposes, confirm who is doing what, assign interested reviewers at start<br />
** Check gaps, identif priorities early on in cycle<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:30 - 08:45<br />
|Welcome and introductions<br />
|Dave Page<br />
<br />
|-<br />
|08:45 - 09:00<br />
|9.2 commitfest schedule<br />
|Simon Riggs<br />
<br />
|-<br />
|09:00 - 09:30<br />
|Goals for 9.3<br />
|???<br />
<br />
|-<br />
|09:30 - 10:00<br />
|The MERGE statement: Challenges and priorities<br />
|Peter Geogehan<br />
<br />
|-<br />
|10:00 - 10:30<br />
|Materialised views<br />
|Kevin Grittner<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
<br />
|-<br />
|10:45 - 11:15<br />
|Enhancement of FDWs in 9.3<br />
|KaiGai Kohei<br />
<br />
|-<br />
|11:15 - 11:45<br />
|Autonomous transactions<br />
|Simon Riggs<br />
<br />
|-<br />
|11:45 - 12:15<br />
|Partitioning and segment exclusion<br />
|Dimitri Fontaine<br />
<br />
|-<br />
|12:15 - 12:30<br />
|Queuing<br />
|Dimitri Fontaine/Kevin Grittner<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
<br />
|-<br />
|13:30 - 14:00<br />
|What developers want<br />
|Josh Berkus<br />
<br />
|-<br />
|14:00 - 14:20<br />
|Commitfest management<br />
|Robert Haas<br />
<br />
|-<br />
|14:20 - 14:40<br />
|Type registry<br />
|Andrew Dunstan<br />
<br />
|-<br />
|14:40 - 15:00<br />
|Access control and SELinux<br />
|KaiGai Kohei<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
<br />
|-<br />
|15:15 - 15:45<br />
|In place upgrades and checksums<br />
|Simon Riggs/Greg Smith<br />
<br />
|-<br />
|15:45 - 16:15<br />
|Parallel Query<br />
|Bruce Momjian<br />
<br />
|-<br />
|16:15 - 16:25<br />
|Report from the Clustering Meeting<br />
|Josh Berkus<br />
<br />
|-<br />
|16:25 - 16:45<br />
|Summarise commitments and identify priorities<br />
|Simon Riggs<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}<br />
<br />
==Minutes==</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2012_Developer_MeetingPgCon 2012 Developer Meeting2012-03-13T12:23:33Z<p>Dpage: /* Attendees */</p>
<hr />
<div>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). <br />
<br />
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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 9AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Oleg Bartunov<br />
* Josh Berkus (Secretary)<br />
* Jeff Davis<br />
* Andrew Dunstan<br />
* Dimitri Fontaine<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Robert Haas<br />
* Magnus Hagander<br />
* Shigeru Hanada<br />
* Hitoshi Harada<br />
* KaiGai Kohei<br />
* Tom Lane<br />
* Noah Misch<br />
* Bruce Momjian<br />
* Dave Page (Chair)<br />
* Simon Riggs<br />
* Teodor Sigaev<br />
* Greg Smith<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* Queuing [Dimitri, Kevin]<br />
* Materialized views [Dimitri, Kevin]<br />
* Partitioning and Segment Exclusion [Dimitri]<br />
* Row-level Access Control and SELinux [KaiGai]<br />
** Security label on user tables<br />
** Dynamic expandable enum data types<br />
** Enforcement of triggers by extension<br />
* Enhancement of FDW at v9.3 [KaiGai]<br />
** Writable foreign tables<br />
** Stuffs to be pushed down (Join, Aggregate, Sort, ...)<br />
** Inheritance of foreign/regular tables<br />
** Constraint (PK/FK) & Trigger support.<br />
* GPU Acceleration [KaiGai]<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:45 - 09:00<br />
|Welcome and introductions<br />
|Dave Page<br />
|-<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}<br />
<br />
<br />
==Minutes==</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2012_Developer_MeetingPgCon 2012 Developer Meeting2012-03-05T10:52:30Z<p>Dpage: /* Attendees */</p>
<hr />
<div>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). <br />
<br />
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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 9AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Oleg Bartunov<br />
* Josh Berkus (Secretary)<br />
* Jeff Davis<br />
* Andrew Dunstan<br />
* Dimitri Fontaine<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Robert Haas<br />
* Magnus Hagander<br />
* Hitoshi Harada<br />
* KaiGai Kohei<br />
* Tom Lane<br />
* Noah Misch<br />
* Bruce Momjian<br />
* Dave Page (Chair)<br />
* Simon Riggs<br />
* Teodor Sigaev<br />
* Greg Smith<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* Queuing [Dimitri, Kevin]<br />
* Materialized views [Dimitri, Kevin]<br />
* Partitioning and Segment Exclusion [Dimitri]<br />
* Row-level Access Control and SELinux [KaiGai]<br />
** Security label on user tables<br />
** Dynamic expandable enum data types<br />
** Enforcement of triggers by extension<br />
* Enhancement of FDW at v9.3 [KaiGai]<br />
** Writable foreign tables<br />
** Stuffs to be pushed down (Join, Aggregate, Sort, ...)<br />
** Inheritance of foreign/regular tables<br />
** Constraint (PK/FK) & Trigger support.<br />
* GPU Acceleration [KaiGai]<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:45 - 09:00<br />
|Welcome and introductions<br />
|Dave Page<br />
|-<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}<br />
<br />
<br />
==Minutes==</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2012_Developer_MeetingPgCon 2012 Developer Meeting2012-03-01T13:54:28Z<p>Dpage: /* Attendees */</p>
<hr />
<div>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). <br />
<br />
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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 9AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Oleg Bartunov<br />
* Josh Berkus (Secretary)<br />
* Jeff Davis<br />
* Andrew Dunstan<br />
* Dimitri Fontaine<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Robert Haas<br />
* Magnus Hagander<br />
* Hitoshi Harada<br />
* KaiGai Kohei<br />
* Tom Lane<br />
* Bruce Momjian<br />
* Dave Page (Chair)<br />
* Simon Riggs<br />
* Teodor Sigaev<br />
* Greg Smith<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* Queuing [Dimitri]<br />
* Materialized views [Dimitri, Kevin?]<br />
* Partitioning and Segment Exclusion [Dimitri]<br />
* Row-level Access Control and SELinux [KaiGai]<br />
** Security label on user tables<br />
** Dynamic expandable enum data types<br />
** Enforcement of triggers by extension<br />
* Enhancement of FDW at v9.3 [KaiGai]<br />
** Writable foreign tables<br />
** Stuffs to be pushed down (Join, Aggregate, Sort, ...)<br />
** Inheritance of foreign/regular tables<br />
** Constraint (PK/FK) & Trigger support.<br />
* GPU Acceleration [KaiGai]<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:45 - 09:00<br />
|Welcome and introductions<br />
|Dave Page<br />
|-<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}<br />
<br />
<br />
==Minutes==</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2012_Developer_MeetingPgCon 2012 Developer Meeting2012-03-01T13:32:38Z<p>Dpage: /* Attendees */</p>
<hr />
<div>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). <br />
<br />
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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 9AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Oleg Bartunov<br />
* Josh Berkus (Secretary)<br />
* Jeff Davis<br />
* Andrew Dunstan<br />
* Dimitri Fontaine<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Robert Haas<br />
* Magnus Hagander<br />
* Hitoshi Harada<br />
* KaiGai Kohei<br />
* Tom Lane<br />
* Dave Page (Chair)<br />
* Simon Riggs<br />
* Teodor Sigaev<br />
* Greg Smith<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* Queuing [Dimitri]<br />
* Materialized views [Dimitri, Kevin?]<br />
* Partitioning and Segment Exclusion [Dimitri]<br />
* Row-level Access Control and SELinux [KaiGai]<br />
** Security label on user tables<br />
** Dynamic expandable enum data types<br />
** Enforcement of triggers by extension<br />
* Enhancement of FDW at v9.3 [KaiGai]<br />
** Writable foreign tables<br />
** Stuffs to be pushed down (Join, Aggregate, Sort, ...)<br />
** Inheritance of foreign/regular tables<br />
** Constraint (PK/FK) & Trigger support.<br />
* GPU Acceleration [KaiGai]<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:45 - 09:00<br />
|Welcome and introductions<br />
|Dave Page<br />
|-<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}<br />
<br />
<br />
==Minutes==</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2012_Developer_MeetingPgCon 2012 Developer Meeting2012-03-01T13:11:36Z<p>Dpage: /* Attendees */</p>
<hr />
<div>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). <br />
<br />
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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 9AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Oleg Bartunov<br />
* Josh Berkus (Secretary)<br />
* Jeff Davis<br />
* Dimitri Fontaine<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Kevin Grittner<br />
* Robert Haas<br />
* Magnus Hagander<br />
* Hitoshi Harada<br />
* KaiGai Kohei<br />
* Tom Lane<br />
* Dave Page (Chair)<br />
* Simon Riggs<br />
* Teodor Sigaev<br />
* Greg Smith<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* Queuing [Dimitri]<br />
* Materialized views [Dimitri, Kevin?]<br />
* Partitioning and Segment Exclusion [Dimitri]<br />
* Row-level Access Control and SELinux [KaiGai]<br />
** Security label on user tables<br />
** Dynamic expandable enum data types<br />
** Enforcement of triggers by extension<br />
* Enhancement of FDW at v9.3 [KaiGai]<br />
** Writable foreign tables<br />
** Stuffs to be pushed down (Join, Aggregate, Sort, ...)<br />
** Inheritance of foreign/regular tables<br />
** Constraint (PK/FK) & Trigger support.<br />
* GPU Acceleration [KaiGai]<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:45 - 09:00<br />
|Welcome and introductions<br />
|Dave Page<br />
|-<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}<br />
<br />
<br />
==Minutes==</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2012_Developer_MeetingPgCon 2012 Developer Meeting2012-03-01T12:48:02Z<p>Dpage: /* Attendees */</p>
<hr />
<div>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). <br />
<br />
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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 9AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Oleg Bartunov<br />
* Josh Berkus (Secretary)<br />
* Jeff Davis<br />
* Dimitri Fontaine<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Robert Haas<br />
* Magnus Hagander<br />
* Hitoshi Harada<br />
* KaiGai Kohei<br />
* Tom Lane<br />
* Dave Page (Chair)<br />
* Simon Riggs<br />
* Teodor Sigaev<br />
* Greg Smith<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* Queuing [Dimitri]<br />
* Materialized views [Dimitri, Kevin?]<br />
* Partitioning and Segment Exclusion [Dimitri]<br />
* Row-level Access Control and SELinux [KaiGai]<br />
** Security label on user tables<br />
** Dynamic expandable enum data types<br />
** Enforcement of triggers by extension<br />
* Enhancement of FDW at v9.3 [KaiGai]<br />
** Writable foreign tables<br />
** Stuffs to be pushed down (Join, Aggregate, Sort, ...)<br />
** Inheritance of foreign/regular tables<br />
** Constraint (PK/FK) & Trigger support.<br />
* GPU Acceleration [KaiGai]<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:45 - 09:00<br />
|Welcome and introductions<br />
|Dave Page<br />
|-<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}<br />
<br />
<br />
==Minutes==</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2012_Developer_MeetingPgCon 2012 Developer Meeting2012-03-01T11:40:18Z<p>Dpage: /* Attendees */</p>
<hr />
<div>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). <br />
<br />
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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 9AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Oleg Bartunov<br />
* Josh Berkus (Secretary)<br />
* Jeff Davis<br />
* Dimitri Fontaine<br />
* Stephen Frost<br />
* Peter Geoghegan<br />
* Magnus Hagander<br />
* Hitoshi Harada<br />
* KaiGai Kohei<br />
* Tom Lane<br />
* Dave Page (Chair)<br />
* Simon Riggs<br />
* Teodor Sigaev<br />
* Greg Smith<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* Queuing [Dimitri]<br />
* Materialized views [Dimitri, Kevin?]<br />
* Partitioning and Segment Exclusion [Dimitri]<br />
* Row-level Access Control and SELinux [KaiGai]<br />
** Security label on user tables<br />
** Dynamic expandable enum data types<br />
** Enforcement of triggers by extension<br />
* Enhancement of FDW at v9.3 [KaiGai]<br />
** Writable foreign tables<br />
** Stuffs to be pushed down (Join, Aggregate, Sort, ...)<br />
** Inheritance of foreign/regular tables<br />
** Constraint (PK/FK) & Trigger support.<br />
* GPU Acceleration [KaiGai]<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:45 - 09:00<br />
|Welcome and introductions<br />
|Dave Page<br />
|-<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}<br />
<br />
<br />
==Minutes==</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2012_Developer_MeetingPgCon 2012 Developer Meeting2012-03-01T11:09:45Z<p>Dpage: /* Attendees */</p>
<hr />
<div>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). <br />
<br />
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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 9AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Oleg Bartunov<br />
* Josh Berkus (Secretary)<br />
* Jeff Davis<br />
* Dimitri Fontaine<br />
* Peter Geoghegan<br />
* Magnus Hagander<br />
* Hitoshi Harada<br />
* KaiGai Kohei<br />
* Tom Lane<br />
* Dave Page (Chair)<br />
* Simon Riggs<br />
* Teodor Sigaev<br />
* Greg Smith<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* Queuing [Dimitri]<br />
* Materialized views [Dimitri, Kevin?]<br />
* Partitioning and Segment Exclusion [Dimitri]<br />
* Row-level Access Control and SELinux [KaiGai]<br />
** Security label on user tables<br />
** Dynamic expandable enum data types<br />
** Enforcement of triggers by extension<br />
* Enhancement of FDW at v9.3 [KaiGai]<br />
** Writable foreign tables<br />
** Stuffs to be pushed down (Join, Aggregate, Sort, ...)<br />
** Inheritance of foreign/regular tables<br />
** Constraint (PK/FK) & Trigger support.<br />
* GPU Acceleration [KaiGai]<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:45 - 09:00<br />
|Welcome and introductions<br />
|Dave Page<br />
|-<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}<br />
<br />
<br />
==Minutes==</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2012_Developer_MeetingPgCon 2012 Developer Meeting2012-02-21T09:59:31Z<p>Dpage: /* Attendees */</p>
<hr />
<div>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). <br />
<br />
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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 9AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Oleg Bartunov<br />
* Josh Berkus (Secretary)<br />
* Jeff Davis<br />
* Dimitri Fontaine<br />
* Peter Geoghegan<br />
* Magnus Hagander<br />
* Hitoshi Harada<br />
* Dave Page (Chair)<br />
* Simon Riggs<br />
* Teodor Sigaev<br />
* Greg Smith<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* Queuing [Dimitri]<br />
* Materialized views [Dimitri, Kevin?]<br />
* Partitioning and Segment Exclusion [Dimitri]<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:45 - 09:00<br />
|Welcome and introductions<br />
|Dave Page<br />
|-<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}<br />
<br />
<br />
==Minutes==</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2012_Developer_MeetingPgCon 2012 Developer Meeting2012-02-20T09:45:01Z<p>Dpage: /* Attendees */</p>
<hr />
<div>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). <br />
<br />
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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 9AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Oleg Bartunov<br />
* Josh Berkus (Secretary)<br />
* Dimitri Fontaine<br />
* Peter Geoghegan<br />
* Magnus Hagander<br />
* Dave Page (Chair)<br />
* Teodor Sigaev<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* Write Scalability (Scale up, scale out) [Dimitri]<br />
* Queuing [Dimitri]<br />
* Materialized views [Dimitri]<br />
* Partitioning and Segment Exclusion [Dimitri]<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:45 - 09:00<br />
|Welcome and introductions<br />
|Dave Page<br />
|-<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}<br />
<br />
<br />
==Minutes==</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2012_Developer_MeetingPgCon 2012 Developer Meeting2012-02-17T16:51:29Z<p>Dpage: /* Proposed Agenda Items */</p>
<hr />
<div>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). <br />
<br />
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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 9AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Oleg Bartunov<br />
* Dimitri Fontaine<br />
* Peter Geoghegan<br />
* Magnus Hagander<br />
* Dave Page (Chair)<br />
* Teodor Sigaev<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* Write Scalability (Scale up, scale out) [Dimitri]<br />
* Queuing [Dimitri]<br />
* Materialized views [Dimitri]<br />
* Partitioning and Segment Exclusion [Dimitri]<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:45 - 09:00<br />
|Welcome and introductions<br />
|Dave Page<br />
|-<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}<br />
<br />
<br />
==Minutes==</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2012_Developer_MeetingPgCon 2012 Developer Meeting2012-02-17T16:17:39Z<p>Dpage: /* Attendees */</p>
<hr />
<div>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). <br />
<br />
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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 9AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting (in alphabetical order, by surname):<br />
<br />
* Oleg Bartunov<br />
* Dimitri Fontaine<br />
* Peter Geoghegan<br />
* Magnus Hagander<br />
* Dave Page (Chair)<br />
* Teodor Sigaev<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
* Write Scalability (Scale up, scale out)<br />
* Queuing<br />
* Materialized views<br />
* Partitioning and Segment Exclusion<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:45 - 09:00<br />
|Welcome and introductions<br />
|Dave Page<br />
|-<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}<br />
<br />
<br />
==Minutes==</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2012_Developer_MeetingPgCon 2012 Developer Meeting2012-02-17T15:37:19Z<p>Dpage: /* Attendees */</p>
<hr />
<div>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). <br />
<br />
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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 9AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting:<br />
<br />
* Oleg Bartunov<br />
* Peter Geoghegan<br />
* Magnus Hagander<br />
* Dave Page (Chair)<br />
* Teodor Sigaev<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:45 - 09:00<br />
|Welcome and introductions<br />
|Dave Page<br />
|-<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}<br />
<br />
<br />
==Minutes==</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2012_Developer_MeetingPgCon 2012 Developer Meeting2012-02-17T15:29:17Z<p>Dpage: /* Attendees */</p>
<hr />
<div>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). <br />
<br />
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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 9AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting:<br />
<br />
* Oleg Bartunov<br />
* Peter Geoghegan<br />
* Magnus Hagander<br />
* Dave Page (Chair)<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:45 - 09:00<br />
|Welcome and introductions<br />
|Dave Page<br />
|-<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}<br />
<br />
<br />
==Minutes==</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2012_Developer_MeetingPgCon 2012 Developer Meeting2012-02-17T15:19:28Z<p>Dpage: /* Attendees */</p>
<hr />
<div>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). <br />
<br />
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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 9AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting:<br />
<br />
* Oleg Bartunov<br />
* Magnus Hagander<br />
* Dave Page (Chair)<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:45 - 09:00<br />
|Welcome and introductions<br />
|Dave Page<br />
|-<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}<br />
<br />
<br />
==Minutes==</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2012_Developer_MeetingPgCon 2012 Developer Meeting2012-02-17T13:51:54Z<p>Dpage: </p>
<hr />
<div>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). <br />
<br />
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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 9AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting:<br />
<br />
* Magnus Hagander<br />
* Dave Page (Chair)<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:45 - 09:00<br />
|Welcome and introductions<br />
|Dave Page<br />
|-<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}<br />
<br />
<br />
==Minutes==</div>Dpagehttp://wiki.postgresql.org/wiki/PgCon_2012_Developer_MeetingPgCon 2012 Developer Meeting2012-02-15T11:38:15Z<p>Dpage: Created page with "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 …"</p>
<hr />
<div>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). <br />
<br />
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.<br />
<br />
This is a PostgreSQL Community event. Room and refreshments/food sponsored by EnterpriseDB. Other companies sponsored attendance for their developers.<br />
<br />
== Time & Location ==<br />
<br />
The meeting will be from 9AM to 5PM, and will be in the "Red Experience" room at:<br />
<br />
Novotel Ottawa<br />
33 Nicholas Street<br />
Ottawa<br />
Ontario<br />
K1N 9M7<br />
<br />
Food and drink will be provided throughout the day, including breakfast from 8AM.<br />
<br />
[http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=novotel+ottawa&aq=&sll=49.891235,-97.15369&sspn=36.237851,79.013672&ie=UTF8&hq=novotel+ottawa&hnear=&ll=45.421528,-75.683699&spn=0.036869,0.077162&z=14&iwloc=A&layer=c&cbll=45.425741,-75.689638&panoid=Z4FUGnkZkdHAOkIxyjjS9Q&cbp=12,25.83,,0,-0.6 View on Google Maps]<br />
<br />
== Attendees ==<br />
<br />
The following people have RSVPed to the meeting:<br />
<br />
* Dave Page (Chair)<br />
<br />
== Proposed Agenda Items ==<br />
<br />
Please list proposed agenda items here:<br />
<br />
== Agenda ==<br />
<br />
{| border="1" cellpadding="4" cellspacing="0"<br />
!Time<br />
!Item<br />
!Presenter<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:00<br />
|Breakfast<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|08:45 - 09:00<br />
|Welcome and introductions<br />
|Dave Page<br />
|-<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|10:30 - 10:45<br />
|Coffee break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|12:30 - 13:30<br />
|Lunch <br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|15:00 - 15:15<br />
|Tea break<br />
|<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|16:45 - 17:00<br />
|Any other business/group photo<br />
|Dave Page<br />
|- style="font-style:italic;background-color:lightgray;"<br />
|17:00<br />
|Finish<br />
| <br />
|}<br />
<br />
<br />
==Minutes==</div>Dpagehttp://wiki.postgresql.org/wiki/PostgreSQL_Conference_Europe_Talks_2011PostgreSQL Conference Europe Talks 20112011-11-08T10:07:39Z<p>Dpage: /* Ams 2 */</p>
<hr />
<div>= PostgreSQL Conference Europe 2011 Talks =<br />
<br />
== Talks: Wednesday 19th October, 2011 ==<br />
<br />
=== Ams 1 ===<br />
* [[Media:Mohan_PGCon_Keynote_10-19-2011.pdf|Ram Mohan Keynote: Afilias Winning Bet on Open Source]]<br />
* [http://www.oslandia.com/files/1646fd60f9b0a4558d1e256cf3264572/pgconfeu2011_vincent_picavet_postgis.pdf Vincent Picavet - Geo in your database : Postgis]<br />
* Heralding the Death of nosql — Will Leinweber, Heroku — http://pgeu-plv8.herokuapp.com<br />
* [http://scanningpages.wordpress.com/?attachment_id=420| Slony Troubleshooting - Steve Singer, Afilias ]<br />
<br />
=== Ams 2 ===<br />
* [http://www.mgrid.net/blogs/mgrid-at-pgdayeu-2011 Yeb Havinga: Introducing ISO-21090 Healthcare Datatypes]<br />
* [http://wiki.postgresql.org/images/d/df/Center_of_your_dataverse_PGCONFEU2011.pdf Dave Page: PostgreSQL at the centre of your dataverse]<br />
* [http://ora2pg.darold.net/ora2pg-best-practices.pdf Gilles Darold: Best practices with Ora2Pg]<br />
<br />
=== Ams 3 ===<br />
<br />
* [http://www.hagander.net/talks/PostgreSQL%209.1%20-%20What's%20new.pdf Magnus Hagander, PostgreSQL 9.1 - What's New]<br />
* [[Media:Ciolli-window-2011.pdf|Gianni Ciolli, Look Out The Window Functions (and free your SQL)]]<br />
** plus four 2D heat diffusion movies, with different starting scenarios: [http://vimeo.com/30797130 a hot point],<br />
** [http://vimeo.com/30797509 a hot segment],<br />
** [http://vimeo.com/30797715 a hot square] and<br />
** [http://vimeo.com/30797797 a cold square].<br />
* [http://momjian.us/main/presentations/internals.html#optimizer Explaining the Postgres Query Optimizer]<br />
* [http://www.2ndquadrant.com/static/2quad/media/pdfs/talks/SyncRepDurability.pdf Simon Riggs and Greg Smith: Synchronous Replication and Durability Tuning]<br />
* [[Media:Smartgrid_for_the_datacenter_web.pdf|Stefan Kaltenbrunner, A smartgrid for the datacenter]]<br />
<br />
== Talks: Thursday 20th October, 2011 ==<br />
<br />
=== Ams 1 ===<br />
<br />
* [[Media:slony1-2.1_londiste3.pdf|Cédric Villemain: londiste 3 et slony 2.1 ]]<br />
<br />
* A Postgres Service (Peter van Hardenberg, Heroku) http://pgconfeu11-service.herokuapp.com/<br />
<br />
* [[Media:SSI-PGConfEU2011.pdf|Heikki Linnakangas: Serializable Snapshot Isolation ]]<br />
<br />
* [[Media:Fast_GiST_index_build.pdf|Alexander Korotkov: Fast GiST index build ]]<br />
<br />
* [[Media:pgconf2011.eu-berg-pgapt.pdf|Christoph Berg: Connecting the Debian and PostgreSQL worlds ]]<br />
<br />
=== Ams 2 ===<br />
* [[Media:using-extensions.pdf|Dimitri Fontaine: Extensions are good for business logic]]<br />
* Exposing the Power of Postgres to Ruby — Will Leinweber, Heroku — http://pgeu-ruby.herokuapp.com<br />
* [http://wiki.postgresql.org/images/e/e6/Django-extensions.pdf Jonathan S. Katz: Writing Django Extensions for PostgreSQL]<br />
* [[Media:Pgconf-2011-mysql-to-pg-print.pdf|Andreas 'ads' Scherbaum: Port databases from MySQL to PostgreSQL]]<br />
<br />
=== Ams 3 ===<br />
* [http://www.2ndquadrant.com/static/2quad/media/pdfs/talks/ImprovingVACUUMSuction.pdf Greg Smith: Improving VACUUM Suction]<br />
* [[Media:Ciolli-debug-wcte-2011.pdf|Gianni Ciolli, Debug complex SQL queries with writable CTEs]]<br />
* [[Media:pgconfeu_stats.odp|Guillaume Lelarge, What use are the statistics views?]]<br />
* Lightning talk: [[Media:Ciolli-waiting-for-the-barman-2011.pdf|Gabriele Bartolini and Gianni Ciolli, waiting for (the) BaRMan]]<br />
<br />
== Talks: Friday 21st October, 2011 ==<br />
<br />
=== Ams 1 ===<br />
* Reliable Databases in The Cloud with WAL-E (redux) - Dan Farina, Heroku - http://wal-e-pgeu2011.herokuapp.com/<br />
* [http://wiki.postgresql.org/images/4/46/Knn.pdf Jonathan S. Katz: Accelerating Local Search With PostgreSQL 9.1]<br />
<br />
=== Ams 2 ===<br />
<br />
* [http://bunsen.credativ.com/~mme/2011/PGConf_EU.pdf Michael Meskes: Mission Impossible?]<br />
<br />
=== Ams 3 ===<br />
* [http://www.2ndquadrant.com/static/2quad/media/pdfs/talks/bottom-up-benchmarking-2011.pdf Greg Smith: Bottom-Up Database Benchmarking]<br />
* [http://www.hagander.net/talks/The%20PostgreSQL%20Replication%20Protocol%20pgopen.pdf Magnus Hagander: The PostgreSQL Replication Protocol, Tools and Opportunities]<br />
* [http://wiki.postgresql.org/images/f/fa/Pg-eu-2011-closing-keynote.pdf Bruce Momjian: Closing Keynote]<br />
<br />
[[Category:PostgreSQL Europe]]</div>Dpage