Oracle to PostgreSQL Migration AND Database Performance

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 Bol.com . Food and drinks are for free. Thanks to Bol.com 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 Bol.com 

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

AN OVERVIEW OF TODAY’S ORACLE > POSTGRESQL MIGRATION APPROACHES AND TOOLS.

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

ANALYZING DATABASE PERFORMANCE

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 www.meetup.com. You don't have an account on Meetup yet? register for free at meetup.com and signup for this meetup!

Link to signup:

https://www.meetup.com/nl-NL/PostgreSQL-User-Group-NL/events/250876775

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

This meetup will be held at the main office of Bol.com in the WTC Papendorp, Utrecht. We are very happy and grateful for the hospitality of Bol.com to have this Meetup take place in the office of Bol.com.

Bol.com 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.

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

What is PostgreSQL?