The Swiss conference on PostgreSQL

This site is about a previous instance of this event. For the current event, please see the updated site.

Swiss PGDay 2023

This conference is all about PostgreSQL - the world's most advanced open source database. Take the opportunity to meet other people with an interest in PostgreSQL in the Swiss community.

For the first time, this year's SwissPGDay will last one and a half days. This allows us to invite all participants to a community party at the end of the first day (Thursday) to support networking and personal exchange. The conference will start on Thursday and will run for 1.5 days with two tracks of presentations, one in English and one in German. To give people more time to travel home on Friday, we'll finish around noon.

We will also have a poster exhibition and a lightning-talk session where attendees can present their projects, ideas and use cases to each other without having to prepare a full talk. The event is suitable for everyone, from novices to experts and from back office staff to decision makers.

Do you have questions or suggestions? Please let us know by e-mail: info@pgday.ch.

We are looking forward to welcome you!
The organizing committee

The Swiss PGDay is organized by the Swiss PostgreSQL Users Group (SwissPUG)


Sponsors

We would love to hear about your project, your experiences (good and bad), your favorite extensions, or any other interesting topic around PostgreSQL and its community.
Please note that the PostgreSQL Conference Germany will happen in the same week earlier on Tuesday (27th of June).

Poster Exhibition

If you don't want to give a talk or have a topic that is smaller in scale, we offer another platform for presentations: You can create a poster that will be displayed in the exhibition room and you will have the opportunity to explain your work in the joint poster session. Topics for posters can include scientific work related to databases, you can present your favourite software projects, tools, blog posts or your own success stories and use cases. Please note that commercial advertisements, company or product presentations are not allowed on posters. For these, you are free to sponsor the event or use the job board.

To participate in the poster exhibition, please email the topic of your poster with a short abstract to info@pgday.ch by May 15 May 31, 2023. If accepted, please submit your poster in high-resolution PDF format by May 31, 2023 June 15, 2023, and indicate whether you will be able to bring a physical copy. If you need assistance with printing, we can provide a limited service. All displayed posters will be listed on the homepage and their authors will be invited to present their work in the poster session. Depending on the amount of feedback, we may turn the poster session into lightning talks.

Call for Speakers (closed)

  • A session lasts 50 minutes including questions.
  • Tell us about your proposal.
    1. A title and an abstract of about 1500 characters.
    2. A short text about you and your relation to PostgreSQL.
    3. A picture of yourself.
    4. Please indicate the language of your talk (English or German). You may submit the same talk in both languages if you wish.
    5. Target audience / category of your talk: General, DBA, Developers
  • Fill out the form on the right and submit your proposal by April 17, 2023, 23:59 CEST. We will notify all submitters of the outcome of the selection process by April 28, 2023.
  • Please note that proposals from speakers affiliated with companies sponsoring the event are not privileged and will be treated equally.
  • Confirmed speakers will get free access to the conference and are invited to the speaker's dinner the night before the conference.
  • For a description of the talk selection process and program committee, see the About tab.

The Call for Speakers is closed since 2023-04-17.

The registrations is closed since 2023-06-29.

Thursday, 29.06.2023
Time English Track - Room 3.008 German Track - Room 3.010
08:15 - 09:00 Registration / Coffee - Cafeteria in building 8
09:00 - 09:10 Welcome: Stefan Keller (OST) - Room 3.008
Stefan Keller

Stefan Keller

Professor for information systems, founder and head of Geometa Labs. Keller is a member of the Swiss PGDay board and involved in various open source projects such as PostGIS and QGIS and open data initiatives, e.g. OpenStreetMap. Besides, he is generally interested in geographic data and their visualization as well as in the the integration of open source and proprietary solutions (e.g. QGIS and ArcGIS).

Professor für Informationssysteme sowie Leiter und Gründer des Geometa Labs. Ist u.a. Mitglied des Swiss PGDay OK und engagiert in verschiedenen Open Source Projekten (z.B. PostGIS und QGIS) und Open Data (v.a. OpenStreetMap). Zudem interessieren ihn allgemein Geodaten und Geovisualisierung sowie die Integration von Open Source und proprietärer Software (z.B. QGIS und ArcGIS).

