Enhancing OLTP Systems with pgvector: Best Practices in Database Design
Presented by:
Shayon Sanyal
Shayon Sanyal is a Principal PostgreSQL Specialist Solutions Architect and a Subject Matter Expert for Amazon’s flagship relational database, Amazon Aurora. He brings over 15 years of experience managing relational databases and analytics workloads utilizing PostgreSQL.
Shayon enjoys building robust applications using PostgreSQL, taking advantage of its many features, from complex data types to its ability to stream logical changes. Shayon graduated from Carnegie Mellon University with a M.S. in Information Systems Management.
Sundar Raghavan
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