Name: Vectors: Best Practices for a Nasty Data Type
Start: 2025-07-14T18:00:00-04:00
End: 2025-07-14T20:00:00-04:00
Location: 7 W 34th St, New York, NY 10001

We're excited to host the July 2025 NYC PostgreSQL User Group Meetup on July 14, 2025!

Agenda:
6p - 6:30p: Food & Networking
6:30p - 7:30p: Talk: Vectors: Best Practices for a Nasty Data Type

**Talk:** Vectors: Best Practices for a Nasty Data Type

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.

**About the 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.

Jonathan Katz

Miaolai Zhou

Chirag Dave

NYC Postgres

Technology

PostgreSQL

Open Source

Data Management

Database Development

Database Professionals

Geospatial

Data Analytics

Big Data

Python

JavaScript

NoSQL

Web Development

MySQL

Oracle

Vectors: Best Practices for a Nasty Data Type

AI Algorithms

7 W 34th St, New York, NY 10001

Share

NYC Postgres

Vectors: Best Practices for a Nasty Data Type

NYC Postgres

Details

Members are also interested in