Seattle Postgres: Vectors - Best practices for a nasty data type

Thu Apr 10 2025 at 06:00 pm to 08:00 pm UTC-07:00

Steam Plant - Fred Hutch Cancer Center | Seattle

Seattle Postgres User Group
Publisher/HostSeattle Postgres User Group
Seattle Postgres: Vectors - Best practices for a nasty data type
Advertisement
Jonathan Katz speaking on Postgres capabilities around vectors, strengths & weaknesses, and where Postgres is effective in RAG-driven apps
About this Event

Founded in 2010, the Seattle PostgreSQL Users Group (SEAPUG) gets together in person and we talk about technology and databases - especially our favorite database, Postgres! Nothing is too simple or too complicated. Come meet the people... from the newbie to expert - whether your job directly involves databases or not - all have a good time talking shop about technology over some food and drinks.

Seattle Postgres: Vectors - Best practices for a nasty data type

Date: Thursday April 10

Time: 6 pm

Location: Steam Plant - Fred Hutch Cancer Center

Vectors are a centuries old, well-studied mathematical concept, yet they pose many challenges around efficient storage and retrieval in database systems. Applications requiring effective search techniques for vectors have advanced, with "retrieval-augmented generation" (RAG) becoming a key building technique. An extensible database like PostgreSQL can add vector search through an extension like pgvector.

In this talk, we'll review what vectors are, how they are used in applications, and what users are looking for in vector storage and search systems. We'll then see how you can search for vector data in PostgreSQL, including looking at best practices for using pgvector by taking a deeper look at how pgvector implements different vector search techniques. We'll also see where traditional databases methods are most effective for building RAG-driven apps.

At the end of this talk, you'll have a set of best practices you can use when designing applications that require vector search.

Pizza is provided, and we also have a user group lending library of books & papers related to PostgreSQL and Databases.

NEW LOCATION: same place as the summer BBQ - the Fred Hutch Steam Plant building. (Entrance on Eastlake Ave) Typically it's not hard to find street parking nearby.



Speaker

Jonathan Katz is a Principal Product Manager - Technical on the Amazon Redshift team and is based in New York. He's on the Core Team of PostgreSQL and is an active open source contributor, including to pgvector.


https://www.meetup.com/seattle-postgres/events/306579613

Advertisement

Event Venue & Nearby Stays

Steam Plant - Fred Hutch Cancer Center, 1241 Eastlake Avenue East, Seattle, United States

Tickets

USD 0.00

Discover more events by tags:

Meetups in SeattleIt in Seattle

Sharing is Caring:

More Events in Seattle

April Artwalk!
Thu, 10 Apr, 2025 at 05:00 pm April Artwalk!

6030 California Ave SW, 98116

Paper Architecture: Michael Bierut & Jonny Sikov
Thu, 10 Apr, 2025 at 05:30 pm Paper Architecture: Michael Bierut & Jonny Sikov

Seattle Public Library-Central Library

VABAW Mentorship Mixer Hosted by Stoel Rives
Thu, 10 Apr, 2025 at 05:30 pm VABAW Mentorship Mixer Hosted by Stoel Rives

Stoel Rives LLP

SDF '25 Spring Mixer#1
Thu, 10 Apr, 2025 at 05:30 pm SDF '25 Spring Mixer#1

citizenM Seattle South Lake Union hotel

Footprint Wines POP UP
Thu, 10 Apr, 2025 at 05:30 pm Footprint Wines POP UP

WeRise Wine Bar

Craft Cocktail - Polymer Clay Accessories
Thu, 10 Apr, 2025 at 06:30 pm Craft Cocktail - Polymer Clay Accessories

StudioLife : Creating Space

Alyssa Edwards - Crowned - North America Tour 2025
Thu, 10 Apr, 2025 at 07:00 pm Alyssa Edwards - Crowned - North America Tour 2025

Moore Theatre

Chrism Mass
Thu, 10 Apr, 2025 at 07:00 pm Chrism Mass

St. James Cathedral, Seattle

Bestial Mouths at Substation Seattle
Thu, 10 Apr, 2025 at 07:00 pm Bestial Mouths at Substation Seattle

Substation Seattle

Devours w. Total Chroma & VOIDWRMR
Thu, 10 Apr, 2025 at 07:00 pm Devours w. Total Chroma & VOIDWRMR

Bad Bar

Peggy Dean presents 'Pacific Northwest Line Drawing'
Thu, 10 Apr, 2025 at 07:00 pm Peggy Dean presents 'Pacific Northwest Line Drawing'

Third Place Books

Seattle is Happening!

Never miss your favorite happenings again!

Explore Seattle Events