{"guid":"2cb9646a-486c-5504-b46e-564f6ee7c98b","title":"Volltextsuche in Echtzeitdaten mit pg_search","subtitle":null,"slug":"fossgis2026-84143-volltextsuche-in-echtzeitdaten-mit-pgsearch","link":"https://pretalx.com/fossgis2026/talk/HFELXJ/","description":"pg_search ist eine neue PostgreSQL-Erweiterung für die Volltextsuche mit dem BM25 Algorithmus. Damit können gleichwertige Ergebnisse wie mit externen Suchmaschinen (Elasticsearch, Solr) erreicht werden.\nDank der automatischen Aktualisierung des Suchindexes ermöglicht pg_search den sofortigen Einbezug von neuen oder aktualisierten Daten.\n\nBM25 oder Best Match 25 ist ein Ranking-Algorithmus für die Ähnlichkeitsbewertung (Relevanz) von Suchanfragen in Textdaten.\nDie Ergebnisse werden auch mit etablierten PostgreSQL-Erweiterungen für die Volltextsuche wie pg_trgm verglichen.\n\nURL: https://github.com/paradedb/paradedb/tree/main/pg_search\n\nBM25:\n    - https://www.luigisbox.de/suchglossar/bm25/\n    - https://en.wikipedia.org/wiki/Okapi_BM25\n\nLicensed to the public under https://creativecommons.org/licenses/by/4.0/","original_language":"deu","persons":["Marco Hugentobler"],"tags":["HFELXJ","2026","fossgis2026","Daten, Datenbanken und Datenprozessierung","HS3 (ZHG 009)","fossgis2026-deu","Day 2"],"view_count":85,"promoted":false,"date":"2026-03-25T16:30:00.000+01:00","release_date":"2026-03-25T00:00:00.000+01:00","updated_at":"2026-04-08T14:30:06.748+02:00","length":1386,"duration":1386,"thumb_url":"https://static.media.ccc.de/media/events/fossgis/2026/84143-2cb9646a-486c-5504-b46e-564f6ee7c98b.jpg","poster_url":"https://static.media.ccc.de/media/events/fossgis/2026/84143-2cb9646a-486c-5504-b46e-564f6ee7c98b_preview.jpg","timeline_url":"https://static.media.ccc.de/media/events/fossgis/2026/84143-2cb9646a-486c-5504-b46e-564f6ee7c98b.timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/events/fossgis/2026/84143-2cb9646a-486c-5504-b46e-564f6ee7c98b.thumbnails.vtt","frontend_link":"https://media.ccc.de/v/fossgis2026-84143-volltextsuche-in-echtzeitdaten-mit-pgsearch","url":"https://api.media.ccc.de/public/events/2cb9646a-486c-5504-b46e-564f6ee7c98b","conference_title":"FOSSGIS 2026","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2026","related":[],"recordings":[{"size":145,"length":1386,"mime_type":"video/webm;codecs=av01","language":"deu","filename":"fossgis2026-84143-deu-Volltextsuche_in_Echtzeitdaten_mit_pg_search_av1-hd.webm","state":"new","folder":"av1-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2026-03-25T18:46:05.054+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2026/av1-hd/fossgis2026-84143-deu-Volltextsuche_in_Echtzeitdaten_mit_pg_search_av1-hd.webm","url":"https://api.media.ccc.de/public/recordings/96739","event_url":"https://api.media.ccc.de/public/events/2cb9646a-486c-5504-b46e-564f6ee7c98b","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2026"},{"size":163,"length":1386,"mime_type":"video/webm","language":"deu","filename":"fossgis2026-84143-deu-Volltextsuche_in_Echtzeitdaten_mit_pg_search_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2026-03-25T18:52:21.399+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2026/webm-hd/fossgis2026-84143-deu-Volltextsuche_in_Echtzeitdaten_mit_pg_search_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/96741","event_url":"https://api.media.ccc.de/public/events/2cb9646a-486c-5504-b46e-564f6ee7c98b","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2026"},{"size":56,"length":1386,"mime_type":"video/webm","language":"deu","filename":"fossgis2026-84143-deu-Volltextsuche_in_Echtzeitdaten_mit_pg_search_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2026-03-25T18:40:19.575+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2026/webm-sd/fossgis2026-84143-deu-Volltextsuche_in_Echtzeitdaten_mit_pg_search_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/96738","event_url":"https://api.media.ccc.de/public/events/2cb9646a-486c-5504-b46e-564f6ee7c98b","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2026"},{"size":53,"length":1386,"mime_type":"video/mp4","language":"deu","filename":"fossgis2026-84143-deu-Volltextsuche_in_Echtzeitdaten_mit_pg_search_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2026-03-25T18:26:12.778+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2026/h264-sd/fossgis2026-84143-deu-Volltextsuche_in_Echtzeitdaten_mit_pg_search_sd.mp4","url":"https://api.media.ccc.de/public/recordings/96721","event_url":"https://api.media.ccc.de/public/events/2cb9646a-486c-5504-b46e-564f6ee7c98b","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2026"},{"size":21,"length":1386,"mime_type":"audio/mpeg","language":"deu","filename":"fossgis2026-84143-deu-Volltextsuche_in_Echtzeitdaten_mit_pg_search_mp3.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2026-03-25T18:23:34.228+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2026/mp3/fossgis2026-84143-deu-Volltextsuche_in_Echtzeitdaten_mit_pg_search_mp3.mp3","url":"https://api.media.ccc.de/public/recordings/96719","event_url":"https://api.media.ccc.de/public/events/2cb9646a-486c-5504-b46e-564f6ee7c98b","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2026"},{"size":13,"length":1386,"mime_type":"audio/opus","language":"deu","filename":"fossgis2026-84143-deu-Volltextsuche_in_Echtzeitdaten_mit_pg_search_opus.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2026-03-25T18:23:30.553+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2026/opus/fossgis2026-84143-deu-Volltextsuche_in_Echtzeitdaten_mit_pg_search_opus.opus","url":"https://api.media.ccc.de/public/recordings/96718","event_url":"https://api.media.ccc.de/public/events/2cb9646a-486c-5504-b46e-564f6ee7c98b","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2026"},{"size":175,"length":1386,"mime_type":"video/mp4","language":"deu","filename":"fossgis2026-84143-deu-Volltextsuche_in_Echtzeitdaten_mit_pg_search_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2026-03-25T18:23:18.810+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2026/h264-hd/fossgis2026-84143-deu-Volltextsuche_in_Echtzeitdaten_mit_pg_search_hd.mp4","url":"https://api.media.ccc.de/public/recordings/96717","event_url":"https://api.media.ccc.de/public/events/2cb9646a-486c-5504-b46e-564f6ee7c98b","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2026"}]}