At EDB, we are proud to be part of the vibrant and ever-evolving PostgreSQL community. As champions of open-source innovation and leaders in PostgreSQL development, we are committed to building Postgres for the AI generation to support the workloads of the future.
This year at Prague PostgreSQL Developer Day we have four members of the EDB team sharing their knowledge and expertise with the Postgres community. These sessions underscore the cutting-edge work our team is contributing to PostgreSQL, and our commitment to building Postgres alongside the open source community.
Here’s a preview of the insights our experts will be sharing at the conference:
Incremental Backup
Speaker: Robert Haas, EDB VP, Chief Architect, Database Servers
The release of PostgreSQL 17 introduced a game-changing feature: Incremental Backup, developed by EDB VP and Chief Database Scientist Robert Haas. In his talk, Robert will delve into the technical details of this feature, exploring how incremental backups identify changes since the last backup and why this approach was chosen.
Key highlights include:
- Integration into Core PostgreSQL: This feature eliminates the need for external tools, offering a standardized and seamless backup process.
- Efficiency and Reliability: By capturing only incremental changes, this approach significantly reduces backup time and storage requirements.
- Future-Proofing PostgreSQL: This development positions PostgreSQL as a competitive alternative to proprietary solutions offered by major cloud providers.
Attendees will gain a valuable understanding of how this feature enhances PostgreSQL’s functionality and user experience. Read more about why PostgreSQL 17's Incremental Backup feature is a game-changer in our recent blog.
Postgres & AI: From the Trenches to the Sky
Speaker: Bruce Momjian, EDB VP and PostgreSQL Evangelist
Artificial intelligence is revolutionizing industries, and PostgreSQL is no exception. Bruce Momjian’s talk will explore the intersection of AI and PostgreSQL, demonstrating how machine learning tasks can be integrated directly into the database. From defining AI and machine learning to showcasing practical implementations, Bruce will cover:
The efficiency of in-database machine learning, minimizing data movement while leveraging PostgreSQL’s robust infrastructure.
Tasks well-suited for in-database AI, including fraud detection, recommendation systems, and real-time analytics.
Advantages such as seamless access to data, transactional consistency, and potential GPU-based computations within PostgreSQL.
Bruce’s presentation will reveal key insights into how PostgreSQL can play a pivotal role in the AI-driven future.
Integrating AI with Postgres: Opportunities, Challenges, and Future Possibilities
Speaker: Bilge Ince, EDB Machine Learning Engineer
As the pace of digital transformation continues to accelerate, AI has quickly become a cornerstone of modern technology. EDB Machine Learning Engineer Bilge Ince’s session will explore how PostgreSQL is evolving to meet the demands of the AI generation. From the aidb extension to pgvector, she will highlight how these tools transform PostgreSQL into an intelligent data system.
Attendees can look forward to:
- An exploration of hot AI topics like vectors, semantic search, LLMs, and multimodal systems.
- Practical insights into leveraging AI within PostgreSQL to unlock new business opportunities.
- A look at future directions, where AI and PostgreSQL converge to drive innovation.
Bilge’s expertise offers a roadmap for organizations looking to harness the power of AI within their PostgreSQL environments. Learn more about the expanding world of AI and Postgres in our recent blog and webinar with Bilge.
What is an SLRU Anyway?
Speaker: Álvaro Herrera, EDB Principal Database Engineer
An SLRU is a mechanism used by PostgreSQL to store metadata about transaction IDs, and a dozen other things that behave like them. In large systems, some SLRUs were points of contention under high load -- that is, they slowed PostgreSQL down to a crawl when people most need it to be fast. Many customers had trouble using Postgres because of such slowness, so we collaborated to find ways to eliminate the contention.
In his talk, Álvaro Herrera will:
Explain the role of SLRUs in PostgreSQL and what SLRUs store
Help people understand how to monitor the SLRU activity
Provide practical guidance how to configure the parameters that were added
Álvaro’s deep dive into SLRUs underscores the attention to detail and performance optimization that define PostgreSQL’s continuous improvement.
Shaping the Future of Postgres
At EDB, we are proud to be leaders, innovators, and collaborators in the Postgres community, and we are committed to sharing pour Postgres knowledge and expertise at open source events around the world. We value these opportunities for our experts to share their knowledge and contribute to the collective advancement of PostgreSQL. From incremental backups and in-database AI to performance optimizations, we’re pushing the boundaries of what PostgreSQL can achieve.