PostgreSQL Conference Europe Talks 2012
From PostgreSQL wiki
(Difference between revisions)
(→Vltava) |
(add all talks) |
||
| Line 1: | Line 1: | ||
= PostgreSQL Conference Europe 2012 Talks = | = 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 == | == Talks: Wednesday 24th October, 2012 == | ||
=== Bellevue === | === Bellevue === | ||
| + | |||
| + | * Opening keynote (Joe Celko) | ||
=== Seine === | === Seine === | ||
| + | * Programming the SQL Way with Common Table Expressions (Bruce Momjian) | ||
| + | * PostgreSQL on AWS (Christophe Pettus) | ||
| + | * Understanding EXPLAIN's output (Guillaume Lelarge) | ||
* [http://www.sraoss.co.jp/event_seminar/2012/20121024_pgpool-II_pgconfEU2012_sraoss.pdf Boosting Performance and Reliability by using pgpool-II (Tatsuo Ishii)] | * [http://www.sraoss.co.jp/event_seminar/2012/20121024_pgpool-II_pgconfEU2012_sraoss.pdf Boosting Performance and Reliability by using pgpool-II (Tatsuo Ishii)] | ||
| + | * CREATE EXTENSION pgchess; (Gianni Ciolli) | ||
=== Thames === | === Thames === | ||
| + | * Writing a foreign data wrapper (Bernd Helmle) | ||
* [http://anarazel.de/2ndquadrant/pgconf-eu-2012-10-24 MultiMaster Replication: Applications, Comparison, Implementation ] (Andres Freund, Simon Riggs) | * [http://anarazel.de/2ndquadrant/pgconf-eu-2012-10-24 MultiMaster Replication: Applications, Comparison, Implementation ] (Andres Freund, Simon Riggs) | ||
* [[Media:Pgconfeu12-collectd%2Bpsql.pdf|Watch your Elephants -- Using collectd for PostgreSQL performance analysis]] ([http://tokkee.org/ Sebastian 'tokkee' Harl]) | * [[Media:Pgconfeu12-collectd%2Bpsql.pdf|Watch your Elephants -- Using collectd for PostgreSQL performance analysis]] ([http://tokkee.org/ Sebastian 'tokkee' Harl]) | ||
* [[Media:Range-types.pdf|Range Types in PostgreSQL 9.2 - Your Life Will Never Be the Same (Jonathan S. Katz)]] | * [[Media:Range-types.pdf|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 === | === Vltava === | ||
| + | |||
| + | * Provoz PostgreSQL na AWS (Tomas Vondra) | ||
* [[Media:Plpgsql internals.pdf| PL/pgSQL internals -- some details from PL/pgSQL environment]] | * [[Media:Plpgsql internals.pdf| PL/pgSQL internals -- some details from PL/pgSQL environment]] | ||
| + | * Migrace z MySQL na PostgreSQL (Tomas Vondra) | ||
* [[Media:Indexy.pdf| Indexy jsou grunt -- basic and enhanced using of indexes in PostgreSQL]] | * [[Media:Indexy.pdf| Indexy jsou grunt -- basic and enhanced using of indexes in PostgreSQL]] | ||
| + | * Load dat do PostgreSQL (Jan Holčapek) | ||
| + | |||
== Talks: Thursday 25th October, 2012 == | == Talks: Thursday 25th October, 2012 == | ||
| - | === Bellevue === | + | === Bellevue (Lightning Talks) === |
* [[Media:Full-text_search_in_PostgreSQL_in_milliseconds-extended-version.pdf| Full-text search in PostgreSQL in milliseconds (Oleg Bartunov, Alexander Korotkov)]] | * [[Media:Full-text_search_in_PostgreSQL_in_milliseconds-extended-version.pdf| Full-text search in PostgreSQL in milliseconds (Oleg Bartunov, Alexander Korotkov)]] | ||
=== Seine === | === Seine === | ||
| + | |||
| + | * How fast is PostgreSQL? (Cédric Villemain) | ||
| + | * Implementing High Availability (Dimitri Fontaine) | ||
| + | * Inside PostgreSQL Shared Memory (Bruce Momjian) | ||
* [https://plv8-pgconfeu12.herokuapp.com Embracing the Web with JSON and PLV8] ([http://bitfission.com Will Leinweber]) | * [https://plv8-pgconfeu12.herokuapp.com Embracing the Web with JSON and PLV8] ([http://bitfission.com Will Leinweber]) | ||
| + | |||
=== Thames === | === Thames === | ||
| - | |||
* [https://github.com/Oslandia/presentations/tree/master/pgconf_eu_2012 Topology and network analysis with PostgreSQL and PostGIS (Vincent Picavet)] | * [https://github.com/Oslandia/presentations/tree/master/pgconf_eu_2012 Topology and network analysis with PostgreSQL and PostGIS (Vincent Picavet)] | ||
| + | * [[Media:Universal_Data_Access_with_SQL_MED.pdf|Universal Data Access with SQL/MED (David Fetter)]] | ||
* [https://github.com/Oslandia/presentations/tree/master/pgconf_eu_2012 PostGIS 2.0 and beyond (Vincent Picavet)] | * [https://github.com/Oslandia/presentations/tree/master/pgconf_eu_2012 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 === | === Vltava === | ||
| + | |||
* [[Media: Marketing-postgres.pdf|Marketing PostgreSQL (Jonathan S. Katz)]] | * [[Media: Marketing-postgres.pdf|Marketing PostgreSQL (Jonathan S. Katz)]] | ||
* [[Media: Pgconf2012_sprocwrapper.pdf|Java Stored Procedure Wrapper and PGObserver (Jan Mussler)]] | * [[Media: Pgconf2012_sprocwrapper.pdf|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 == | == 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) | ||
| + | * 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 === | === Vltava === | ||
| + | |||
* [[Media: Pg_xnode_pgconf_2012.pdf|pg_xnode extension (Antonin Houska)]] | * [[Media: Pg_xnode_pgconf_2012.pdf|pg_xnode extension (Antonin Houska)]] | ||
| + | [[Category:PostgreSQL Europe]] | ||
| + | * PostgreSQL makes dev happy, a pgAgent + pl/pgsql use case (Julien Rouhaud) | ||
* [[Media: PGconEU2012-KaiGai-PGStrom.pdf|PG-Strom - GPU Accelerated Asynchronous Query Execution Module (KaiGai Kohei)]] | * [[Media: PGconEU2012-KaiGai-PGStrom.pdf|PG-Strom - GPU Accelerated Asynchronous Query Execution Module (KaiGai Kohei)]] | ||
[[Category:PostgreSQL Europe]] | [[Category:PostgreSQL Europe]] | ||
| + | * Using PostgreSQL for storing time-series data (Sebastian Harl) | ||
Revision as of 12:33, 26 October 2012
Contents |
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)
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)
- 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 Harl)
