Welcome from the organizing team, logistics info and notices, sponsors presentation and special thanks
CERN, the European Organization for Nuclear Research, is at the forefront of scientific exploration, uncovering the fundamental nature of the universe. With groundbreaking experiments from worl-wide collaborations conducted at the Large Hadron Collider (LHC), the world’s largest and most powerful particle accelerator. The LHC hosts four main experiments: ATLAS and CMS, which investigate the...
CERN is known for producing, processing, and storing vast amounts of data, most of which consists of physics-related information — snapshots of particle collisions recorded by detectors in experiments. Large Detector Control Systems at CERN enable the controlled operation of complex research equipment and generate "conditions" data. This data describes the time evolution of parameters such as...
Upgrading from PostgreSQL 11 to 16 can be an easy process, such as a dump restore, but when instance numbers and sizes increase, this can push organizations to maintain older PostgreSQL versions longer than expected. Avoiding technological debt is crucial for maintaining a robust and scalable database architecture. This session will present a real-world scenario on how to design an...
Short abstract
Understanding table-level locks in Postgres is a quite useful skill as almost all DDL operations require acquiring one of the different types of table-level locks on the object being manipulated. If not managed well, schema changes can result in downtime. In this talk we will explain fundamentals of table-level locking, covering how different types of locks are applied and...
As a developer, you may follow continuous delivery practices yet treat your database as an external component, introducing risks with changes and migrations. It's time to change that by embracing microservice databases within your organisation.
This talk explores how PostgreSQL and Kubernetes, through CloudNativePG, can help you establish a seamless, open-source, vendor-neutral microservice...
In this talk, we will showcase our use of a Massively Parallel Postgres Database as a petabyte-scale astronomical datastore, powering variable star analysis for the ESA Gaia space telescope. Our presentation will also highlight two Postgres extensions developed in-house: a new Postgres-to-Java interface and a GPU-accelerated vector index. Both extensions are implemented as Postgres background...
Discover how easily you can create a recommendation system from scratch using modern AI and database technologies.
In this session, we’ll build a beer recommendation system using advanced language models and PostgreSQL’s pgvector extension. By leveraging the capabilities of pgvector, we can seamlessly store high-dimensional embeddings generated from beer descriptions and perform similarity...
Closing notes with sponsors review and special thanks
No, not under the table - for things within a table, like columns and rows. Fine grained access controls let administrators manage access to specific pieces of data. Granting a user permission to read a piece of data doesn't have to mean access to all the details either, values can be masked, rounded, classified into buckets, ... As regulation makes data privacy controls more important and the...
