PostgreSQL Usergroup NL meets Picnic
PostgreSQL meetup February 15th 2023
We are happy to invite you to the first "PostgreSQL UserGroup NL" meetup of 2023 with a great line-up and a new venue: Picnic in Amsterdam!
Next to some interesting headliners in this meetup 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.
This Meetup will be held at the office of Picnic, Van Marwijk Kooystraat, Amsterdam. We are going to have some food and drinks. Many thanks to Picnic for their hospitality!!
Let’s meet and shake hands on Feb 15th.
17:30 - 18:30 Arrive, food and drinks
18:30 - 18:35 Opening by Gerard Zuidweg, OptimaData
18:35 - 19:20 Franklin Anderson de Amorim, Picnic
19:20 - 20:00 Matthias van de Meent, Neon
20:00 - 20:15 Lightning talks
20:15 - xx:xx Wrap up, networking and refreshments
UNLOCKING THE POWER OF CHANGE DATA CAPTURE AT PICNIC WITH POSTGRES AND DEBEZIUM
by Franklin Anderson de Amorim
Franklin Amorim 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.
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, I 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.
What are Ligtning Talks?
A lightning talk is a very short presentation lasting only a few minutes. Everybody has the opportunity to take the stage for a few minutes and talk about a particular subject that he/she wants to share or even want some input on from the group. You can reserve your slot for a lightning talk by sending us a mail or write your name down on the day of the Meetup itself.
During a PostgreSQL Meetup we schedule the Lightning Talks to give everybody the oppertunity to get up the stage and share something.
Send us an email if you want to reserve a slot to share some of your experiences, knowlegde, funny or to ask the audience for feedback on a topic. Also you can write down your name on the list at the Meetup itself.
The Meetup will be held at Picnic's office in Amsterdam. We are very happy and grateful for the hospitality of Picnic to host this Meetup in Picnic's office.
Picnic is very easy to reach. The office is located next to Metrostation OverAmstel, at van Marwijk Kooystraat 15, Amsterdam. By car you drive from the Amsterdam ring S111 to the office building in barely five minutes. Parking is available for example in the Zuidpark parking garage.
The visiting address is Van Marwijk Kooystraat 15, Amsterdam
Van Marwijk Kooystraat 15
Gerard Zuidweg - OptimaData
Feike Steenbergen - TimeScaleDB
Franklin Anderson de Amorim - Picnic
Matthias van de Meent - Neon