PostgreSQL User Group NL February 2023 Meetup @ Picnic

Dear members of the PostgreSQL User Group NL,

Our New Years resolution was to start 2023 with an interesting meetup early in the year.

Therefore we are very happy to invite you to the first "PostgreSQL User Group NL" meetup of 2023.

This time around we are welcome in Picnic Headquarters. Picnic is an innovative on-line supermarket that started out with a mission to rethink the way people buy food. Without physical stores, using an app-only approach and a user-centric philosophy, to make grocery shopping quick, simple, and fun. Surely a host with a mission and a good story! We are very grateful to Picnic for hosting the event and providing the food and drinks.

On the agenda is a talk of Picnic and a talk of Mathias van de Meent, a PostgreSQL contributor and PostgreSQL consultant at NEON.

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.

Let’s meet and shake hands on February 15th!.

Gerard Zuidweg (OptimaData)
Feike Steenbergen (Timescale)
*************
Our Agenda:

17:30 - 18:30 Arrive, food and drinks

18:30 - 18:35 Opening

18:35 - 19:20
Unlocking the Power of Change Data Capture at Picnic with Postgres and Debezium by Franklin Amorim
Franklin is a database engineer with more than 20 years of experience in the field, working with a variety of databases including Oracle, MySQL, MongoDB, Redis, Cassandra and PostgreSQL. In 2021, he made a move to the Netherlands and joined the team at Picnic.

In this presentation, we will provide an introduction to Debezium, a powerful tool for streaming data changes in near real-time. We will discuss how we have implemented Debezium in Picnic's automated fulfillment center. We will also showcase the specific use cases we have for Debezium and how it has positively impacted our operations. Overall, this presentation will provide insights on how Debezium and Postgres can be used together to build efficient data pipeline solutions.

19:20 – 20:00
Directing PostgreSQL to Performance: PostgreSQL Index improvements over time by Matthias van de Meent
About Matthias: Initially introduced to PostgreSQL in 2015 during my study and started using PostgreSQL professionally in 2017. I started watching the pgsql-hackers mailing list to check the progress of the "index skip scan" patch, during which I got familiar with the PostgreSQL development process. In 2020 I contributed my first bug fixes to PostgreSQL with some progress reporting fixes, and later in the PG14 development cycle helped finish the COPY progress reporting patch. Nowadays, I generally work on storage efficiency and computational performance in the btree AM.
Starting with PostgreSQL 11, there have been multiple advances in the BTree index method - the default index method for PostgreSQL. However, this is not unique to BTree: most index methods have seen significant performance improvements, which have resulted in significant storage savings and improved performance over the past 5 major releases.
This talk will show notable improvements in PostgreSQL's included index methods since PG11, including deduplication and optimistic pruning of dead index tuples. After that, it will go through the improvements currently being worked on for PostgreSQL 16, and finally, it will discuss what the future might bring for the index methods included in PostgreSQL.

20:00-20.15
Lightning Talks

20.15
Wrap up and get together with refreshments