Technical support?
Home > About us > Events > Events publiceren > Meetup 14 juni PostgreSQL

Oracle to PostgreSQL Migration AND Database Performance

Oracle to PostgreSQL Migration AND Database Performance

PostgreSQL Usergroup NL

Meetup June 14th PostgreSQL

We are really pleased to announce a new meeting together with the "PostgreSQL User Group NL"! Spread the word and let’s meet. Again, it will be a wonderful evening you simply cannot miss to gain PostgreSQL knowledge.

This time the Meetup will be held at the office of . Food and drinks are for free. Thanks to for their hospitality.

Let’s meet and shake hands!

We have 2 great talks lined up for you. First Coen Hamers - Splendid Data - will kick off and give you an exstensive insight into Migration Approaches and tools. Furthermore we are very pleased that Feike Steenbergen - Adyen - has agreed to share his experiences with Analyzing Database Performance.

Meetup host is Gerard Zuidweg - OptimaData


17:30 - 18:15: Arrival at the Location, food & Drinks

18:15 - 18.30: Welcome by Gerard Zuidweg (OptimaData) and 

18:30 - 19:15: Coen Hamers - Splendid Data

19:15 - 20:00: Feike Steenbergen – Adyen

20:00 - 20:30: Wrap up and get together with refreshments

Coen Hamers - Migration Approaches

Coen Hamers - Splendid Data


We do not need to explain to the members of this group what the strengths are of PostgreSQL when it comes stability, data integrity etc. More and more organizations are also becoming aware of these strengths and therefore increasingly the use of PostgreSQL as an alternative to Oracle. The desire of these organizations ensures the creation of multiple tools that help in the migration process. Currently, different migration methods and tools are offered by different PostgreSQL affiliates.

In this presentation we show an overview of the various approaches that are currently on the market. We will present an overview about the possibilities and impossibilities of the various tools and, based on our practical experience, what the various bottlenecks and pitfalls are. We also briefly explain the primary reasons for organizations to migrate.

Core phrases of this presentation are:

  • Why migrate from Oracle to PostgreSQL?
  • Migration of DB schema (database data objects)
  • Migration of procedures (database code objects)
  • Practical examples of data conversion

Feike Steenbergen - Database Performance

Feike Steenbergen - Adyen


Database Performance will at some point become important for almost every database, whether you require faster response times for your users, or your database instance is sometimes fully utilized, you will need to investigate and resolve the issue.

Performance tuning your queries is one of the best ways of increasing the speed of your database, with better performance you may even run your databases on smaller (cloud) instances.

PostgreSQL itself provides a lot of out-of-the-box tools to aid you in analyzing your performance. This session covers the following topics:

  • logging and analyzing slow queries using the diagnostic logs
  • using the pg_stat_statements extension to track queries
  • use EXPLAIN and EXPLAIN ANALYZE to understand the query plan for a query
  • how the PostgreSQL planner uses statistics to determine the optimal query plan
  • use the statistics collector views to identify common patterns (e.g. missing index)

All of these topics will be accompanied with examples using the psql terminal to show that even though additional tools (profiling, graphing) provide a lot of value, you do not need those tools to get started with performance improvements.

Feike is working for Adyen as a PostgreSQL Database engineer. Previously he has worked at Zalando, where he was part of the team that designed and built Patroni. He has been training people in PostgreSQL for the last 10 years.


You can signup to attend this meetup in the meetup-group "PostgreSQL Usergroup NL" at You don't have an account on Meetup yet? register for free at and signup for this meetup!

Link to signup:

Need any help to signup or you have any questions? Don't hesistate to give us a call.


WTC Papendorp, hoofdkantoor Meetup june 14th

This meetup will be held at the main office of in the WTC Papendorp, Utrecht. We are very happy and grateful for the hospitality of to have this Meetup take place in the office of is very easy to reach. The office is located in the WTC papendorp in Utrecht on the Papendorpseweg. By car you drive from the ring of Utrecht in just ten minutes to the office building. Various buses stop just about the door.

Still with the car? The visiting address is WTC Papendorp, Papendorpseweg 96, Utrecht.

Reading list

To know more about PostgreSQL in general just take a look at these blogposts:

What is PostgreSQL?


"Migration Approaches and Analyzing Database Performance" 

Juni 14th 2018
Between 17:30 and 20:30 hours 
Oracle > PostgreSQL Migrations
Migration tooling
Analyzing Database Performance
Performance Tuning 

Location WTC Papendorp Utrecht
Papendorpseweg 96, Utrecht

Signup for free

Use #pgNL18 to share, like on social media

Stay up to date?

Leave your emailadres and stay up to date with the latest open source database news, events and blogs.