On October 9th, 2024, we had the PostgreSQL October Meetup in Berlin. Amazon hosted it, and sponsored the Meetup in their office in the Brüderstraße, in Berlin Mitte.
AWS switched from Charlottenstraße to Brüderstraße this time, which - for me - was a bit more convenient. The Meetup was fully booked well in advance, we had 130 signups and still around 50 people on the waitlist. In the end we had 68 people attending, that is a very good turnout. We as the organizers are taking notes who just signs up and never shows up to Meetups, and will use this information at further events to give other people a realistic chance to attend.
Josef Machytka: GIN, BTREE_GIN and BTREE indexes on JSONB data - use cases and performance tests
Josef Machytka from NetApp Germany (credativ division) presented an interesting talk where he stores GitHub events data from workflow notifications in PostgreSQL. This data is in JSON format, and sometimes quite large. An ideal testcase for different compression algorithms and various strategies for optimizing read access to important parts of the data, using a variety of index types.
- Slides for this presentation
- Blog Posting: TOASTed JSONB data in PostgreSQL: performance tests of different compression algorithms
Aychin Gasimov: What’s new in PostgreSQL 17
Aychin Gasimov from Amazon Web Services (AWS) presented the new features he likes most in the recently released PostgreSQL version 17. He paid particular attention to features which help running PostgreSQL in hosted environments, as example he showed the new incremental backup features in detail. Also the new VACUUM settings and monitoring options are interesting.
Pizza
Pizza already arrived before the talks, that made sure that no one is hungry during the talks!
Amazon also provided some sweets and chocolate, as well as soft drinks, hot beverages and water.
Thank you
The Meetup was organized by Aleshkova Daria (Amazon AWS) and Aychin Gasimov (Amazon AWS). Thank you!
Daria posted more pictures on LinkedIn as well.
Speaking at a future Berlin PostgreSQL Meetup
The PostgreSQL Meetup group in Berlin exists since 2015, and currently has around 2100 members.
The Meetup group is always looking for speakers, and venues to host a Meetup.
If you are interested in either speaking about a PostgreSQL-related topic, or if your company is interested in hosting a Meetup, please contact the organizers.
A Meetup is an opportunity to test a talk in front of a smaller audience, before presenting it at a conference. There is no time limit at the Meetup, there is enough time for questions, and the feedback is more direct.
If you are unsure if your topic fits, let’s discuss. Here to help. We are also accepting Lightning Talks.
Getting there
On my way to the Amazon office I took the tram from the train station. Lucky me found an open ice cream parlor (Waffel oder Becher, Spandauer Straße) right across the tram station. From there I walked across the Marx-Engels Forum and Spreeinsel to the office. Nice walk, the weather was also pleasant.
Comments
With an account on the Fediverse or Mastodon, you can respond to this post. Known replies are displayed below:
Note: This will load data from mastodon.social.
Learn how this is implemented here.
Share: