~/talk

Cheeses, vectors and PostgreSQL

TalkinFrenchat PG Day France 2024 · 2024-06-11..06-12· [databases]
links:none on file
slides:none on file

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 Hugging Face / OpenAI / Vertex. It stores embeddings in PostgreSQL with the pgvector extension and runs nearest-neighbor vector queries to return the three cheeses most similar to Saint-Nectaire; for comparison, a keyword LIKE filter returns 17 hits while vector similarity yields a ranked top‑3 that match real-life resemblance.

AI-written summary · about

~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.