Meetup PG ConfEU : The Dutch Talks

Dear PostgreSQL Users,

First of all we would like to wish all members of the PostgreSQL User group a Merry Christmas and Happy Newyear! We are looking forward to yet another great PostgreSQL year.

To help you start the New Year well we are inviting you to a new meetup, which is planned on January 30th 2020. The theme is PG ConfEU- The Dutch talks.

During the last PG ConfEU in October, which was held in Milan, two Dutch PostgreSQL enthusiasts were present on the schedule to deliver a talk: Sebastian Mannem and Martijn Dashorst. For all of you who were not able to attend the conference in Milan, we asked Sebastian and Martijn to do their talk again and this time for a home audience.

We are very happy that Bol.com had agree to be our host again. Thank you all at Bol!

As usual we offer the opportunity to participate in the Lightning Talks. If you have anything to share on the subject of PostgreSQL, please let us know and we are happy to give you the floor for 3 minutes.

We are looking forward meeting you all on January 30th.

Coen Hamers (Splendid Data)
Gerard Zuidweg (OptimaData)
*************

Our Agenda:

17.30 - 18:15
ARRIVAL

18:15
WELCOME

By Gerard en Coen

18:20 – 18.30:
WELCOME

By Bol.com

18:30 – 19:15
HOW MANY CPUs FOR 60000 TPS
By Sebastian Mannem

ABOUT SEBASTIAN
Technically driven database, container and cloud specialist. Earned my stripes and was battle hardened by the Dutch Government and Bol.com. Now working for EnterpriseDB as Sr. Consultant. All of that is of course a side show to my real job: loving my wife and three young children

THE TALK
I have done some interesting research on the relationship between the number of CPU's and the TPS that is achievable. This is the results of that research. A lot of Graphs show some very interesting details on The number of concurrent connections, the number of CPU's the impact of SSD (vs tmpfs), fsync=off, etc. and a lot of other comparisons.

19.15 – 20:00
CONVERTING 85% OF DUTCH PRIMARY SCHOOLS FROM ORACLE TO POSTGRESQL
By Martijn Dashorst

ABOUT MARTIJN
Martijn Dashorst is a software engineer for over 20 years and has worked with various databases over the years, including DB2, Oracle, Sqlserver, SABDB and PostgreSQL.As a Java (enterprise) developer he has worked in the education sector for over 12 years and developed student information systems for each of the Dutch levels of eduction. During those years he has worked on the open source Java web framework Apache Wicket, and given numerous presentations on that and other subjects on international conferences and meetups.

THE TALK
This case study describes migrating the most used application for primary schools in the Netherlands from Oracle to PostgreSQL. The application uses a multi-tenant, single schema database (i.e. 6000 schools in a single database) and runs using a typical Java EE frontend.

You will learn about our application architecture, hardware platform, reasons for switching, migration strategies considered and the results of our migration.

Since the CFP closes one week before our actual migration we can't reveal the results in this abstract, but the presentation will capture all the things that went wrong and well

20:00 – 20:15
LIGHTNING TALKS

20.15 – 21.00
WRAP UP and get together with refreshments