2017年9月22日

DAY 1 (Enterprise User Conference)

December 5, 2017 – Sessions for Partners(DAY 1)
track A (with translation) track B
9:20 – 10:00 Reception
10:00 – 10:10 (10 min) Opening Speech
10:10 – 10:55 (45 min) PostgreSQL universal database
Oleg Bartunov
10:55 – 11:40 (45 min) PostgreSQL Strengthen Our Country
Julyanto Sutandang
11:40 – 13:00 (80 min) Lunch Break
13:00 – 13:40 (40 min) What’s new in PostgreSQL 10
Magnus Hagander
Eliminating PostgreSQL 19% cache-misses and 6% clock cycles by using GCC optimizations
Tsung-Chun Lin
13:40 – 13:50 (10 min) Break
13:50 – 14:30 (40 min) Postgres as BI platform for largest Irish pharmacy supplier’s chain, our experience and errors
Andy Fefelov
Road to a multi-model database: making PostgreSQL the most popular and versatile database
Takayuki Tsunakawa
14:30 – 14:40 (10 min) Break
14:40 – 15:20 (40 min) PostgreSQL Replication 2.0
Masahiko Sawada
Ranges Partitioning and Limitations
Corey Huinker
15:20 – 15:30 (10 min) Break
15:30 – 16:10 (40 min) NoSQL Best Practices for PostgreSQL
Dmitry Dolgov
Hello, PostgreSQL for Azure Database! ~ Microsoft’s data strategy and PostgreSQL ~
Uiko Yokoi
16:10 – 16:20 (10 min) Break
16:20 – 17:00 (40 min) Data warehousing with PostgreSQL 10 : Know-hows which is extracted from case study
Ayumi Ishii
PGroonga 2.0 – Make PostgreSQL rich full text search system backend!
Kouhei Sutou

 

PostgreSQL universal database

12/05 10:10 – 10:55

– Abstract –
The objective of my talk is to show the future of PostgreSQL as a Universal Database. By now, PostgreSQL has gained considerable popularity not only in the open source community, but also with big corporate users. There are several factors for this change, and one of them is the disclosure of development roadmaps published by major Postgres-centric companies. These companies employ PostgreSQL contributors, who implement user-demanded features. Even if implemented in proprietary forks, these features are eventually returned to the open-source community. To be commercially successful, Postgres companies have to compete with other databases available in the market today. Some of them are traditional relational databases, whereas others are specialized, niche databases focused on new emerging applications. The key feature of the original Postgres design is its extensibility. I am a proponent of the idea that PostgreSQL should improve and apply its extensibility to fill many niches, such as web, fintech, blockchain, etc. Therefore, I see the future of PostgreSQL as a Universal Database working with a very wide range of applications in the future world. NoSQL Postgres is one example of how PostgreSQL provides unique combination of rich functionality of powerful relational database and flexibility of nosql systems.


– Speaker –
Oleg Bartunov
Postgres Professional

– Profile –

Language of presentation:English
Language of presentation material:English

Presentation material


 

PostgreSQL Strengthen Our Country

12/05 10:55 – 11:40

– Abstract –
PostgreSQL has been around since 2010 in Indonesia, starts that year we have more and more evidence of Implementation PostgreSQL in replace (usually) Commercial Proprietary Databases such as Oracle. With its high capacity, high availability, and high performance. Right now many banks including BCA and Mandiri (the two biggestbank in Indonesia)It is a great opportunity for such of Open Source Product like PostgreSQL being used in many implementations especially in Financial Industries in Indonesia. Some of the great achievement from us is: Migration 10.000 LoC, 659 Tables from 3 Sparc Server Oracle into a single Intel Server on PostgreSQL, and runs stable in production level. The Launching of PostgreSQL 10 in Indonesia has covered by close to 20 News mediaincluding Printed media as well. This is very great since we never had this such phenomenal acceptance before. Indonesia Business Society has ready to adopt more PostgreSQL even deeper and greater. Indonesia needs Open Source, to strengthen our economy, to save capital, to ensure data Integrity and security.

– Speaker –
Julyanto Sutandang
Equnix Business Solutions

– Profile –
CEO
Equnix Business Solutions, Pte Ltd.
Equnix Business Solutions, PT

