Yours

Learn · CERN

Talk54 min

Harnessing Postgres and HPC for Petabyte-Scale Variable Star Classification in Astronomy

Krzysztof Nienartowicz and Daniel Krefl · CERN

Watch At CERN

About

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 workers and improve on existing solutions in the HPC context..

0:00:00 Slide 1

0:02:21 Slide 2

0:03:31 Slide 3

0:05:05 Slide 4

0:07:27 Slide 5

0:08:53 Slide 6

0:10:41 Slide 7

0:13:35 Slide 8

0:14:53 Slide 9

0:16:57 Slide 10

0:18:48 Slide 11

The talk

  1. Harnessing Postgres and HPC for Petabyte-Scale Variable Star Classification in Astronomy 2025-01-17 · 54 min · CERN's player

Credits and licence

Institution
CERN
Department
Visitor badges
Taught by
Krzysztof Nienartowicz, Daniel Krefl
Year
2025
Language
English
Subjects
Astronomy and space
Source
CERN
Licence
CERN, as CERN states it. CERN's terms
Attribution
© CERN. CERN provides its audiovisual media free of charge for educational and informational use, credited to CERN; this lecture is shown in CERN's own player.
Who can watch
CERN gives no rating. Invisible Network shows it to Tweens profiles and older, judged from what the source says about it. How courses are placed