PostgreSQL – The Swiss Army Knife for Data Analytics
PostgreSQL is a powerful open-source database management system (DBMS) known for standards compliance and efficient handling of large-scale datasets. Beyond its core strengths, it offers exceptional support for diverse data types and extensibility.
In this hands-on workshop, we’ll begin with an overview of PostgreSQL’s core capabilities for data modeling and analytical querying. Then, we’ll dive deeper into some of the more advanced and lesser-known features that make PostgreSQL a robust platform for modern data analytics.
This workshop will provide an overview of both foundational and advanced analytics capabilities in PostgreSQL, including:
- Advanced Aggregation Techniques – Explore PostgreSQL’s capabilities for flexible grouping, conditional aggregation, and analyzing patterns across subsets of data to support complex analytical workflows.
- Graph Queries and Hierarchical Data with Nested Sets – Learn how to represent and query trees and graph structures using standard SQL.
- Full-Text Search – Harness PostgreSQL’s built-in text search capabilities for powerful, language-aware queries built on efficient indices.
- Vectors and Indexing for Machine Learning – Work with PostgreSQL’s vector data types and indexing methods for AI/ML workflows.
Johannes Graën has over 20 years of experience working with PostgreSQL, spanning both commercial and scientific applications. He has designed and implemented complex systems built around PostgreSQL databases and has worked extensively as a developer and part-time database administrator. He has also shared his knowledge at various PostgreSQL conferences.
Johannes holds a PhD in Computational Linguistics from the University of Zurich, where he currently supports researchers with technical solutions — many of them involving PostgreSQL.
Tobias Bussmann came into contact with PostgreSQL in the early 2000s and became an enthusiast the more he has been involved with the product and the community since then.
Tobias is inaugural member and current treasurer of the Swiss PostgreSQL Users Group and part of the organization committee of the annual Swiss PGDay and CERN PGDay. He is co-maintainer of PostgresApp, an official PostgreSQL distribution for macOS.
You will likely have a chance to meet him at various community events and conferences. For a living, he is working as a Software Engineer at the Swiss Academy of Sciences in Bern, Switzerland, where he lives.