Directs Equnix Business Solutions as Open Source based IT Solution Provider for Enterprises.
We deliver solution in High Performance Transaction System Operation in Banking, Retail, Telecom and others. develop customized world class quality software solution.
Most of our solutions focused on High Performance Transaction System with compliance to RAS (Reliability, Availability, and Scalability).
Serving Enterprise RDBMS PostgreSQL Maintenance/Managed Services 24/7 We also conduct Professional Training.
Our training is greatly deep in concept and knowledge, with full exposure to practice, Hands-On and applicable with real world situation and challenges.
Provides World Class Support 24/7 for Mission Critical Operation / Installations from Infrastructure, Databases, Business Process / Applications, Security, Stability and Scalability.

Speaker at PGDay ASIA in Singapore – 2016
TOPIC: PostgreSQL Rocks Indonesia.

Speaker at PGDay ASIA in Singapore 2017
TOPIC: Massive Multinode Postgres-BDR in Retail Industry

GOLD Sponsor in PGCON World Conference in OTTAWA 2014
A World level PostgreSQL Summit in Ottawa, Canada

Language of presentation:English
Language of presentation material:English

Presentation material


 

What’s new in PostgreSQL 10

12/05 13:00 – 13:40 @ Track A

– Abstract –
PostgreSQL 10 is the latest and greatest version of PostgreSQL. This talk will outline some of the new features in this exciting new release!

– Speaker –
Magnus Hagander

– 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 presentation:English
Language of presentation material:English

Presentation material


 

Eliminating PostgreSQL 19% cache-misses and 6% clock cycles by using GCC optimizations

12/05 13:00 – 13:40 @ Track B

– Abstract –
This talk provides qualitative insights into PostgreSQL source code structure for people who want to enhance its performance. We will present an in-depth observation of instruction-per-cycles, cache misses, and memory consumption of each function in PostgreSQL. The profiling result shows performance bottlenecks have repeating patterns. Take SnapshotData for example. In most cases, the value of condition variables of GetTransactionSnapshot function are identical. If we know the value of these variables, then we can simplify conditions of the control flow, and get further performance improvement. We use this concept and leverage GCC’s two optimizations – clone function optimization and variable range propagation – to eliminate 6% clock cycles and reduce 19% cache-misses dramatically.

– Speaker –
Tsung-Chun Lin
Skymizer

– Profile –
Tsung-Chun Lin is an compiler engineer of Andes Technology.
His work focuses on compiler optimization in GCC and LLVM.

Language of presentation:English
Language of presentation material:English

Presentation material


 

Postgres as BI platform for largest Irish pharmacy supplier’s chain, our experience and errors

12/05 13:50 – 14:30 @ Track A

– Abstract –
I will talk about our BI application which we built on Postgres for largest Irish pharmacy supplier’s chain. We will review business requirements shortly. Later on I will describe specific of our architecture, why we chose snowflake scheme and how we are doing extract, transformation and load procedures. It will be mentioned about special Postgres tuning for OLAP and massive data bulk load workloads. Also I will let you know about Postgres usage as a column database with cstore_fdw by Citus and results achieved. Cons and problems of our approach will be described in the end of the talk.

– Speaker –
Andy Fefelov

– Profile –
Database Architector and Project Manager in a wide variety of business applications.
Strongly interested in server and relational database design using Postgres and Rails.
Started to work with database since 2006, began with Oracle, but later on fallen in love with Postgres.
Was CTO at pulscen.ru, blizko.ru. Now is engaged in development of BI platform based on Postgres for largest pharmaceutical selling group in Ireland.

Language of presentation:English
Language of presentation material:English

Presentation material


 

Road to a multi-model database: making PostgreSQL the most popular and versatile database

12/05 13:50 – 14:30 @ Track B

– Abstract –
More and more applications are using diverse data models other than the relational model to represent various things in the real world digitally.
In order for PostgreSQL to respond to more needs and prosper, it is essential to be able to handle those data models.
In this session, I will give insight into what PostgreSQL should aim for as a multi-model database.

– Speaker –
Takayuki Tsunakawa
Fujitsu Limited