Slides Picture
09:10 - 10:00 Keynote: Vik Fearing, Property Graphs: When the Relational Model Is Not Enough - Room 3.008
Vik Fearing

Vik Fearing, EDB

Property Graphs: When the Relational Model Is Not Enough

This talk will present SQL/PGQ, a new feature of the upcoming SQL:2023 standard. Sometimes the data we need to deal with and the way we need to query it is too much for the relational model. We will explore some examples of this, and see how the SQL Committee has decided to tackle the problem. We will also review the history of query languages and see how 60 years of research has produced this solution. Finally, we will discuss how this might be implemented in PostgreSQL.

Target audience: General, Level: Beginner

Vik Fearing is a PostgreSQL expert at EDB, and lives in France. He has been in the PostgreSQL community since 2008 and is the founder and co-organizer of pgDay Paris, co-organizer of PostgreSQL Conference Europe, and a volunteer and speaker at many other conferences around the world. He is also a moderator for several of the PostgreSQL mailing lists as well as an IRC channel operator for #postgresql and #postgresqlfr. He is an inaugural member of the PostgreSQL Code of Conduct Committee and part of the team behind the @PostgreSQL Twitter account. In his spare time, he likes to write minor patches to the PostgreSQL codebase.

Picture
10:00 - 10:20 Break - Cafeteria in building 8
10:20 - 11:10 Kevin Kempter, Exponential Scaling with PostgreSQL
Kevin Kempter

Kevin Kempter, Phoenix International Consulting Group

Exponential Scaling with PostgreSQL

This talk will present an overview of scaling within a DB2 to PostgreSQL Conversion Project, where we utilized Foriegn Data Wrappers for horizontal scaling and pgpool for load balancing of reads. In our case the load balancing traffic is directed across a set of servers we deemed "Federated" nodes so the FDW connections were also communicating with read only database nodes.
Agenda

  • Introduction
  • Project Overview
  • Customer DB servers (a mix of multitenant and single customer servers)
  • FDW setup / introducing the PG "Federated" node
  • Scaling and performance Overview
  • Load balancing of reads across Federated nodes
  • Failover Operations
  • Operational demo
  • Questions

Target audience: General, Level: Intermediate

Kevin Kempter is the Founder and Chief Data Architect for Phoenix International Consulting Group (PhoenixICG). Kevin has been in the IT field working with Unix/Linux based systems for more than 30 years. He has been working with PostgreSQL data systems for more than 20 years. Kevin has been the primary PostgreSQL / Data Architect for numerous projects including DB platform conversions, large scale reporting systems, and scaling and performance projects for OLTP based systems. Kevin has a background in C, Unix, and embedded SQL, this foundation has served him well as he moved into technical lead and architecture lead roles. He also has extensive experience in large scale reporting systems, going back to the early Data Warehouse days, including a role for Informix Software as one of two Principal Consultants. Kevin has also worked for organizations in a variety of industries and market segments such as, health care, retail, finance, education and US government. He also delivers professional PostgreSQL training on a regular basis, for clients such as the US Navy, the FBI, Whole Foods, Fannie Mae and the Bank of Jamacia. Kevin started working on the framework for PhoenixICG in 2015 and today is helping clients realize significantly increased ROI from a variety of PostgreSQL centric projects. Kevin can be reached at kevink@phxicg.com

Slides Picture
Laurenz Albe, Wie erzeuge ich Datenkorruption (und wie repariere ich sie wieder)
Laurenz Albe

Laurenz Albe, Cybertec

Wie erzeuge ich Datenkorruption (und wie repariere ich sie wieder)

PostgreSQL ist ziemlich "deppensicher" und lässt normalerweise nichts zu, was die Datenbank zerstören kann. Dennoch schaffen es Leute immer wieder. Im ersten Teil meines Vortrages stelle ich Methoden vor, die Leute (unabsichtlich) gefunden haben, um Datenkorruption zu erzeugen, und die man also am besten vermeidet. Der zweite Teil des Vortrages gibt Handreichungen, wie man mit Datenkorruption umgehen kann, wenn sie doch einmal passiert.

