PostgreSQL Conference Europe Talks 2013

2013-11-01T15:04:40Z

Mhugo: /* Earlsfort */

= 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)
* [https://github.com/Oslandia/presentations/tree/master/pgconf_eu_2013 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)
* [http://de.slideshare.net/psoo1978/pg-fdw Writing a foreign data wrapper] (Bernd Helmle)
* Success stories on migrating from Sybase ASE to PostgreSQL (Achim Eisele, Jens Wilke)
* Multicorn: writing Foreign Data Wrappers in python (Ronan Dunklau)

=== Pembroke ===

* Writing a user-defined datatype (Heikki Linnakangas)
* LATERAL querying in 9.3; keep up with the new features! (Gianni Ciolli)
* Detecting performance bottlenecks (Hans-Jürgen Schönig)
* [http://www.slideshare.net/jkatz05/explain-the-index-of-postgresql-indexes 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)
* [https://speakerdeck.com/craigkerstiens/postgres-what-they-really-use slides Postgres what they really use] ([http://www.craigkerstiens.com 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)
* [https://wiki.postgresql.org/images/a/ad/Materialised_views_now_and_the_future-pgconfeu_2013.pdf Materialised views now and the future] (Thom Brown)
* [http://www.slideshare.net/davidfetter/federation-with-foreigndatawrapperspgconfeu20131031 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)
* [https://speakerdeck.com/peterg/concurrency-in-postgres Concurrency in Postgres] (Peter Geoghegan)
* [http://www.sai.msu.su/~megera/postgres/talks/Next%20generation%20of%20GIN.pdf Next generation of GIN] (Alexander Korotkov, Oleg Bartunov)
* [https://speakerdeck.com/leinweber/visualizing-postgres Visualizing Postgres] ([http://bitfission.com Will Leinweber])

=== Lightning talks ===

* [http://www.slideshare.net/davidfetter/slides-pg-confeu20131031 Slides] (David Fetter)
* [https://wiki.postgresql.org/images/1/1c/Json-and-speed.pdf JSON & Speed] (Jonathan S. Katz)
* [https://wiki.postgresql.org/images/a/ab/Pganalyze_Lightning_talk.pdf pganalyze - Monitoring for Casual DBAs] (Michael Renner)

== 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)
* [http://www.sai.msu.su/~megera/postgres/talks/hstore-dublin-2013.pdf 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)

FOSDEM 2013

2013-02-05T08:05:08Z

Mhugo: /* Radisson Blu */ Hugo's slides

==Schedule==

Schedule is available at the FOSDEM website: https://fosdem.org/2013/schedule/track/postgresql/

== PGDay FOSDEM 2013 ==

We are also organizing one-day event: https://wiki.postgresql.org/wiki/PGDay_FOSDEM_2013

==Presentations==

Slides of the presentations:

== Talks: Friday, February 1st, 2013 ==

=== Radisson Blu ===

* Welcome (Magnus Hagander)
* Sqitch: VCS-enabled database change management (Ronan Dunklau)
* Postgresql 9.2 FTS Solutions (Emanuel Calvo)
* Pagination done the PostgreSQL way (Markus Winand) [[File:Pagination_Done_the_PostgreSQL_Way.pdf]]
* Announcements FOSDEM PGDay 2013 (Dave Page, Jean-Paul Argudo)
* 3D an exact geometries for PostGIS (Hugo Mercier) [[File:Postgis 3d pgday2013 hm.pdf]]
* Understanding PostgreSQL timelines (Heikki Linnakangas)
* Maintaining Very Large Databases (VLDs) (Devrim GÜNDÜZ)

== Talks: Sunday, February 3rd, 2013 ==

=== PostgreSQL FOSDEM Devroom ===

* openbarter, a possible solution for ecological regulation (Olivier Chaussavoine)
* [http://tapoueh.org/images/confs/Fosdem2013_Event_Triggers.pdf Event Triggers] (Dimitri Fontaine)
* PostGIS 2.0 and beyond (Vincent Picavet)
* Making apt.postgresql.org a reality (Christoph Berg)
* Postgres Demystified (Craig Kerstiens)
* PostgreSQL as a Schemaless Database (Christophe Pettus)
* [http://tapoueh.org/images/confs/Fosdem2013_High_Availability.pdf Implementing High Availability] (Dimitri Fontaine)
* Practical Tips for Better PostgreSQL Applications (Marc Balmer)

Speakers: please upload your slides to the wiki and add a link above.

[[Category:PostgreSQL Events]]

File:Postgis 3d pgday2013 hm.pdf

2013-02-05T08:02:33Z

Mhugo: 3D and exact geometries fro PostGIS - Hugo Mercier - PGDay 2013

3D and exact geometries fro PostGIS - Hugo Mercier - PGDay 2013

PostgreSQL wiki - User contributions [en]

PostgreSQL Conference Europe Talks 2013

FOSDEM 2013

File:Postgis 3d pgday2013 hm.pdf