– Profile –
A software engineer wishing to make PostgreSQL the world’s most popular database.
I participate in the development in the PostgreSQL community and have my name on the contributor list.
At Fujitsu, I am involved in the development and support of PostgreSQL based database products such as Fujitsu Enterprise Postgres and Symfoware, and database appliance PRIMEFLEX for HA Database.
In order to encourage the adoption of PostgreSQL, I’ve been collecting information on ecosystem on the Wiki:
https://wiki.postgresql.org/wiki/Ecosystem:PostgreSQL_ecosystem

Language of presentation:English or Japanese
Language of presentation material:English

Presentation material


 

PostgreSQL Replication 2.0

12/05 14:40 – 15:20 @ Track A

– Abstract –
Since PostgreSQL 9.0 when streaming replication feature was introduced, the replication feature of PostgreSQL has continued to evolve. And in coming PostgreSQL 10, PostgreSQL replication feature enters the next stage by introducing the logical replication. In this session, I’ll talk about those PostgreSQL replication features including some new features in PostgreSQL 10, their usages, when we should use them and so on while looking back into the history of PostgreSQL replication feature.

– Speaker –
Masahiko Sawada
NTT OSS Center

– Profile –

Language of presentation:Japanese
Language of presentation material:Japanese

Presentation material


 

Ranges Partitioning and Limitations

12/05 14:40 – 15:20 @ Track B

– Abstract –
Covers range fundamentals, some discussion of missing features, and a look into partitioning via ranges in versions prior to v10, and how that will change in v10.

– Speaker –
Corey Huinker

– Profile –
Corey is a database programmer and the president of Corlogic Consulting in New York City.

Language of presentation:English
Language of presentation material:English

Presentation material


 

NoSQL Best Practices for PostgreSQL

12/05 15:30 – 16:10 @ Track A

– Abstract –
Everyone already knows the Jsonb data type: one of PostgreSQL’s most attractive features which allows efficient work with semi-structured data without sacrificing strong consistency and ability to use all the power of proven relational technology. But what exactly is inside Jsonb, are there any caveats, and how can you accidentally bring down performance?
We will discuss all that questions altogether with advantages and disadvantages of using Jsonb in different situations in comparison with other solutions and existing standards. I’ll show some important best practices about how to write compact queries to work with Jsonb and avoid common mistakes/performance problems.

– Speaker –
Dmitry Dolgov
Zalando

– Profile –
Software engineer at Zalando SE, involved in the development and improvement of NoSQL features of PostgreSQL.

Language of presentation:English
Language of presentation material:English

Presentation material


 

Hello, PostgreSQL for Azure Database! ~ Microsoft’s data strategy and PostgreSQL ~

12/05 15:30 – 16:10 @ Track B

– Abstract –

– Speaker –
Uiko Yokoi
Microsoft Japan

– Profile –

Language of presentation:Japanese
Language of presentation material:Japanese

* The presentation material of this session will not be published.


 

Data warehousing with PostgreSQL 10 : Know-hows which is extracted from case study

12/05 16:20 – 17:00 @ Track A

– Abstract –
Recent PostgreSQL enhances function as DWH like parallel query. In this session, I will talk about points which PostgreSQL engineer should understand when using PostgreSQL as DWH based on NTT DATA’s case study.

– Speaker –
Ayumi Ishii
NTT Data

– Profile –
Ms.Ishii is PostgreSQL Engineer in NTT Data Corporation.
She works on technical support for large database project in the field of Healthcare, Public Sector, Manufacturing and Retail.

Language of presentation:Japanese
Language of presentation material:Japanese

Presentation material


 

PGroonga 2.0 – Make PostgreSQL rich full text search system backend!

12/05 16:20 – 17:00 @ Track B

– Abstract –
PGroonga 2.0 will be released with 2 years development since PGroonga 1.0.0. PGroonga 1.0.0 just provides fast full text search with all languages support. It’s important because it’s a lacked feature in PostgreSQL. PGroonga 2.0 provides more useful features to implement rich full text search system with PostgreSQL. This session shows how to implement rich full text search system with PostgreSQL!

– Speaker –
Kouhei Sutou
ClearCode Inc.

– Profile –
Kouhei Sutou is the author of PGroonga.
He investigates and fixes PostgreSQL bugs found during the development of PGroonga.

Language of presentation:Japanese
Language of presentation material:English and Japanese

Presentation material