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

- Institution: CERN
- Department: Visitor badges
- Taught by: Krzysztof Nienartowicz, Daniel Krefl
- Year: 2025
- Language: English
- Subjects: Astronomy and space
- Source: [CERN](https://videos.cern.ch/record/3022757)
- Licence: [CERN](http://copyright.web.cern.ch)
- Who can watch: Tweens profiles and older (sources give no ratings; placed by Invisible Network from the source's own words)

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

0:20:43 Slide 12

0:23:17 Slide 13

0:25:17 Slide 14

0:30:45 Slide 15

0:32:30 Slide 16

0:33:42 Slide 17

0:42:35 Slide 18

0:43:42 Slide 19

0:47:20 Slide 20

0:48:49 Slide 21

0:50:29 Slide 22

## Lectures

1. [Harnessing Postgres and HPC for Petabyte-Scale Variable Star Classification in Astronomy](https://invisiblenetwork.ai/learn/cern/3022757/2a02e075dbe0), 54 min (CERN's player)