Target audience: DBA, Level: Intermediate

PostgreSQL contributor, senior database engineer and maintainer of oracle_fdw and pgreplay

Slides Picture
11:20 - 12:10 Frits Hoogland, PostgreSQL memory usage: where did my memory go?
Frits Hoogland

Frits Hoogland, Yugabyte

PostgreSQL memory usage: where did my memory go?

PostgreSQL relies on the Operating System for memory management. The database performance and response time depends on memory availability, so PostgreSQL requests and releases memory at runtime. But when PostgreSQL deallocates memory, the OS might not do what the database asks for. This session is a deep dive into the OS and PostgreSQL memory usage principles that will help you master the understanding of how this resource is actually used and managed. You’ll learn how and why memory oversubscription impacts database response time. You’ll see how memory usage gets exaggerated with a growing number of application connections. Lastly, you’ll discover that the OS doesn’t deallocate memory at all times…even when PostgreSQL explicitly asks to take the memory back.

Target audience: DBA, Level: Advanced

Frits Hoogland is a developer advocate at Yugabyte, where he works on cloud native open source technology and performance challenges. He’s an IT professional who believes in applying a scientific approach to performing IT tasks. He spent 25 years working predominantly with Oracle database technology solving performance issues for some of the biggest companies of the world. He also worked for the highly-acclaimed Enkitec corporation and co-wrote a book about Oracle Exadata, and helped the university of Rotterdam build a database for DNA to aid pathological gene selection.

Slides Picture
Julia Gugel, Hero + Hero = Superhero
Julia Gugel

Julia Gugel, dbi services

Hero + Hero = Superhero

The first hero gives you high availability and reliability. The second hero gives you disaster recovery and recovery from human errors. What happens if we combine those heroes to get a kind of superhero? We're talking about Patroni and pgBackRest here: Can/will they integrate? We'll see that live, reproducible for you with easy step by step instructions.

Target audience: General, Level: Beginner

Julia Gugel hat mehr als 10 Jahre Erfahrung im IT Bereich. Sie ist spezialisiert in PostgreSQL Datenbanken. Während der letzten Jahre hat sich Julia immer mehr für Open Source-Technologien interessiert und sich in diesem Bereich stetig weiter entwickelt. Anhand von Community- oder EnterpriseDB-Tools entwickelt und installiert sie komplexe Hochverfügbarkeitslösungen mit PostgreSQL.

Slides Picture
12:10 - 13:20 Lunch - Mensa in building 4
13:20 - 14:10 Greg Vernon, Don't Do High Availability, Do Right Availability
Greg Vernon

Greg Vernon

Don't Do High Availability, Do Right Availability

We as DBAs often focus on trying to provide the highest availability that we can. Perhaps that's not quite the right thing to do. Depending on your requirements you might not need all of the high availability features that are available. This talk will look at what can be done to provide a service that fits needs that are less than 24x7, but still manage to protect data integrity, and do so economically.

Target audience: DBA, Level: Beginner

Greg Vernon has been involved with databases since he started working with Oracle DBs at Boeing in the late 1990s. Since his move to Switzerland, he has worked as a system engineer and DBA at Switch, and later at SwissSign. PostgreSQL has been his database of choice. He is now retired but still is interested in database topics, especially spatial data.

Slides Picture
Marion Baumgartner & Marc Fasel, PostGIS und pgRouting als räumliche Datenbank-Erweiterungen für PostgreSQL
Name

Marion Baumgartner & Marc Fasel, Camptocamp SA

PostGIS und pgRouting als räumliche Datenbank-Erweiterungen für PostgreSQL

