PostgreSQL Conference Europe Talks 2013

PostgreSQL Conference Europe 2013 Talks

Conference Website

http://2013.pgconf.eu/

Trainings: Tuesday 29th October, 2013

Dargle

• PostgreSQL & PostGIS (Gianni Ciolli)
• Writing & using Postgres Extensions (Dimitri Fontaine)

Dodder

• PostgreSQL indexing (Hans-Jürgen Schönig)

Liffey

• PostgreSQL Performance Tuning (Bruce Momjian)
• Data Processing Inside PostgreSQL (Bruce Momjian)

Talks: Wednesday 30th October, 2013

Earlsfort

• Keynote: Handling the Spotlight: How PostgreSQL can become the database of choice (Mark Taylor)
• What's New in PostgreSQL 9.3 (Robert Treat)
• PostgreSQL - One of the most important Open Source projects (Michael Meskes)
• Going spatial with PostGIS and more (Hugo Mercier)
• Nulls Make Things Easier? (Bruce Momjian)
• PostgreSQL Disaster Recovery with Barman (Gabriele Bartolini)

Leeson

• PostgreSQL for Rails (Roland Sonnenschein)
• Introduction of pg_statsinfo and pg_stats_reporter ~Statistics Reporting Tool for DBA~ (Mitsumasa KONDO)
• Writing a foreign data wrapper (Bernd Helmle)
• Success stories on migrating from Sybase ASE to PostgreSQL (External Link) (Achim Eisele, Jens Wilke)
• Multicorn: writing Foreign Data Wrappers in python (Ronan Dunklau)

Pembroke

• Writing a user-defined datatype (sources for the example) (Heikki Linnakangas)
• LATERAL querying in 9.3; keep up with the new features! (Gianni Ciolli)
• Detecting performance bottlenecks (Hans-Jürgen Schönig)
• Explaining the Index of PostgreSQL Indexes (Jonathan S. Katz)
• Conduct change from Oracle to PostgreSQL (Jean-Paul Argudo)

Talks: Thursday 31th October, 2013

Earlsfort

• Taking advantage of custom background workers (Michael Paquier)
• Doing PITR Right - There's more than just replication (Stephen Frost)
• slides Postgres what they really use (Craig Kerstiens)
• Indexes: The neglected performance all-rounder (Markus Winand)
• Migrating from MySQL to PostgreSQL (Dimitri Fontaine)
• Lightning talks (Harald Armin Massa)

Leeson

• Gotcha! Finer points of the postgres query planner and how to use them in your queries (Atri Sharma)
• Materialised views now and the future (Thom Brown)
• Federation with Foreign Data Wrappers (David Fetter)
• Switching Horses Overnight - a Software Manufacturer's View on Replacing an Existing Database Management System with PostgreSQL (Robert Lichtenberger, Stefan Andreatta)
• My experience with embedding PostgreSQL (Jignesh Shah)

Pembroke

• pgBadger v.4 (Jean-Paul Argudo)
• Business Intelligence & Performance (Simon Riggs)
• Concurrency in Postgres (Peter Geoghegan)
• Next generation of GIN (Alexander Korotkov, Oleg Bartunov)
• Visualizing Postgres (Will Leinweber)

Lightning talks

• Slides (David Fetter)
• JSON & Speed (Jonathan S. Katz)
• pganalyze - Monitoring for Casual DBAs (Michael Renner)
• 100k Appliances (Christoph Moench-Tegeder)
• Ordered Set Functions (Atri Sharma)

Talks: Friday 1st November, 2013

Earlsfort

• Epic fails in the RDBMS world (Willem Leenen)
• Using Postgres FDW w/ a sharded PostgreSQL Database (Stephen Frost)
• Postgres versus an anonymous database from Redwood (Gregory Stark)
• Hierarchies Without Masters (Gianni Ciolli)
• PostgreSQL Futures (Simon Riggs)
• PostgreSQL in 5 years - Expectations from the market place (Keith Alsheimer)
• Closing (Dave Page, Magnus Hagander)

Leeson

• Pagination done the PostgreSQL way (Markus Winand)
• Postgres from Vision to Reality, ABNAMRO Client case (Michel Sijmons)
• PostgreSQL Backups, the good the bad and the ugly (Joshua D. Drake)
• Elephants in fashion (Valentine Gogichashvili)

Pembroke

• Agile Oracle to PostgreSQL migrations (Gabriele Bartolini)
• Useful PostgreSQL Extensions -- the extensions behind the scenes (Devrim GÜNDÜZ)
• Binary storage for nested data structures and application to hstore data type (Oleg Bartunov, Teodor Sigaev)
• Wiretapping the Wire Protocol: automatic data visualization for psql with Cartographer and FEMEBE (Maciek Sakrejda)