PGDay.EU, Paris 2009

From PostgreSQL wiki

PGDay.EU 2009, a collaboration between PostgreSQL Europe and PostgreSQLFR was held in Paris, France on November 6-7.

Contents 1 November 6, 2009 1.1 English track 1.1.1 12:00 - 12:50 Datawarehousing with PostgreSQL (Gabriele Bartolini) 1.1.2 13:50 - 14:40 Scaling PostgreSQL Under Fire (Gavin M. Roy) (partial video) 1.1.3 15:10 - 16:00 Performance Enhancements in PostgreSQL 8.4 (MagnusHagander) 1.1.4 16:10 - 17:00 The Future of PostgreSQL HA (Robert Hodges & Simon Riggs) 1.2 French track 1.2.1 11:00 - 11:50 Retour d'expérience migration Oracle vers PostgreSQL (Vincent Moreau) 1.2.2 12:00 - 12:50 Retour d'expérience : PostgreSQL et Skytools chez Hi-Media (Dimitri Fontaine) 1.2.3 13:50 - 14:40 Systèmes de réplication pour PostgreSQL (Jean-Paul Argudo) 1.2.4 15:10 - 16:00 PostGIS, un module de PostgreSQL pour les données spatiales (Olivier Courtin - Vincent Picavet) 1.2.5 16:10 - 17:00 phpPgAdmin: présentation, développement et futur du projet (Jehan-Guillaume (ioguix) de Rorthais) 2 November 7, 2009 2.1 English track (DBA/General) 2.1.1 10:00 - 10:50 Japan PostgreSQL Users Group (Junichi Tado, Hiroshi Saito, Toshiyuki Ishikawa & Kaori Inaba) 2.2 English track (Developer) 2.2.1 9:00 - 9:50 Welcome to WAL (Heikki Linnakangas) 2.2.2 10:00 - 10-50 Writeable CTEs: The Next Big Thing (David Fetter - Marko Tiikkaja) 2.2.3 11:20 - 12:10 ORMs: Strengths, Weaknesses, and Building a PostgreSQL-specific ORM (Jonathan S. Katz) 2.2.4 13:10 - 14:00 Introducing portalBase - agile database development with PostgreSQL 2.2.5 14:10 - 15:00 pg_staging or how to manage your staging environments (Dimitri Fontaine) 2.3 French track 2.3.1 09:00 - 09:50 MVCC et PostgreSQL (Guillaume Lelarge) 2.3.2 10:00 - 10:50 Bacula et PostgreSQL (Éric Bollengier et Marc Cousin) 2.3.3 11:20 - 12:10 Clustering : la nouvelle donne (Stéphane Giron et Gilles Rayrat) ( English version here) 2.3.4 13:10 - 14:00 Indexation d'une base documentaire pour le quotidien Libération (Gaël Le Mignot, Pilot Systems) 2.3.5 14:10 - 15:00 pg_comparator : Comparaison de tables à distance (Fabien Coelho) 2.4 Lightning talks 2.4.1 #1 Elephant, Snake and Window - 6 years experience with PostgreSQL on Windows (Harald Armin Massa)] (video) 2.4.2 #4 On Lightning Talks (David Fetter) (video) 2.4.3 #5 New features of PGCluster (Atsushi Mitani) 2.4.4 #6 PostgreSQL's biggest problem (By Gavin M. Roy, but presented by Greg and Dave in his absence, with no knowledge of the intended talk content)! 2.4.5 #7 pg51g in five – a toolkit for data diffs (Michael Nacos) (video) 2.4.6 #8 The Open Source Observatory and Repository (Ismael Olea) 2.4.7 #9 Objectwiz – open-source object-oriented data administration tool (Benoît Del Basso) (video) 2.5 Closing session 2.5.1 Closing session (Dave Page and Guillaume Smet)

November 6, 2009

English track

12:00 - 12:50 Datawarehousing with PostgreSQL (Gabriele Bartolini)

13:50 - 14:40 Scaling PostgreSQL Under Fire (Gavin M. Roy) (partial video)

15:10 - 16:00 Performance Enhancements in PostgreSQL 8.4 (MagnusHagander)

16:10 - 17:00 The Future of PostgreSQL HA (Robert Hodges & Simon Riggs)

French track

11:00 - 11:50 Retour d'expérience migration Oracle vers PostgreSQL (Vincent Moreau)

12:00 - 12:50 Retour d'expérience : PostgreSQL et Skytools chez Hi-Media (Dimitri Fontaine)

13:50 - 14:40 Systèmes de réplication pour PostgreSQL (Jean-Paul Argudo)

15:10 - 16:00 PostGIS, un module de PostgreSQL pour les données spatiales (Olivier Courtin - Vincent Picavet)

16:10 - 17:00 phpPgAdmin: présentation, développement et futur du projet (Jehan-Guillaume (ioguix) de Rorthais)

November 7, 2009

English track (DBA/General)

10:00 - 10:50 Japan PostgreSQL Users Group (Junichi Tado, Hiroshi Saito, Toshiyuki Ishikawa & Kaori Inaba)

English track (Developer)

9:00 - 9:50 Welcome to WAL (Heikki Linnakangas)

10:00 - 10-50 Writeable CTEs: The Next Big Thing (David Fetter - Marko Tiikkaja)

11:20 - 12:10 ORMs: Strengths, Weaknesses, and Building a PostgreSQL-specific ORM (Jonathan S. Katz)

13:10 - 14:00 Introducing portalBase - agile database development with PostgreSQL

14:10 - 15:00 pg_staging or how to manage your staging environments (Dimitri Fontaine)

French track

09:00 - 09:50 MVCC et PostgreSQL (Guillaume Lelarge)

10:00 - 10:50 Bacula et PostgreSQL (Éric Bollengier et Marc Cousin)

11:20 - 12:10 Clustering : la nouvelle donne (Stéphane Giron et Gilles Rayrat) ( English version here)

13:10 - 14:00 Indexation d'une base documentaire pour le quotidien Libération (Gaël Le Mignot, Pilot Systems)

14:10 - 15:00 pg_comparator : Comparaison de tables à distance (Fabien Coelho)

Lightning talks

#1 Elephant, Snake and Window - 6 years experience with PostgreSQL on Windows (Harald Armin Massa)] (video)

#4 On Lightning Talks (David Fetter) (video)

#5 New features of PGCluster (Atsushi Mitani)

#6 PostgreSQL's biggest problem (By Gavin M. Roy, but presented by Greg and Dave in his absence, with no knowledge of the intended talk content)!

#7 pg51g in five – a toolkit for data diffs (Michael Nacos) (video)

#8 The Open Source Observatory and Repository (Ismael Olea)

#9 Objectwiz – open-source object-oriented data administration tool (Benoît Del Basso) (video)

Closing session

Closing session (Dave Page and Guillaume Smet)