PG Day France 2024
| title | author | length |
|---|---|---|
| Cheeses, vectors and PostgreSQL | Matthieu CORNILLON | 05m |
A demo uses a cheese.com dataset (id, name, origin, texture, description) and adds a vector column of embeddings (dimension chosen at model time) created with… | ||
| PostgreSQL Meetup Lille: Lessons Learned | Florent Jardin | 37m |
PostgreSQL Lille describes a concrete meetup playbook: they got official PUG recognition, run regular events with two talks per meetup and have had 18 unique… | ||
| Sharding Without the Complexity | Cédric Villemain | 31m |
Citus is a PostgreSQL extension that shards tables using a coordinator-and-workers architecture with a default of 64 shards per table. It installs at the… | ||
| PostGIS & the Hard Rock Café collection | Julien Riou | 05m |
Builds a CSV catalog of about 20 Hard Rock Café T-shirts and retrieves global shop coordinates from OpenStreetMap (Nominatim/Overpass) and the official site… | ||
| Mastering Large-Scale PostgreSQL Migration | Julien Acroute | 26m |
A company migrates PostGIS from 2.4 to 3.2 and PostgreSQL from 10 to 14 across many large clusters (up to 6 TB each) holding high-volume vehicle geodata. The… | ||
| Diversity Within the Postgres Community | Carole ARNAUD | 05m |
A career narrative follows a path from ZEP schooling through prépa and engineering studies to a PhD and DBA management to show how gender and social diversity… | ||
| Postgres: stories that will scare you | Jérémie Grauer | 42m |
A Postgres operations team that runs about 10–15k instances describes real failure cases and their causes: a FreeBSD replica using a C collation that corrupts… | ||
| Developing a Postgres Extension in Rust | Damien Clochard | 39m |
A ~1000-line PostgreSQL C extension was rewritten in Rust using the pgrx framework and cargo-pgrx tooling; builds and runs use cargo pgrx run and unit tests… | ||
| Demystifying Incremental Backups in the PostgreSQL Ecosystem | Stefan Fercot | 41m |
Postgres 17 adds a WAL summarizer that writes small pg_wal_summaries at each checkpoint so tools can quickly list changed blocks. The incremental backup… | ||
| H3 Indexing | Julien WADDLE | 23m |
Adds the H3 geospatial index to PostgreSQL/PostGIS, shows loading OpenStreetMap data using osm2pgsql inside Docker, and explains H3 internals: 64-bit indexes… | ||
| nothing matches | ||