In modernen Applikationen werden geographische und räumliche Daten immer wichtiger, welche effizient in einer Datenbank gespeichert und verarbeitet werden müssen. PostGIS, als Erweiterung von PostgreSQL für geographische und räumliche Daten, bietet diese Möglichkeit. In Kombination mit pgRouting wird eine Routing-Funktionalität innerhalb einer PostgreSQL Datenbank ermöglicht. Mit den oben genannten Möglichkeiten für die Verarbeitung und Auswertungen können z.B. räumliche Daten aggregiert werden oder die Fragen "Welches ist der kürzeste Weg von Punkt A nach Punkt B?” beantwortet werden. PostGIS und pgRouting sind beide Open-Source und werden unter der GNU General Public License veröffentlicht. Der Unterhalt und die Weiterentwicklung werden durch eine grosse Community seit 23 Jahren gewährleistet. Als Extensions lassen sich beide in PostgreSQL integrieren und können dann von einer Vielzahl an Software Produkten weiter verwendet werden. In diesem Talk werden wir eine kurze Einführung in PostGIS und pgRouting geben und anhand von Beispielen aus der Praxis einen Einblick für mögliche Einsatzgebiete von PostGIS sowie pgRouting aufzeigen.

Target audience: General, Level: Beginner

Marion Baumgartner: I am a software developer and work for the company Camptocamp, developing GIS open source software. Besides development, I do a lot of data integration with geo-spacial data where PostgreSQL and PostGIS are my good companions.

Marc Fasel: Marc ist Dateningenieur bei Camptocamp SA und entwickelt Open-Source-basierte GIS-Lösungen. Er arbeitet hauptsächlich mit PostgreSQL/PostGIS und verschiedenen Erweiterungen davon für die Datenspeicherung und -verarbeitung.

Slides Picture
14:20 - 15:10 Divya Sharma, Diving into most common performance problems in PostgreSQL and how to fix them
Divya Sharma

Divya Sharma, Amazon Web Services

Diving into most common performance problems in PostgreSQL and how to fix them

This session will discuss most common problems customers face while working with PostgreSQL database in their production workloads. Example problems like "autovacuum not running", "bloated indexes", "replica queries getting cancelled", "bad performance immediately after version upgrade" ; this session will cover common problems like these and how to troubleshoot and fix them.

Target audience: General, Level: Intermediate

Divya Sharma is a Database Specialist SA with AWS, working majorly on PostgreSQL. She has helped several customers migrate to AWS RDS PostgreSQL and Aurora PostgreSQL from commercial database engines. Her day to day role also involves helping customers optimize their PostgreSQL workloads for better performance.

Slides Picture
Daniel Westermann, Escaping a public cloud using logical replication with minimal downtime
Daniel Westermann

Daniel Westermann, dbi services

Escaping a public cloud using logical replication with minimal downtime

This is the story of a real customer case: Because it was easy to setup, no real DBAs have been around and costs seemed to be fine, a managed PostgreSQL service in a public cloud was chosen to start the project with. A few years later the production database was at 8TB in size and costs increased significally every month. Exploring the options was one part of the project. Choosing the best of them came after and then troubles started because we hit all kinds of limitations of a public cloud. Logical replication finally was the solution, and this is what this talk is about.

Target audience: General, Level: Beginner

Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming “Technology Leader Open Infrastructure” and PostgreSQL expert. Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper & Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.

Slides
15:10 - 15:30 Break - Cafeteria in building 8
15:30 - 16:20 Andrea Minetti, Box Framework - Out of the Box web applications on top of PostgreSQL Database
Andrea Minetti

Andrea Minetti

Box Framework - Out of the Box web applications on top of PostgreSQL Database

Box is an open-source framework that aims to allow database administrators (DBA) to quickly create and customize complex web applications on top of PostgreSQL databases, minimizing development and management costs. It is conceived to leave most of the logic and the user access rights on the database side, where it also stores the application configuration and the structure of the forms and pages in a dedicated schema. It can therefore take advantage of PostgreSQL advanced features like Row Level Security, updatable views, triggers, functions, etc. Box reads the DDL and builds up a complete web application with standard forms for each table. It easily allows the creation of custom forms and views, combining prebuilt widgets for each field type and more specialized ones like maps to handle GIS data, file managers with embedded image handling, nested tables, and more. This project is the result of a fruitful collaboration between the Swiss federal institute of forest, snow and landscape research WSL (www.wsl.ch) and wavein.ch. It has originally been developed to allow environmental researchers with database skills to manage their own research data, rapidly build web applications on top of it, e.g. to directly perform relevés in the field, export data or plot graphs. It is now becoming more and more feature rich and is moving outside the academic world, finding application in many other fields. During the talk, I will explain the framework's main features, the strengths, and why you may be interested in it. Finally, we will demo how fast it is to bootstrap a simple web application on a PostgreSQL database.

