December 3, 2016 – Community Day (DAY 2) | ||
---|---|---|
track A (translated) | track B | |
10:00 – 10:45 (45 min) | YeSQL: Battling the NoSQL Hype Cycle with Postgres Bruce Momjian Enterprise DB Lecture |
PGXZ: Large-Scale Distributed DBMS (Application to Mobile Payment System) Xu Zhongqing Tencent Case study |
10:45 – 11:00 (15 min) | Break | |
11:00 – 11:45 (45 min) | PostgreSQL Backups the modern way Magnus Hagander Redpill Linpro Admin |
Beyond EXPLAIN: Query Optimization Behind the Scenes Yuto Hayamizu The University of Tokyo Lecture |
11:45 – 13:00 (75 min) | Lunch break | |
13:00 – 13:45 (45 min) | Performance Improvements in PostgreSQL 9.5, 9.6 and beyond Tomas Vondra 2ndQuadrant Hacking |
Pgpool-II: Past, Present and Future Tatsuo Ishii / Yugo Nagata SRA OSS clustering |
13:45 – 14:00 (15 min) | Break | |
14:00 – 14:45 (45 min) | PGroonga – Make PostgreSQL fast full text search platform for all languages! Kouhei Sutou ClearCode Inc. Hacking |
Logical Replication, Sharding & Multimaster Clusters Simon Riggs 2ndQuadrant Clustering |
14:45 – 15:15 (30 min) | Coffee break | |
15:15 – 16:00 (45 min) | Evolution of pgAdmin: pgAdmin4 Dave Page Enterprise DB Admin |
What are the similarities and differences of using PostgreSQL between Japan and Europe? Yoko Takase Ashisuto Case study |
16:00 – 16:15 (15 min) | break | |
16:15 – 17:00 (45 min) | – | LT & Closing speech |
YeSQL: Battling the NoSQL Hype Cycle with Postgres
December 3, 10:00 – 10:45 @ Track A
Abstract
Relational databases are regularly challenged by new technologies that promise to make SQL obsolete, but the new technologies often fade into obscurity. This talk explores how new NoSQL technologies are unique, and how existing relational database systems like Postgres are adapting to handle NoSQL workloads.
Speaker
Bruce Momjian
Enterprise DB
bruce@momjian.us
Profile
Bruce Momjian is co-founder and core team member of the PostgreSQL Global Development Group, and has worked on PostgreSQL since 1996. He has been employed by EnterpriseDB since 2006. He has spoken at many international open-source conferences and is the author of PostgreSQL: Introduction and Concepts, published by Addison-Wesley. Prior to his involvement with PostgreSQL, Bruce worked as a consultant, developing custom database applications for some of the world’s largest law firms. As an academic, Bruce holds a Masters in Education, was a high school computer science teacher, and lectures internationally at universities.
Language of the talk material: English
PGXZ:Large-Scale Distributed DBMS (Application to Mobile Payment System)
December 3, 10:00 – 10:45 @ Track B
Abstract
PGXZ, based on open source PostgreSQL-XC, is a distributed database system developed by Tencent. The biggest PGXZ cluster, with 60 datanodes, is using on WeChat Payment System which supplies one of the biggest mobile payment service in China. Data volume in PGXZ cluster is over 25TB until now and is growing very fast. The new data volume of per month is about 1.5 times as that of last month. PGXZ cluster used in WeChat Payment System has up to 20,000 tps and 8,000 qps.
Speaker
Xu Zhongqing
Tencent, China
yorkxu@tencent.com
Profile
After taking an Master Degree in Computer Science from Huazhong University of Science and Technology in 2007, I had been working for Huawei until the end of 2014. And now, I am working for Tencent, one of the biggest Internet companies in China, and responsible for architecture design and development about PGXZ, a distributed database cluster derived from PGXC.
Language of the talk material: English
PostgreSQL Backups the modern way
December 3, 11:00 – 11:45 @ Track A
Abstract
There have been many different ways to take backups of PostgreSQL systems over the years, and the tools to do so have evolved both inside PostgreSQL and as addons. Are you using pg_dump for backups? Calling pg_start_backup()? Writing an archive_command? Then you’re probably missing out on new features, and possibly even risking your backups. In this talk we’ll go through the “right” way to do backups on modern versions of PostgreSQL, both using builtin tools and proven external utilities.
Speaker
Magnus Hagander
Redpill Linpro, Sweden
magnus@hagander.net
Profile
Magnus Hagander is a member of the PostgreSQL Core Team and a developer and code committer in the PostgreSQL Global Development Group. Magnus is one of the original developers of the Windows port of PostgreSQL. These days, he mostly works on other parts of the PostgreSQL backend, recently with a focus on security features, monitoring and backup/replication interfaces and tools. He is also one of the core members of the postgresql.org infrastructure team, maintaining the servers that power the project, and one of the maintainers of the postgresql.org website. He also contributes to pgAdmin and other related projects. He’s been a PostgreSQL user since version 6 (with some non-serious use of Postgres 95 before that), and currently serves on the Core Team and as President of the Board for PostgreSQL Europe. To pay the bills, he is a PostgreSQL and open source software consultant at Redpill Linpro in Stockholm, Sweden, where he works on consulting, support and training services, as well as custom development work.
Language of the talk material: English
Beyond EXPLAIN: Query Optimization Behind the Scenes
December 3, 11:00 – 11:45 @ Track B
Abstract
EXPLAIN is too much explained. Let’s go “beyond EXPLAIN”.
This talk will take you to an optimizer backstage tour: from theoretical background of state-of-the-art query optimization to close look at current implementation of PostgreSQL. Experiences to hack the optimizer in our laboratory will also be shared.
Speaker
Yuto Hayamizu
The University of Tokyo, Japan
haya@tkl.iis.u-tokyo.ac.jp
Twitter
Profile
Yuto Hayamizu is a hardcore database researcher, and also known as performance measurement gru in the Japanese PostgreSQL community. He enjoys hacking PostgreSQL in his research activity and speaking about PostgreSQL at various events such as PGCon and JPUG meetups. He received JPUG Thanks Award 2013 for his outstanding contribution to Japanese PostgreSQL community.
Language of the talk material: English
Performance Improvements in PostgreSQL 9.5, 9.6 and beyond
December 3, 13:00 – 13:45 @ Track A
Abstract
Recent PostgreSQL releases bring plenty of new features, and a lot of them are related to performance – PostgreSQL 9.5 and 9.6 are not an exception – parallel queries, multiple improvements of sorting
performance, hashjoin improvements, lock scalability, optimizer improvements, etc. This talk aims to present the main performance improvements along with benchmarks illustrating the gains.
I also plan to briefly talk about what may happen in the near future – what performance-related features the community are in the works.
Speaker
Tomas Vondra
2ndQuadrant, Czech
tomas.vondra@2ndquadrant.com
Profile
Tomas first met PostgreSQL in 2003 and quickly became a big fan. He participated in porting various applications to PostgreSQL from other databases, tuning and fixing performance issues etc. He is also a member of the executive committee of CSPUG (Czech and Slovak PostgreSQL Users Group), an “umbrella” organization for the local PostgreSQL community. Tomas currently works as a database engineer 2ndQuadrant, working on various PostgreSQL-related tasks.
Language of the talk material: English
Pgpool-II: Past, Present and Future
December 3, 13:00 – 13:45 @ Track B
Abstract
Pgpool-II now has 13 years of history if counted from the first generation of the software, pgpool.
Pgpool was originally born aiming to add missing features to PostgreSQL, including connection pooling and replication.
It has been evolving to Pgpool-II with a growth of PostgreSQL, and now it is used by many users in all over the world.
In this talk we first present the history of evolution of Pgpool-II,
then explain available features of Pgpool-II and how we can use them in a production environment.
Finally we will give some ideas for the future of Pgpool-II.
Speaker1
Tatsuo Ishii
SRA OSS, Inc. Japan
ishii@sraoss.co.jp
Profile
Tatsuo Ishii is the original author of the earliest version of Pgpool-II. Currently, he is actively working on development of Pgpool-II as a project leader.
He has been involved in PostgreSQL since it was born and is one of the PostgreSQL committers.
His is working for SRA OSS, Inc. Japan as a branch manager.
Speaker2
Yugo Nagata
SRA OSS, Inc. Japan
nagata@sraoss.co.jp
Profile
Yugo Nagata is a member of PostgreSQL professional technical group in SRA OSS, Inc. Japan.
He is in charge of PostgreSQL support, training and consulting, and also is a developer of Pgpool-II.
Language of the talk material: Japanese and English
PGroonga – Make PostgreSQL fast full text search platform for all languages!
December 3, 14:00 – 14:45 @ Track A
Abstract
PostgreSQL has built-in full text search feature. But it supports only limited languages. For example, it doesn’t
support Japanese. pg_trgm bundled in PostgreSQL supports all languages including Japanese. But it has performance problems for large documents.
This talk describes about PGroonga that resolves these problems.
Speaker
Kouhei Sutou
ClearCode Inc.
kou@clear-code.com
Twitter
LinkedIn
Profile
He is the author of PGroonga. He fixed some PostgreSQL bugs he found while he develops PGroonga.
Language of the Talk Material: Japanese and English
Logical Replication, Sharding & Multimaster Clusters
December 3, 14:00 – 14:45 @ Track B
Abstract
Review of progress on PostgreSQL technologies for logical replication using both pglogical and in-core replication, as well as their use for multi-master clustering in the Postgres-BDR project. We will also discuss Postgres-XL and other technologies.
Speaker
Simon Riggs
2ndQuadrant, England
simon@2ndquadrant.com
Profile
Simon Riggs is a PostgreSQL Committer and CTO of 2ndQuadrant, the Open Source PostgreSQL Support Company.
Language of the Talk Material: English
Evolution of pgAdmin: pgAdmin4
December 3, 15:15 – 16:00 @ Track A
Abstract
In this talk we’ll look at the evolution of the most popular Open Source management tool for PostgreSQL from pgAdmin III to the upcoming pgAdmin 4. We’ll look at the reasons for the re-write, technology choices, requirements, development methodology, and end with a demonstration of the new application.
Speaker
Dave Page
Enterprise DB, England
dpage@pgadmin.org
Profile
Dave Page has been actively involved in the PostgreSQL Project since 1998,as the lead developer of pgAdmin, maintainer of the PostgreSQL installers and one of the projects resident Windows hackers. He also serves on the project’s web and sysadmin teams and is a member of the PostgreSQL Core Team. Dave is employed by EnterpriseDB where he works as Vice President & Chief Software Architect, Tools & Installers on EnterpriseDB products in addition to his community PostgreSQL work.
Language of the Talk Material: English
What are the similarities and differences of using PostgreSQL between Japan and Europe?
December 3, 15:15 – 16:00 @ Track B
Abstract
Open source software have been developed by a lot of developers all over the world and it is said that the number of developers working in Europe is the second largest part in the world, just after the US. Although PostgreSQL is one of the open source software born in the US, many useful features and tools have been appeared by European developers and introduced in every PostgreSQL event. Moreover the number of case studies that PostgreSQL is used on the large-scaled systems has also been increasing in Europe.
I have realized that there were the technical information which had not come into Asia and Japan yet, and similarities and differences of using PostgreSQL between Japan and Europe, through joining the events held in the UK, Spain, Belgium and Austria since I started to work in the UK in spring 2014. I hope my presentation introducing them will be helpful to those people who use PostgreSQL and consider using it.
Speaker
Yoko Takase
Ashisuto, Japan
ykoizumi@ashisuto.co.jp
Profile
Yoko Takase took part in the starting up of PostgreSQL and EDB Postgres services in Ashisuto, after engaging in supporting of Oracle Database. She moved to the UK in April, 2014 and has been writing up how database things are in Europe.
Language of the Talk Material: English