Presented by:

Shayon is a database architect specializing in PostgreSQL and AI/ML applications. With extensive experience helping enterprises implement vector search, agentic AI systems, and hybrid search architectures, he focuses on practical patterns that work at production scale. A regular speaker at database conferences, Shayon is passionate about making PostgreSQL's advanced capabilities accessible to the broader community.

Sundar Raghavan

Amazon Web Services

Sundar Raghavan leads a team of Database Specialist Solutions Architect at Amazon Web Services (AWS). He and his team works with customers across multiple industries who work with RDBMS such as Oracle, PostgreSQL, and migrations from Oracle to PostgreSQL on AWS. Previously, Sundar served as a database and data platform architect at Oracle, Cloudera/Horton Works. He enjoys reading, watching movies, playing chess and being outside when he is not working.

No video of the event yet, sorry!

The integration of pgvector into existing Online Transaction Processing (OLTP) systems represents a significant advancement in leveraging vector search capabilities within traditional database environments. This presentation is designed to educate database professionals on the thoughtful integration of pgvector into OLTP applications powered by PostgreSQL, ensuring enhanced functionalities without compromising the core transactional integrity and performance. We will begin with an introduction to pgvector, highlighting its significance and utility in bringing vector search capabilities to PostgreSQL databases. The session will provide a foundational understanding of vector data, its applications, and how pgvector facilitates these advanced search capabilities seamlessly within PostgreSQL.

Key focus areas will include:

  • Database design considerations for combining relational and vector data types
  • Performance optimization strategies like indexing, query optimization, and balancing the load between transactional operations and vector search queries
  • Operational best practices like backups, replication and monitoring
  • Real-world use cases showing applications in recommendations, similarity searches and AI chatbots
  • Best practices for safe integration testing, deployment and rollback procedures

Attendees will learn how to adopt pgvector to unlock new application features while maintaining reliability, performance and scalability of their PostgreSQL databases. The presentation provides a roadmap for practical pgvector integration regardless of hosting environment.

Date:
2024 April 18 12:10 PDT
Duration:
50 min
Room:
Winchester
Conference:
Postgres Conference 2024
Language:
English
Track:
Dev
Difficulty:
Intermediate