Target audience: General, Level: Beginner

I'm an independent software consultant, 35 years old, from Ticino. Just after my studies, 10 years ago, I founded my company wavein.ch. I like functional programming and the actor model. In the last 7 years I've had the chance to work and study PostgreSQL, that has quickly become one of the topics that interests me the most.

Slides Picture
Patrick Stählin, Was ist MVCC und was sind die Auswirkungen davon?
Patrick Stählin

Patrick Stählin, Aiven

Was ist MVCC und was sind die Auswirkungen davon?

Normalerweise interessiert der Unterbau einer Datenbank niemanden. Die Applikationsentwickler schreiben Software, die DBAs beraten und planen die nächsten Ausbauschritte. Und wenn es dann Richtung Produktion geht, tauchen die Fehler auf, bei denen man sich gewünscht hätte, ein bisschen mehr von der Datenbank zu verstehen. Meist lohnt es sich nämlich zu wissen, wie die Datenbank im Kern funktioniert. Die Multiversion Concurrency Controll (MVCC) ist das Verfahren, mit der in der Transaktions-Logik die Sichtbarkeit von Tupel gesteuert wird. Dies möglichst ohne Locks und mit hoher Effizienz, ohne zu blockieren oder Abstriche bei der Konsistenz zu machen. Das Verfahren tauscht Speicherplatz gegen Effizienz indem es die veränderten Tupel mehrfach in verschiedenen Versionen ablegt. Der Vortrag erklärt wie MVCC funktioniert und was die Auswirkungen davon sind. Gerade im Hinblick auf Replikation, Backup und Wartung.

Target audience: General, Level: Beginner

Beschäftigt sich seit 2003 mit PostgreSQL, arbeite im PostgreSQL-Team von Aiven.

Slides Picture
16:30 - 17:20 Lætitia Avrot, Connecting to Postgres...
Lætitia Avrot

Lætitia Avrot, EDB

Connecting to Postgres...

Congratulation, you installed Postgres and created your cluster. Now it's time to connect to your database. It's not that complicated to connect locally, but why can't you connect from the outside? Why can't everyone connect to the database? What are the different flavours of authentications Postgres offers? What are the secured ways to connect to Postgres? Can you connect without a password to your database without damaging your security? Connecting to Postgres does not seem to be that complicated, but it can bring a lot of questions. This conf talk aims at explaining everything you can do to connect to Postgres, the authentication methods, the settings you will want and so on. It is a very beginner friendly talk, but I do hope everyone can learn new tricks from it.

Target audience: General, Level: Beginner

Lætitia Avrot is Field CTO for EDB in France. She begun working with PostgreSQL in 2007. She also had to learn Oracle and SQL Server at the same time. She had a lot of exciting experiences with high availability, production crashes, disaster recovery plan, load balancing, spatial data... She’s involved with the community as she was elected PostgreSQL Europe treasurer, she co-founded Postgres Women, and she's a recognized PostgreSQL project contributor.

Slides
Possibly you, Lightning Talks

Lightning Talks
Moderation:Vik Fearing

In this session, several people are given the opportunity to give a short presentation of a few minutes. These can be on any topic, including PostgreSQL, but excluding commercial advertising. We are happy to hear about new ideas, work in progress, calls for papers, or notices of upcoming changes.

If you would like to participate, please add your name to list at the registration desk. If you want to present slides, these need to be mailed as a PDF to info@pgday.ch before 15:30.

Slides
19:00 - Social-Event - Restaurant Rössli, Hurden
Friday, 30.06.2023
Time English Track - Room 3.008 German Track - Room 3.010
08:30 - 09:00 Registration / Coffee - Cafeteria in building 8
09:00 - 09:50 Keynote: Gianni Ciolli, pgchess on PostgreSQL 15 - Room 3.008
Gianni Ciolli

Gianni Ciolli, EDB

pgchess on PostgreSQL 15

