Upcoming presentations
No upcoming presentations...
Past presentations
pgvector Newbie to Expert
A session to learn the fundamentals of pgvector
In recent years, vector search has emerged as a key tool for handling high-dimensional data, enabling applications like recommendation systems, semantic search, and AI-driven insights. pgvector is an extension for PostgreSQL that brings powerful vector search capabilities directly into the database, allowing you to store and query vector data alongside your traditional relational data.
This ...
Unleashing Query Performance: Parallel Processing in PostgreSQL
Evolution of parallel processing in PostgreSQL
In the era of big data and data-driven decision-making, the ability to process large volumes of data efficiently has become a critical requirement for modern applications. Parallel query processing in PostgreSQL allows queries to leverage multiple CPU cores concurrently, significantly enhancing query performance and reducing execution times. This parallel execution paradigm is particularly valu...
Understanding Database Statistics in Postgres
Unlocking Insights for Performance Optimization
Extract: Understanding Database Statistics in PostgreSQL Understanding Database Statistics in Postgres Session Description Database statistics play a crucial role in optimizing query performance and overall database health in Postgres. This session will provide an in-depth look at the different types of database statistics maintained by Postgres, how they are collected and used by the qu...
Designing Scalable Multi-Tenant Architectures with PostgreSQL for SaaS Solutions
Multi-tenancy with PostgreSQL databases
Tenant isolation, resource sharing, security, and performance are critical in designing multi-tenant database architectures. SaaS providers leverage these architectures to consolidate databases, enhancing agility, scalability, operational efficiency, and cost optimization. In this session, we will explore multi-tenancy partitioning models, cost optimization strategies, high availability, disast...