CERN Accelerating science

Other Talks

Najnovije dodano:
2025-01-20
14:41
Not yet available
From Queries to Pints: Building a Beer Recommendation System with pgvector / Nowicki, Andrzej (speaker) (CERN)
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 search with user preferences. Whether you’re a seasoned database administrator or just starting to explore the potential of AI, this presentation will equip you with practical insights and hands-on techniques to integrate machine learning into your database workflows. [...]
2025 - 2478. Visitor badges; CERN PGDay 2025 External links: Talk details; Event details In : CERN PGDay 2025

Detaljnije - Slični zapisi
2025-01-20
14:41
Not yet available
Harnessing Postgres and HPC for Petabyte-Scale Variable Star Classification in Astronomy / Nienartowicz, Krzysztof (speaker) (Sednai) ; Krefl, Daniel (speaker) (Sednai)
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. [...]
2025 - 3195. Visitor badges; CERN PGDay 2025 External links: Talk details; Event details In : CERN PGDay 2025

Detaljnije - Slični zapisi
2025-01-20
13:11
Not yet available
Anatomy of Table-Level Locks in PostgreSQL / Yildirim Jelinek, Gulcin (speaker)
**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. [...]
2025 - 2769. Visitor badges; CERN PGDay 2025 External links: Talk details; Event details In : CERN PGDay 2025

Detaljnije - Slični zapisi
2025-01-20
13:11
Not yet available
Maximising Microservice Databases with Kubernetes, Postgres, and CloudNativePG / Cecchi, Leonardo (speaker) ; Bartolini, Gabriele (speaker)
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 database environment. [...]
2025 - 3142. Visitor badges; CERN PGDay 2025 External links: Talk details; Event details In : CERN PGDay 2025

Detaljnije - Slični zapisi
2025-01-20
13:11
Not yet available
Closing / De Giorgi, Maurizio (speaker) (CERN) ; Bussmann, Tobias (speaker) (Swiss PostgreSQL Users Group)
Closing notes with sponsors review and special thanks
2025 - 684. Visitor badges; CERN PGDay 2025 External links: Talk details; Event details In : CERN PGDay 2025

Detaljnije - Slični zapisi
2025-01-20
11:01
Not yet available
Architecture for Seamless PostgreSQL Upgrades / Obernesser, Adrien (speaker) (dbi services)
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. [...]
2025 - 2686. Visitor badges; CERN PGDay 2025 External links: Talk details; Event details In : CERN PGDay 2025

Detaljnije - Slični zapisi
2025-01-20
11:01
Not yet available
Optimizing time series data storage for CERN industrial control systems using TimescaleDB and PostgreSQL / Zemko, Martin (speaker) (CERN) ; Kveton, Antonin (speaker) (CERN) ; Kulaga, Rafal (speaker) (CERN)
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. [...]
2025 - 2731. Visitor badges; CERN PGDay 2025 External links: Talk details; Event details In : CERN PGDay 2025

Detaljnije - Slični zapisi
2025-01-17
16:23
Not yet available
CERN introductory keynote: The role of PostgreSQL at CERN / Potocky, Miroslav (speaker) (CERN)
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. [...]
2025 - 1120. Visitor badges; CERN PGDay 2025 External links: Talk details; Event details In : CERN PGDay 2025

Detaljnije - Slični zapisi
2025-01-17
15:46
Not yet available
Opening / De Giorgi, Maurizio (speaker) (CERN) ; Bussmann, Tobias (speaker) (Swiss PostgreSQL Users Group)
Welcome from the organizing team, logistics info and notices, sponsors presentation and special thanks
2025 - 437. Visitor badges; CERN PGDay 2025 External links: Talk details; Event details In : CERN PGDay 2025

Detaljnije - Slični zapisi
2025-01-16
11:11
Not yet available
AI companion training by Zoom
An online training session, organized by Zoom, will be held for CERN users on 14 January at 15:00 (duration: 45 minutes)  to introduce this functionality [1]. Attendance is strongly recommended. -- [1] https://videoconference.docs.cern.ch/AI-companion/
2025 - 1623. Videoconference External link: Event details In : AI companion training by Zoom

Detaljnije - Slični zapisi