The pgchess extension implements some concepts related to the game of chess, and can be used to turn PostgreSQL into a chess player. It comes with an user interface for psql that lets the user play against PostgreSQL. First, we will describe the work required to port pgchess from PostgreSQL 9.3 to 15, removing incompatibilities as well as using new features. Then we will show how to run pgchess, with a short demo. We use pgchess as an opportunity to learn lessons relevant to development of PostgreSQL applications, such as:

  • Version compatibility and maintaining software for the long term
  • Feature planning
  • New releases and upgrades
  • Regression testing
  • C language extensions
  • PGXS

Target audience: Developer, Level: Beginner

I am currently Vice President of Solutions Architecture at EDB, helping customers implement highly available distributed architectures. Before that, I worked at the University of Florence as a researcher in Mathematics. I have been using Free Software for more than 25 years. As a member of the Italian PostgreSQL User Group (ITPUG), I helped organising the first European PGDay in Prato, Italy (2008) and many editions of the the Italian PGDay. I am an author of several editions of the PostgreSQL Administration Cookbook.

Picture
10:00 - 10:50 Ryan Booz, We All Deserve Arrays: The Undervalued PostgreSQL Superpower
Ryan Booz

Ryan Booz, Redgate Software

We All Deserve Arrays: The Undervalued PostgreSQL Superpower

Arrays are an essential part of software development. Among modern databases, however, only PostgreSQL has dedicated datatypes, functions, and indexes built to efficiently work with arrays. In fact, I think arrays are a hidden superpower of PostgreSQL, fully utilized as a data type, usable in pl/pgSQL, and essential for a myriad of built-in functions to process data more efficiently. In this session I’ll discuss the array datatype in PostgreSQL along with things to consider before using it in a schema model. After laying the foundation for how arrays can be created, queried, and modified, I’ll demonstrate a handful of functions that can be used to process strings, JSON, numerics… and even Wordle emoji’s! The session will finish by demonstrating how using arrays in dynamic SQL can create more efficient multi-value inserts in some circumstances. By the end of this session, you will understand how arrays work in PostgreSQL and how powerful they can be as a datatype, logic variable, and in processing other data.

Target audience: General, Level: Beginner

Ryan is an Advocate at Redgate focusing on PostgreSQL. Ryan has been working as a PostgreSQL advocate, developer, DBA and product manager for more than 20 years, primarily working with time-series data on PostgreSQL and the Microsoft Data Platform. Ryan is a long-time DBA, starting with MySQL and Postgres in the late 90s. He spent more than 15 years working with SQL Server before returning to PostgreSQL full-time in 2018. He’s at the top of his game when he's learning something new about the data platform or teaching others about the technology he loves.

Slides Picture
Christoph Moench-Tegeder, Was hält uns auf?
Christoph Moench-Tegeder

Christoph Moench-Tegeder, Accenture

Was hält uns auf?

Warum ist die Query "manchmal" langsam? Warum fällt die Replikation zurück? Welche Operation braucht soviel CPU-Zeit? Was ist unser Bottleneck? Wir schauen uns an, wie moderne Betriebssysteme und dynamisches Tracing bei der Analyse von Performanceproblemen helfen können.

Target audience: DBA, Level: Beginner

Data Engineering Consultant im Bereich Cloud First bei Accenture, berät und untertützt bei allem PostgreSQL-Fragen, insbesondere Migrationen und Betriebsthemen.

Slides Picture
10:50 - 11:30 Break Picture & Poster presentation - Cafeteria in building 8

After the coffee break, you will find the authors next to their posters to discuss the topics illustrated.

11:30 - 12:20 Johannes Graën & Jonathan Schaber, A research infrastructure built on PostgreSQL
Johannes Graën Jonathan Schaber

Johannes Graën & Jonathan Schaber, University of Zurich

A research infrastructure built on PostgreSQL

