PostgreSQL Conference Europe Talks 2012

PostgreSQL Conference Europe 2012 Talks

Trainings: Tuesday 23th October, 2012

Clyde

• Mastering PostgreSQL Administration (Bruce Momjian, Devrim GÜNDÜZ)

Seine

• PostgreSQL Performance Training (Greg Smith, Peter Geoghegan)
• PostgreSQL Replication Training (Dimitri Fontaine, Simon Riggs)

Thames

• Implementace uložených procedur v PostgreSQL (Pavel Stehule)
• Čtení exekučních plánů (Tomas Vondra)

Vltava

• A day of SQL with Celko (Joe Celko)

Talks: Wednesday 24th October, 2012

Bellevue

• Opening keynote (Joe Celko)

Seine

• Programming the SQL Way with Common Table Expressions (Bruce Momjian)
• PostgreSQL on AWS (Christophe Pettus)
• Understanding EXPLAIN's output (Guillaume Lelarge)
• Boosting Performance and Reliability by using pgpool-II (Tatsuo Ishii)
• CREATE EXTENSION pgchess; (Gianni Ciolli)

Thames

• Writing a foreign data wrapper (Bernd Helmle)
• MultiMaster Replication: Applications, Comparison, Implementation (Andres Freund, Simon Riggs)
• Watch your Elephants -- Using collectd for PostgreSQL performance analysis (Sebastian 'tokkee' Harl)
• Range Types in PostgreSQL 9.2 - Your Life Will Never Be the Same (Jonathan S. Katz)
• High availability in Postgres-XC, the symmetric PostgreSQL cluster (Koichi Suzuki)

Vltava

• Provoz PostgreSQL na AWS (Tomas Vondra)
• PL/pgSQL internals -- some details from PL/pgSQL environment
• Migrace z MySQL na PostgreSQL (Tomas Vondra)
• Indexy jsou grunt -- basic and enhanced using of indexes in PostgreSQL
• Load dat do PostgreSQL (Jan Holčapek)

Talks: Thursday 25th October, 2012

Bellevue (Lightning Talks)

• Full-text search in PostgreSQL in milliseconds (Oleg Bartunov, Alexander Korotkov)
• #PostgreSQL pg_docbot (Andreas 'ads' Scherbaum)
• PGQ Cooperative Consumers (Dimitri Fontaine & Marko Kreen)
• PostgreSQL Drinking Game (Josh Berkus)

Seine

• How fast is PostgreSQL? (Cédric Villemain)
• Implementing High Availability (Dimitri Fontaine)
• Inside PostgreSQL Shared Memory (Bruce Momjian)
• Embracing the Web with JSON and PLV8 (Will Leinweber)

Thames

• Topology and network analysis with PostgreSQL and PostGIS (Vincent Picavet)
• Universal Data Access with SQL/MED (David Fetter)
• PostGIS 2.0 and beyond (Vincent Picavet)
• Practical Tips for Better PostgreSQL Applications (Marc Balmer)
• Pacemaker and PostgreSQL: to serve and protect your data (Jehan-Guillaume (ioguix) de Rorthais)

Vltava

• Marketing PostgreSQL (Jonathan S. Katz)
• Java Stored Procedure Wrapper and PGObserver (Jan Mussler)
• Elephants and Windmills (Josh Berkus)
• PostgreSQL in Research and Development: Three success stories. (Roland Sonnenschein)
• Index support for regular expression search (Alexander Korotkov)

Talks: Friday 26th October, 2012

Bellevue

• Postgres Adoption at the Tipping Point: Users Around the World and Their Deployment Profile (Ed Boyajian)
• Community PostgreSQL (Simon Riggs, Harald Armin Massa)
• Closing (Dave Page)

Seine

• Beyond Query Logging (Greg Smith, Peter Geoghegan)
• PostgreSQL Backup Strategies (Magnus Hagander)
• Maintaining Very Large Databases (VLDs) (Devrim GÜNDÜZ)
• Large Scale MySQL Migration to PostgreSQL (Dimitri Fontaine)

Thames

• PostBIS - A Bioinformatics Booster for PostgreSQL (Michael Schneider, Renzo Kottmann)
• Migrating Oracle queries to PostgreSQL (Alexey Klyukin)
• Debugging complex SQL queries with writable CTEs (Gianni Ciolli)
• Limiting PostgreSQL resource consumption using the Linux kernel (Hans-Jürgen Schönig)

Vltava

• pg_xnode extension (Antonin Houska)
• PostgreSQL makes dev happy, a pgAgent + pl/pgsql use case (Julien Rouhaud)
• PG-Strom - GPU Accelerated Asynchronous Query Execution Module (KaiGai Kohei)
• Using PostgreSQL for storing time-series data (Sebastian 'tokkee' Harl)