NLEN
Technical support?
Home > About us > Events > Events publiceren > PostgreSQL Meetup february 15th 2023

PostgreSQL Usergroup NL meets Picnic

PostgreSQL meetup February 15th 2023

PostgreSQL Usergroup NL meets Picnic

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.

Agenda

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 de AmorimAbout Franklin:

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

 

Matthias van de MeentAbout 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.

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.

Lightning Talks

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.

Location

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

Signup

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
PostgreSQL meetup

February 15th

17:30 hours

Picnic Office
Van Marwijk Kooystraat 15
Amsterdam

Hosts

Gerard Zuidweg - OptimaData
Feike Steenbergen - TimeScaleDB

Speakers

Franklin Anderson de Amorim - Picnic
Matthias van de Meent - Neon

Signup

Contact us

Fill in your telephone number and we wil call you back as soon as possible. Or you can contact us yourself.

Contact us yourself

Stay up to date?

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