The newly established Linguistic Research Infrastructure (LiRI) at the University of Zurich is a technology platform aiming at supporting research in linguistics and related disciplines Swiss-wide with state-of-the art methods and tools. As science in those fields has become more and more data-driven, insights are often gained from analyses of large collections of language data. Our weapon of choice for dealing with any kind of textual data and metadata is PostgreSQL. In this presentation, we show to what extent our requirements on a DBMS differ from typical OLTP or OLAP scenarios and how we employ different features such as partitions, range types, FTS and trigram indexes to facilitate the construction of linguistic queries. We compare our tool set with other existing solutions with respect to performance and flexibility and demonstrate different use cases, including a graphical frontend for conversation analysis of automatically annotated video recordings.

Target audience: General, Level: Intermediate

We are members of the Language Technology Group of said Linguistic Research Infrastructure, concerned with data structures in general and database-related questions in particular. For the tool we present here, schemata are defined dynamically depending on the respective structure and size of data.

Slides Picture
Kai Wagner, pg_stat_monitor: A feature-rich and enhanced version of pg_stat_statements
Kai Wagner

Kai Wagner, Percona

pg_stat_monitor: A feature-rich and enhanced version of pg_stat_statements

The pg_stat_monitor is the statistics collection tool based on PostgreSQL's contrib module pg_stat_statements. PostgreSQL's pg_stat_statements provides only detailed statistics from the last time it was reset, which is often not enough. This makes it harder to observe query performance patterns during specific times. Those patterns are what's needed when debugging degraded query and server performance. pg_stat_monitor collects and aggregates data on time window basis. Additionally, it differentiates between queries originating from different applications, clients and users. And I haven't even mentioned the queries execution timing histogram. These features make it especially useful in analyze query behavior generally and during specific time of a day. With plenty of configuration options, turning off actual query parameters, pg_stat_monitor covers observability from all different aspects without compromising on security. pg_stat_monitor is added to Percona Monitoring and Management to collect query metrics. It gives users the ability to see examples instead of fingerprints. Pg_stat_monitor provides more accurate data because of the bucket-based logic. The talk will cover the usage of pg_stat_monitor, its features, and how it can help to enhance your database inspection and monitoring.

Target audience: General, Level: Beginner

I'm Kai, and I work as a Sr. Engineering Manager for PostgreSQL at Percona. I'm passionate about open source, free speech, and transparent communication. Actively engaged and a public speaker for many open source projects such as ceph, openATTIC, Linux Kernel and now PostgreSQL. Whenever I'm not sitting in front of my computer, I either spend time with the family or work on our house.

Slides Picture
12:30 - 12:50 Closing: Stefan Keller (OST) - Room 3.008
Stefan Keller

Stefan Keller

Professor for information systems, founder and head of Geometa Labs. Keller is a member of the Swiss PGDay board and involved in various open source projects such as PostGIS and QGIS and open data initiatives, e.g. OpenStreetMap. Besides, he is generally interested in geographic data and their visualization as well as in the the integration of open source and proprietary solutions (e.g. QGIS and ArcGIS).

Professor für Informationssysteme sowie Leiter und Gründer des Geometa Labs. Ist u.a. Mitglied des Swiss PGDay OK und engagiert in verschiedenen Open Source Projekten (z.B. PostGIS und QGIS) und Open Data (v.a. OpenStreetMap). Zudem interessieren ihn allgemein Geodaten und Geovisualisierung sowie die Integration von Open Source und proprietärer Software (z.B. QGIS und ArcGIS).

Slides Picture

Swiss PGDay Sponsors 2023

Swiss PGDay wouldn't be possible without support from our generous sponsors. Thank you all very much!

Sponsors

Supporters

Partners

Interested in joining these companies in their support for the Swiss PGDay? See our sponsorship opportunities

Swiss PGDay Sponsoring 2023

The Swiss PGDay offers companies and organizations a unique annual opportunity to reach PostgreSQL professionals, community members and prospects from Switzerland and neighboring regions. If you are interested in sponsoring the conference, please send an email to info@pgday.ch

We offer the following levels of sponsorship with different benefits included:

Benefit Sponsor Supporter Partner
Logo with link on homepage*
Logo with link on sponsor page*
Short description text on sponsor page*
Logo on printed schedule posters
Logo shown in opening & closing presentation*
Sponsor mentioned in opening & closing session*
Banner/Rollup in catering area
Exhibition table for flyers/merchendise
Marketing flyers at the Jobboard
Access to conference box
Free ticket(s)
Fee 1'200 CHF
1/5 available
400 CHF n/a**

* The order of the logos depends on the level and the order of receipt of payment.
** Partners are non-profit organizations that are approached by the organizing committee to directly support the Swiss PGDay with services such as location or marketing.

Sponsors of any level do not obtain guaranteed presentations; the normal call-for-speakers process applies to their representatives, too.

To maintain the non-profit character of the event, the Swiss PGDay limits the number of sponsors to 5. The supporter level is not limited. Applications are processed on a first come, first served basis.

There are also "Community Supporter" tickets available, where individuals or business attendees can voluntarily pay a little more for the ticket to support the community conference and fund discounted student tickets.

The organizing committee of the Swiss PGDay reserves the right to adapt the conditions published here if necessary. The same conditions apply to all sponsors and supporters.

Location

The OST (Eastern Switzerland University of Applied Sciences, Campus Rapperswil) is located directly at the upper Zurich lakeshore with a view on the alpine foothills ( Map). A map of the campus with buildings and rooms can be found here. The registration is in the cafeteria in building Nr. 8. This is also the place where you can meet and get coffee during the day.

How to get there

The premises of the OST are right beside the train station of Rapperswil (southern exit, look for the signs). We recommend you therefore to use public transportation. It is possible, however, to reach the University by car.

Where to stay

If you are staying overnight and are looking for a hotel, there are several nearby accommodations in a variety of price ranges. Here are some suggestions:

Social event

On the evening of the first conference day (Thursday), we will host a community party for all Swiss PGDay participants. The event will take place at the Restaurant Rössli, a nice location within walking distance of the OST. Join us after the talks for a great opportunity to network and mingle with the PostgreSQL community. The dinner buffet and first drinks will be provided by Swiss PGDay. To simplify logistics, please wear your badge.
You can get there in 20-30 minutes by taking the beautiful long footbridge across the lake (Map), or by taking the S40 service and a short 5 minute walk.

Job board

Looking for people or a new job? There's a whiteboard near the registration desk where sponsors, companies and conference attendees can post potential job openings, resumes, company profiles and more. If you hang around during the breaks, you may be able to connect with each other. We ask our sponsors to have a presence there.

Ease of access

The campus is accessible for wheelchairs.

Code of conduct

During our event the PostgreSQL Project's Code of Conduct applies. Thank you for your help in making the Swiss PGDay 2023 fun and enjoyable for everyone!
Local points of contact: organizing committee info@pgday.ch, venue contact number: +41 58 257 47 46, Emergency services: 112.

Financial disclosure

The costs of Swiss PGDay are covered by the income from our sponsors and the registration fees. We try to keep the costs as low as possible for both parties and offer special rates for students to allow as many people as possible to attend. Our budget is calculated to break even. Operating losses and profits resulting from deviations from the budget will be managed by the Swiss PostgreSQL Users Group. Profits will be reinvested in the next year's Swiss PGDay.

Community event

Responsible for the Swiss PGDay is the Swiss PostgreSQL Users Group (SwissPUG). The event does comply with the PostgreSQL Community Conference Recognition guidelines and the use of the trademark "PGDay" is granted by PostgreSQL Europe.

Talk selection process

All submissions are looked at and considered by the program committee by reading abstracts, titles and submission notes. The program committee members each vote on every submission with a score of 1 through 9. We abstain from voting (i.e. vote NULL, not 0) on submissions by ourself or coworkers. We try hard not to have repeated speakers and to promote diversity.

Organization and program committee (alphabetic order)

Interested in helping with organization or as a member of the program committee for 2024? We aim to diversify our group. Please get in touch with us.
To contact the committee: pgday@swisspug.org

Past events

Swiss PGDay 2022
Swiss PGDay 2021
Swiss PGDay 2020
Swiss PGDay 2019
Swiss PGDay 2018
Swiss PGDay 2017 (German)
Swiss PGDay 2016 (German)

Background picture CC BY-SA 3.0 Roland zh (https://commons.wikimedia.org/wiki/User:Roland_zh). Thank you!


Poster

Postcard

Feedback is closed.