Postgres Conference 2024 Program

2024-04-17
09:00
Zak Tedder Conference Launch + Keynote
Synergy: Teamwork Makes the Dream Work

presented by Zak Tedder

Communication in the Tech world can be brutal. People are busy and things need to get done. All the tasks and moving parts can make it difficult to see the end goal or how it all comes together. This can also foster a very competitive environment, where Pug-eat-Pug and the last Frenchy standing wins the prize. However, there is a much faster and solid route to the goal: synergy. When all of the...

more

09:00 - 09:30 Almaden Essentials
09:40
Montana Low Why We Put GPUs in the Database
Navigating the Confluence of Hardware Evolution and Machine Learning Technology

presented by Montana Low

The intersection of hardware advancements and machine learning (ML) innovations has deep implications for databases. The integration of GPUs into Postgres is a response to the growing demand for real-time, sophisticated data processing, enabling advanced analytics, machine learning model training, and inference with increasing tight latency constraints against increasingly large scale data. In ...

more

09:40 - 10:00 Almaden Ops
10:10
Frank McSherry Enabling New Operational Use Cases with PostgreSQL

presented by Frank McSherry

As the world moves towards lower latency in operational workloads, a new opportunity is emerging for database architects to ask which query processing work in their database should be performed proactively, as data change, and which work should be performed reactively, as queries roll in. Naturally, to do this you will need a tool that integrates seamlessly with PostgreSQL and maintains your qu...

more

10:10 - 10:30 Almaden Essentials
10:40
Jignesh Shah Innovating for all with PostgreSQL at AWS

presented by Jignesh Shah

Developers love open source databases because they help enable innovation, collaboration, and the creation of technologies that solve today’s and tomorrow’s problems. As we at AWS have ramped up our collaboration with open source communities, like PostgreSQL, we have seen how open source innovations improve the experience of our customers and the broader community. This keynote highlights how A...

more

10:40 - 11:00 Almaden
11:10
Jignesh Shah Managing at scale Postgres version upgrades with minimum downtime

presented by Jignesh Shah

Postgres major version upgrades require planning. In this topic we look under the hood on how PostgreSQL major version upgrades can be upgraded with minimum downtime and then go over the operational best practices of doing these upgrades at scale with 100s to 1000s of databases.

11:10 - 11:30 San Pedro Ops
Peter Zaitsev Cloud-native Postgres observability: from client apps to underlying cloud resources

presented by Peter Zaitsev

In the current era of cloud computing, gone are the days of managing single-app systems with a standalone database. Instead, we find ourselves responsible for overseeing complex systems containing hundreds of services and dozens of databases. What makes it even more challenging is the dynamic nature of these systems. Databases can now migrate between nodes, and their storage performance can be ...

more

11:10 - 12:00 Santa Clara Ops
Denis Magda PgCompute: Creating Stored Procedures the Developer Way

presented by Denis Magda

Stored procedures have been a feature of Postgres for years. They were designed to let developers execute data or compute-intensive logic directly where the data lives—in the database—thereby reducing network latency. However, even in 2024, this relational database feature hasn’t gained widespread adoption within developer communities for various reasons.

PgCompute is a new client-side Postg...

more

11:10 - 12:00 Winchester Dev
Frank McSherry Better materialized views in 1 million LOC: Inside Materialize's PostgreSQL source

presented by Frank McSherry

PostgreSQL's materialized views are a great tool to provide low-latency answers to complex queries – but did you know they could offer serializable consistency if you used cutting-edge streaming engines, many millions of dollars, and countless hours of work from talented systems engineers and academics? Oh, and I guess you could then also join them with arbitrarily complex queries over Kafka to...

more

11:10 - 12:00 Almaden Dev
11:40
Tatiana Krupenya Looking for the differences in your data.
Main challenges for data comparing in tables in Postgres and other databases.

presented by Tatiana Krupenya

What is the difference between your stable production and test databases? Data.

When your system is active, data changes very quickly. You have made a backup up, and the next hour, it won't match with the database anymore. You migrated the data from your old database to a new one, but while you are finalizing all processes, data stops being synchronized. Of course, you can compare the data ...

more

11:40 - 12:00 San Pedro Ops
12:10
Wanda  He Thuymy Tran Troubleshoot PostgreSQL performance by use case

presented by Wanda He and Thuymy Tran

The performance of your PostgreSQL database might be affected for multiple reasons, such as hardware (CPU, memory, disk) sources, application access pattern, suboptimal query plans, and etc. This session presents use cases of common PostgreSQL performance problems, discusses approaches and methodologies for “peeling the onion”, and identifies solutions. Use cases cover include idle connections,...

more

12:10 - 13:00 Santa Clara Essentials
Kobus Wolvaardt Postgres in Dockers on ZFS
How we manage a large amount of postgres DBs and clusters on ZFS spin disks in dockers.

presented by Kobus Wolvaardt

Our journey from large 200 database clusters on mirrored SSDs to smaller 20 to 40 databases per cluster and 4 to 10 clusters per machine on spin disks using ZFS. How we manage replication, how we backup 2500 DBs (hint ZFS snapshots) and just some of the fun things we saw on our journey.

12:10 - 12:30 San Pedro Ops
Amit Chauhan pg_hint_plan – get the right plan without surprises
Get more control on the query planner to understand the optimizer choices

presented by Amit Chauhan

I frequently use pg_hint_plan to gain insights into the query planner choices made by the optimizer, and sometimes to work around issues that arise in production. However, hinting is often a complex task, requiring multiple hints to fix an exact plan. We will explore practical examples of how to use pg_hint_plan in a predictable manner, while also gaining a better understanding of access paths,...

more

12:10 - 13:00 Winchester Dev
David Wein Deep Dive into Amazon Aurora Limitless Database and its innovations

presented by David Wein

Amazon Aurora is a relational database service built for the cloud that provides unparalleled high performance and availability at global scale with full PostgreSQL compatibility. In this session, learn how Amazon Aurora Limitless Database enables applications to scale to millions of transactions per second across petabytes of data. Explore the architecture, distributed transaction management, ...

more

12:10 - 13:00 Almaden
12:40
Jan Wieck Good bye sequences, hello Snowflakes
A detailed look at the problems sequences pose in replication and how to overcome them.

presented by Jan Wieck

Sequences and serial columns have been a problem when it comes to logical database replication since the days of Slony-I. In this talk we take a look at different ways to avoid replicating sequences in the first place and how Snowflake IDs can help solve the problem, especially as we move to multi-master systems.

12:40 - 13:00 San Pedro Ops
13:00
PostgresConf Organizers Wednesday Lunch

presented by PostgresConf Organizers

Wednesday Lunch Wednesday Lunch Wednesday Lunch Wednesday Lunch Wednesday Lunch

13:00 - 14:00 Almaden
14:00
Dave Stokes Do You Know A CID From An OID Or An XID? A beginners guide to the alphabet soup found in and around PostgreSQL touples.
Who is on first? And What is on second!

presented by Dave Stokes

The learning curve for PostgreSQL can be nearly verticle for those caught up in the terminology. So if you find yourself stuck between MIN and CMAX, or have no idea what those things are, then you should be in this talk. This will be a gentle introduction for those new to PostgreSQL to some of the more common but no less obscure terminology that you will stumble over when trying to discern the ...

more

14:00 - 14:50 Santa Clara Essentials
Phillip Merrick Use Cases for Multi-Master Distributed Postgres

presented by Phillip Merrick

Today’s modern applications must be always on, always available, and serve a global user base that demands fast response times. A fully multi-master distributed database architecture is critical for organizations to meet these demands. In this talk, we will explore the core use cases that benefit from deploying PostgreSQL with asynchronous logical replication in a multi-region or even multi-clo...

more

14:00 - 14:20 Almaden Essentials
Chandra Pathivada "Behind the Scenes: Demystifying Transaction Isolation in App Development"
PostgreSQL Isolation Levels Unveiled: Your Comprehensive Guide

presented by Chandra Pathivada

Join us to understand how these Isolation levels impact the consistency, concurrency, and reliability of your database transactions. demystify the complexities of PostgreSQL isolation levels, helps you to make informed decisions in managing data integrity within your applications.

14:00 - 14:50 Winchester Dev
Biren Shah Zero-downtime Postgres Major Version Upgrades
How we execute PostgreSQL major upgrades at GitLab, with zero downtime.

presented by Biren Shah

Upgrading your highly available, high-load PostgreSQL databases can be a challenge on its own. When having customers around the globe with tight SLAs, the requirement arises to execute these upgrades with minimal or even without any downtime.

This talk walks through how we at GitLab evolved from multi-hour downtime windows to not causing any customer-facing interference at all.

14:00 - 14:50 San Pedro Ops
14:30
Drew Stevens How can you measure PostgreSQL portability?
Can something be 99.9% compatible

presented by Drew Stevens

In the modern database ecosystem, there are a lot of offerings that implement some, most, or all of the PostgreSQL API. Google Cloud's hyper-scalar Spanner database is one of them. Fidelity to the PostgreSQL syntax and semantics is important to portability and participation in this ecosystem. Hear how we use a variety of testing approaches to validate that Spanner's support for PostgreSQL is ...

more

14:30 - 14:50 Almaden Dev
15:10
Peter Zaitsev Cloud Native PostgreSQL - Running PostgreSQL on Kubernetes

presented by Peter Zaitsev

Running PostgreSQL on Kubernetes is becoming increasingly popular, offering various methods for implementation. This talk will examine different operators that facilitate running PostgreSQL on Kubernetes. We'll also take a look at Neon PostgreSQL, specifically designed for cloud-native environments, and cover the most important best practices for effectively running PostgreSQL on Kubernetes.

15:10 - 16:00 San Pedro Ops
Gwen Shapira Schema Evolution - The Hard Parts
Modifying database schema may sound easy, but is it really?. Lets talk about cases where modifying schemas is more than a simple DDL

presented by Gwen Shapira

Schema evolution, also known as “schema migrations” is a core part of application development and is considered one of the riskiest - with the potential to bring down entire production systems with one innocent mistake.

Schema evolution becomes especially tricky for SaaS, where the same application serves a large number of tenants. Regardless of whether the tenants share the same Postgres d...

more

15:10 - 16:00 Winchester Dev
Charly Batista Reducing Costs and Improving Performance With Data Modeling in Postgres

presented by Charly Batista

In this session we'll unravel the intricacies of PostgreSQL's internal data organisation, shedding light on the Free Space Map (FSM) mechanism. Delving into the heart of PostgreSQL's data architecture, we'll explore ways to strategically reorganise the data model, capitalising on data alignment within blocks. The goal? To unveil techniques that not only optimise disk space usage but also enhanc...

more

15:10 - 16:00 Santa Clara Essentials
Manish Shah Zero Trust database access with DBHawk
Whether you're a Database Developer, DBA or DevOps professional - our web-based tool will simplify your workload with no need for additional client software.

presented by Manish Shah

With DBHawk, users only receive access to the data they need. DBHawk provides zero trust secure access to on-premises and cloud databases.

In this demo, you'll learn:

  • How you can provide secure database access to your users. How to dynamically mask data and apply Object Access Control Policy.
  • How to connect to PostgreSQL, Microsoft SQL Server, Azure SQL, Google Cloud SQL, AWS RDS, M...
more

15:10 - 16:00 Almaden Ops
16:10
Yurii Rashkovskii Pushing boundaries with extensions, for extensions
Extending the extensions

presented by Yurii Rashkovskii

Postgres extension ecosystem is growing, and the capabilities of Postgres are growing with it.

But just as the extensions are pushing the boundaries of what's possible with Postgres, we've come to a point where we need to consider how much the extensions need to push the boundaries of Postgres' extension harnessing.

Let's talk about the limitations and constraints of the current extension...

more

16:10 - 17:00 Winchester Dev
Chandra Pathivada Why PostgreSQL Isn't Utilizing Indexes: Diagnosing and Solving Performance Issues"
Uncovering the Reasons Behind Suboptimal Index Usage and Optimizing PostgreSQL Query Performance

presented by Chandra Pathivada

In this session, we delve into the common scenarios where PostgreSQL may not be utilizing indexes as expected, leading to suboptimal query performance. We explore the underlying reasons, such as query optimization, data distribution, and indexing strategies, that can impact index usage. Join us as we discuss practical solutions and best practices for diagnosing and rectifying these issues, ulti...

more

16:10 - 17:00 Santa Clara Essentials
Ibrar Ahmed Achieving High Availability (HA) in PostgreSQL: Strategies, Tools, and Best Practices
High Availability

presented by Ibrar Ahmed

In the continuously evolving landscape of digital enterprises, ensuring uninterrupted service and data availability is not just a luxury, but a mandate. PostgreSQL, celebrated for its robustness and flexibility, offers myriad ways to implement High Availability (HA) and fault tolerance. However, with options comes complexity. This talk aims to demystify HA for PostgreSQL, guiding attendees thro...

more

16:10 - 17:00 San Pedro Ops
Richard Guo A high-level introduction to the query planner in PostgreSQL

presented by Richard Guo

This talk will focus on how the planner works from a developer’s view and elaborate on the process of converting a query tree to a plan tree in details.

We can divide the planning process into 4 phases: preprocessing, scan/join planning, post scan/join planning and postprocessing. In this talk, I will explain what stuff is performed in each phase and what is the motivation to perform that. T...

more

16:10 - 17:00 Almaden Dev
17:00
PostgresConf Organizers Welcome Reception
Sponsored by Amazon Web Services

presented by PostgresConf Organizers

Amazon Web Services Sponsored Welcome Reception. Come meet fellow Postgres advocates and have a drink!

17:00 - 19:00 Almaden
2024-04-18
09:00
Curt Kolovson I implemented the first Vacuum Cleaner Daemon (the most "hated" thing about Postgres)
A retrospective review of the original Postgres Storage System

presented by Curt Kolovson

Title: Keynote “The Original Postgres Storage System” Speaker: Curt Kolovson https://www.linkedin.com/in/ckolovson/

This is a retrospective talk reflecting on my experience at UC Berkeley and my collaborations with Prof. Michael Stonebraker, both from 1980-81 when I earned my MS in Computer Science at UC Berkeley, and from 1986-1990 when I earned my PhD working under Prof. Stonebraker. The...

more

09:00 - 09:20 Almaden Essentials
09:30
Ravi Murthy The future of databases and Generative AI

presented by Ravi Murthy

We're living in an exciting time for databases. The generative AI ("GenAI") boom is bringing a wave of innovation and transforming software development, and PostgreSQL is where the action is. We'll cover the key data and AI trends that we've seen in the past year, review the many ways that AI can be valuable for developers, DBAs and other database professionals, and outline our vision for the f...

more

09:30 - 09:50 Almaden Google Cloud
10:00
Gleb Otochkin JSON and analytics in Postgres using index and columnar.
Challenges and tools in hands to work with JSON data in Postgres

presented by Gleb Otochkin

We want it to be fast, reliable and flexible. We want JSON and we want OLTP with ACID. Can all it work together or we need to choose 2 out of three of our wishes again? What technology can help to speed up the JSON queries? A couple of different approaches for JSON data analytics. Here is what we are going to discuss: - JSON data types - usage and challenges - Indexes for JSON data types - ...

more

10:00 - 10:50 Winchester Dev
Silas Marvin RAG Masterclass: Simplify your data infrastructure with in-database NLP using pgml and pgvector for Retrieval Augmented Generation

presented by Silas Marvin

Retrieval Augmented Generation (RAG) represents a cutting-edge approach in natural language processing (NLP) — combining the strengths of semantic search for contextual retrieval with the generative capabilities of large language models (LLMs) to produce highly relevant and nuanced text outputs. PostgreSQL is an ideal NLP platform for AI and ML applications with the pgml and pgvector extensio...

more

10:00 - 10:50 San Pedro Ops
Clay  Jackson The Accidental DBA
A survival guide for DBAs in today's heterogeneous environment

presented by Clay Jackson

The Accidental DBA – Strategies for today’s heterogeneous database environment Are you an Oracle DBA or developer? Have you been asked to work with PostgreSQL, or MySQL, or some other data platform? This presentation will give you some practical advice on how to make the transition. We’ll cover processes, reference material and tools that will ensure you can thrive in today’s heterogeneous ...

more

10:00 - 10:20 Santa Clara Essentials
Bjoern Rost Making PostgreSQL your strategic database for AI

presented by Bjoern Rost

The generative AI boom is putting databases front and center, and PostgreSQL has emerged as the defacto standard for working with vectors, models, and data. In this first session in a half day of Google-led learning, we'll explore what PostgreSQL offers for gen AI developers, which PostgreSQL options are available on Google Cloud (with a focus on AlloyDB), and how to do a heterogeneous migratio...

more

10:00 - 10:50 Almaden Google Cloud
10:30
Dane Falkner Optimizing for Excellence: Advanced Performance Tuning Techniques for Aurora Postgres

presented by Dane Falkner

In the realm of database technologies, Aurora Postgres stands out for its robust performance, scalability, and reliability. However, leveraging its full potential requires a deep understanding of both foundational and advanced optimization strategies. This presentation, "Optimizing for Excellence: Advanced Performance Tuning Techniques for Aurora Postgres," is meticulously crafted for intermedi...

more

10:30 - 10:50 Santa Clara Essentials
11:10
Avinash Dalvi Harnessing the power of Postgres for GIS
Using Postgres database for GIS case study

presented by Avinash Dalvi

In this talk, we will discuss the benefits of using Postgres for GIS and how to harness the power of Postgres for your GIS applications. We will cover the following topics:

  • Overview of Postgres and PostGIS
  • Storing and querying geospatial data in Postgres
  • Using spatial indexing to improve performance
  • Building GIS applications with Postgres and PostGIS

We will also present a c...

more

11:10 - 12:00 Winchester Dev
Ibrar Ahmed Unraveling Multi-Master Replication in PostgreSQL: Architectures and Solutions
Multi-Master Replication

presented by Ibrar Ahmed

Unraveling Multi-Master Replication in PostgreSQL: Architectures and Solutions

Abstract: PostgreSQL, one of the world’s most advanced open-source relational database management systems, has undergone significant evolution over the years, with its vast ecosystem continuously expanding to meet the diverse needs of the modern digital age. One area that has captured significant attention is dat...

more

11:10 - 12:00 San Pedro Ops
Nimesh Bhagat Nilesh Junnarkar Database operations in the AI era
Gemini in Databases – An AI powered database assistant

presented by Nimesh Bhagat and Nilesh Junnarkar

In the second session of the half-day Google-led learning (which you can also attend as a standalone session), we'll focus on database administration in the cloud and AI era. We'll review how AlloyDB uses adaptive algorithms for vacuum management, storage management, memory management and query optimization, and how you can use AI to manage a database fleet and optimize individual database inst...

more

11:10 - 12:00 Almaden Google Cloud
Dave Stokes MERGE() - A Quick Introduction
Unleash the Power of SQL with one new function!

presented by Dave Stokes

Merge() was introduced in PostgreSQL 15 and a few unkind individuals have dismissed it as a fancy 'upcert'. But MEREGE() is more than that! If you run batch data, like cash register transaction logs, and need to reconcile them against your main table, MEREGE() becomes a fantastic tool to speed processing and make your life much easier.

11:10 - 11:30 Santa Clara Essentials
11:40
Bohan Zhang Everything you want to know about Postgres autovacuum
Best practices for monitoring and tuning autovacuum in Postgres

presented by Bohan Zhang

Because of the design and implementation of Multi-Version Concurrency Control (MVCC) in Postgres, the old data accumulates during updates. Hence, the indispensable role of Postgres autovacuum, responsible for garbage collection of dead tuples, becomes crucial for ensuring database performance. However, effectively monitoring and tuning autovacuum is a non-trivial task. In this presentation, I w...

more

11:40 - 12:00 Santa Clara Essentials
12:10
Guyren Howe Postgres’s Type System
Use types to make better Postres code

presented by Guyren Howe

Postgres is the only major database with an advanced type system.

Come to this talk to learn about common gotchas with Postgres types, and how to get the most out of row types; enumerated types, and user defined types to make your Postgres code simpler, more readable and more effective.

12:10 - 13:00 Santa Clara Essentials
Shayon Sanyal Sundar Raghavan Enhancing OLTP Systems with pgvector: Best Practices in Database Design
Generative AI and PostgreSQL

presented by Sundar Raghavan and Shayon Sanyal

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 with...

more

12:10 - 13:00 Winchester Dev
Gleb Otochkin Building GenAI applications on PostgreSQL

presented by Gleb Otochkin

In the third session of the half-day Google-led learning (which you can also attend as a standalone session), we'll get down to the business of building a gen AI app. We'll review the concepts of LLMs, vector databases, vector search, vector embeddings and Retrieval Augmented Generation (RAG), and learn about pgvector and related PostgreSQL technologies. We'll bring it all together with an Allo...

more

12:10 - 13:00 Almaden Google Cloud
Chirag Dave Sami Imseih Becoming a PG_STAT_* (star)

presented by Chirag Dave and Sami Imseih

Want to become a PostgreSQL performance monitoring star?

Come and explore the world of the PostgreSQL Cumulative Statistics System, a.k.a. the pg_stat views, and see how this system can give you insights on critical workload activity such as visibility into I/O activity and much more that can help in real-time troubleshooting as well as proactive monitoring.

In this talk, we will explore...

more

12:10 - 13:00 San Pedro Ops
13:00
PostgresConf Organizers Thursday Lunch

presented by PostgresConf Organizers

Thursday Lunch Thursday Lunch Thursday Lunch Thursday Lunch Thursday Lunch

13:00 - 14:00 Almaden
14:00
Gleb Otochkin Building GenAI applications on PostgreSQL (continued)

presented by Gleb Otochkin

This session provides extra time to finish the AlloyDB GenAI hands-on lab.

14:00 - 14:50 Almaden Google Cloud
Rajan Palanivel Transparent Application-level Encryption with Postgres Trusted Language Extensions
TLE

presented by Rajan Palanivel

Companies get significant business value out of the data they’ve collected. But, they are facing challenges with staying compliant with data privacy regulations while processing and analyzing the data in Postgres.

Typically, privileged database users have cleartext access to regulated data, in violation of compliance regulations. But, Postgres doesn’t provide all of the capabilities necessa...

more

14:00 - 14:50 Winchester Dev
Greg Dostatni Advanced strategies for PostgreSQL Lock Management
Beyond the Deadlock: Examining Complex Lock Scenarios in PostgreSQL

presented by Greg Dostatni

Effective lock management is important for any database’s performance and stability. This presentation offers an exploration of some pitfalls and solutions to the Lock Manager challenges related to large, high performance environments.

We begin by examining how table inheritance can multiply the number of locks, and how that can affect performance when dealing with more than 10,000 locks. We...

more

14:00 - 14:50 San Pedro Ops
15:10
Ryan Booz Database DevOps: Options for Test Data and Database Change Management

presented by Ryan Booz

Whether you are the DBA for an agile, sprint-based team, or a developer with DBA responsibilities, you may feel like there are development bottlenecks at every turn.

Managing migrations with your ORM of choice is easy but often highly manual, error-prone and hard to manage as the project grows. Or worse yet, maybe your schema and change management consists of poorly commented SQL scripts sav...

more

15:10 - 16:00 Winchester Dev
Sridhar Ranganathan Building data-driven apps in the cloud

presented by Sridhar Ranganathan

In the fourth and final session of the half-day Google-led learning (which you can also attend as a standalone session), we'll look at databases and analytics integration. A PostgreSQL database is a great source of operational data for real-time analytics and decision making for your apps and analytics systems. We'll learn about federated queries, streaming data, and built-in analytics, and the...

more

15:10 - 16:00 Almaden Google Cloud
Sameer Malik Accelerate Oracle to PostgreSQL migration journey - top 10 challenges and mitigation

presented by Sameer Malik

Customers are looking to migrate off Oracle due to Vendor lock-in, Punitive licensing which results in license audits. Customer are required to pay for Initial license costs, each new features and options require additional licenses and they must license for the peak load . PostgreSQL is , the world's most advanced Open Source Database” that supports all features of RDBMS. PostgreSQL's PL/pgSQL...

more

15:10 - 16:00 Santa Clara Essentials
Charly Batista Monitoring PostgreSQL: Navigating the Landscape of Metrics, OS and Hardware Relationships, and Toolsets

presented by Charly Batista

In the dynamic landscape of PostgreSQL management, robust monitoring is the cornerstone of maintaining a healthy and performant Postgres environment. This talk delves deep into the intricacies of PostgreSQL monitoring, addressing fundamental questions: What are the most crucial aspects to monitor within the database? How do these metrics relate to the underlying operating system? And, in a mark...

more

15:10 - 16:00 San Pedro Ops
16:10
Peter Celentano Tracy Jenkins PostgreSQL architecture considerations for application developers
Why should developers care about PostgreSQL internals?

presented by Tracy Jenkins and Peter Celentano

Although the application layer is the portion the world accesses for many cloud architectures, it seems that we rarely consider how we can optimize our application for the database we’re using. When using any relational database engine, it’s important to consider not just schema design, but understanding how databases read and write data to their storage systems to ensure the application is man...

more

16:10 - 17:00 Winchester Dev
Frits Hoogland Exploring Linux memory usage and IO performance with PostgreSQL

presented by Frits Hoogland

Linux and containers are similar in that they provide operating system resources such as memory and storage. These resources, along with CPU and networking, are key factors to achieve optimal performance. However, databases in general and therefore PostgreSQL too relies on high performance disk IO to function properly. This widely known.

In this session, we'll explore how memory allocation a...

more

16:10 - 17:00 San Pedro Ops
Michael Meskes Open Source At A Crossroads

presented by Michael Meskes

For the first time in history almost everyone uses Open Source, albeit often without getting the benefits of Free Software. Open Source has accomplished unparalleled success in the IT industry, but with success comes challenges and risks. Over recent decades we have seen business models change while the industry and the users found the best ways to use Open Source. With Software as a Service we...

more

16:10 - 16:30 Almaden Essentials
Varun Dhawan Elevate Your PostgreSQL Experience in the Cloud with Azure Database for PostgreSQL

presented by Varun Dhawan

In a rapidly evolving digital landscape; choosing the right managed service for your PostgreSQL database is crucial. Azure Database for PostgreSQL stands out as a leading option; offering a blend of High Performance; Reliability; Security; and advanced features. This session delves into what sets Azure Database for PostgreSQL apart as a compelling choice for hosting PostgreSQL databases. We wil...

more

16:10 - 17:00 Santa Clara
16:40
Janis Griffin Top 5 PostgreSQL Query Tuning Tips
Tuning Tips with Case Studies

presented by Janis Griffin

Performance tuning can be complex. It’s often hard to know which knob to turn or button to press to get the biggest performance boost. This presentation will detail five steps to identify performance issues and resolve them quickly. Attendees at this session will learn how to fine-tune a SQL statement quickly; identify performance inhibitors to help avoid future performance issues; recognize co...

more

16:40 - 17:00 Almaden Essentials
2024-04-19
09:00
Johann Schleier-Smith Self-Managing Databases—If Not Now Then When?

presented by Johann Schleier-Smith

Many software developers hesitate to choose Postgres because running it well can be challenging. While it is easy to get started, at certain levels of scale or application complexity it becomes challenging to set the 300+ Postgres configuration knobs properly.

From the early days of databases, people have sought to automate their configuration and administration. These efforts gained tractio...

more

09:00 - 09:50 Santa Clara Essentials
Mohamed Ali Elevate your DBA toolset with pg collector
a powerful open-source tool that help you gain deep insights into your PostgreSQL database

presented by Mohamed Ali

PG Collector is a powerful open-source tool (https://github.com/awslabs/pg-collector) that gathers valuable PostgreSQL performance details and presents it in a simple report. If you are a DBA, come and learn how PG Collector can help reduce your mean Time to Know (MTTK) and help you gain deep insights into the health of your PostgreSQL database.

09:00 - 09:50 San Pedro Ops
Nikita Shamgunov Postgres in the 21st Century

presented by Nikita Shamgunov

How Postgres needs to change to support modern application workloads

09:00 - 09:50 Almaden
Robert Bernier Working With The Citus Extension
A Gentle Introduction

presented by Robert Bernier

Scaling PostgreSQL is a big deal but it doesn't have to be hard. There was a time when the only way scaling PostgreSQL was to design the architecture entirely on your own and basically figure out the entire life-cycle before even putting it into production. Since those early days a lot of technologies and processes have come into being that can guide one to creating, growing and maintaining a ...

more

09:00 - 09:50 Winchester Ops
10:00
Varun Dhawan Building GENAI Applications with OpenAI and PostgreSQL

presented by Varun Dhawan

Join this session to learn how to use PostgreSQL and OpenAI together to make smart AI applications. In this session, you will gain practical experience in configuring, and integrating OpenAI with PostgreSQL to create cutting-edge AI applications. We'll cover everything in two main parts:

Module 1: Setting Up and Starting Development

  • Learn how to get PostgreSQL ready for use, includi...
more

10:00 - 10:50 San Pedro Dev
Chirag Dave Sami Imseih PostgreSQL Partitioning: Beyond the obvious

presented by Chirag Dave and Sami Imseih

Partitioning divides table into smaller parts which helps in improving database performance and scalability. In PostgreSQL there not so obvious reason why you want to partition your table effectively to improve scalability, optimize the performance and management of your database.

In this talk we will discuss Vacuuming, caching benefits, and multi-tenancy with respect to partitioning. You w...

more

10:00 - 10:50 Santa Clara Essentials
Tim Steward We like to Move it, Move it!: Migrating production systems between databases
Migrating production systems between databases

presented by Tim Steward

If like most developers, you are using a relational database as part of your digital landscape, then you will likely be required to manage the migration of data from a legacy system to a new platform at some point.

Data migration can be a lot more complicated than you expect. Poor planning, making too many assumptions, and a lack of testing are just SOME of the reasons why a data migration m...

more

10:00 - 10:50 Winchester Ops
Yurii Rashkovskii Omnigres: Postgres can do WHAT?

presented by Yurii Rashkovskii

People mostly think of Postgres as a database. But because of its extensibility, it can already do so much more.

Except that wasn’t enough for us. We set out to extend Postgres to become a comprehensive platform for data-intensive applications and built Omnigres, a constellation of extensions. They allow building polyglot applications right on top of Postgres, with a simple goal: building fa...

more

10:00 - 10:50 Almaden Dev
11:00
Srinivasa  Inaganti Improve Postgres Security Posture with KloudDB Shield- Postgres and RDS Postgres

presented by Srinivasa Inaganti

  • Importance of log_line_prefix
  • Log_connections and log_disconnections
  • HBA rules - trust vs md5 vs ident vs scram
  • Functions - INVOKER vs DEFINER
  • User access control
  • RDS SNS events , security groups etc..
  • Data breach anatomy
  • SSL tips

11:00 - 11:50 Almaden
Peter Farkas Moving MongoDB Workloads to Postgres

presented by Peter Farkas

MongoDB, a widely used database, has garnered both love and hate from its users across different industries due to its ease of use. However, it is no longer open source, faces licensing issues, and requires additional resources and knowledge to run. Is there a viable alternative? Can we move existing MongoDB workloads to Postgres without any application-level changes? How can we ensure MongoDB ...

more

11:00 - 11:50 Winchester Ops
Denis Magda PostgreSQL with OpenAI: Building and Monetizing Generative AI Plugins

presented by Denis Magda

OpenAI's GPT neural network can be enhanced and customized with plugins. For instance, the Expedia plugin arms the AI with current data on lodging prices and availability, allowing users to book their next trip directly through the ChatGPT interface.

In this session, you'll gain practical experience with large language models (LLMs) by creating a Postgres-backed plugin for the OpenAI platfor...

more

11:00 - 11:50 San Pedro Dev
Ryan Booz Mastering PostgreSQL Partitioning: Supercharge Performance and Simplify Maintenance

presented by Ryan Booz

As your database grows, the performance and maintenance of large tables can become challenging. Fear not! PostgreSQL has the right tool for the job: declarative table partitioning. In this talk, I will explore the benefits of partitioning in PostgreSQL, including improved performance and simplified maintenance.

After introducing the benefits of table partitioning, I’ll discuss the different ...

more

11:00 - 11:50 Santa Clara Essentials
12:00
Patrick Mottram The Postgres Advantage in AI Enterprise Workloads
Operational AI Workload Means Postgres Database Workload.

presented by Patrick Mottram

The massive interest in AI solutions recently sparked a huge wave of AI projects. We now enter a second phase where valid AI projects look for operational enterprise environments, as shown by the big hype for vector databases and feature stores. This phase is the hour of databases, the recognised bedrock for enterprise data management environments, where Postgres is a front runner. AI workloads...

more

12:00 - 12:50 Almaden Essentials
Clay  Jackson Model your data before you move it

presented by Clay Jackson

Data movement is a transformative force in today's digital landscape, enabling organizations to unlock the true value of data. Successful data movement requires a comprehensive data governance strategy that encompasses data selection, understanding, quality, mapping, schema development, and serialization.

Data governance is the key to unlocking the power of data movement, ensuring accurate, ...

more

12:00 - 12:50 Santa Clara Essentials
Alvaro Hernandez Postgres in the Containers Era
The Future; and the Present; is to run Postgres on Containers

presented by Alvaro Hernandez

Containers are everywhere. Whether in a code test suite, a developer's laptop, in production or CI/CD pipelines, containers have taken the deployment world by storm. Similarly, Kubernetes adoption is skyrocketing.

How does Postgres fit in this container era? Is Postgres "cloud native"?

The challenges to optimally run Postgres in containers will be explored, including the challenges associ...

more

12:00 - 12:50 Winchester Ops
Jonah Harris Mason Sharp The Future of MySQL is Postgres
Simplifying Migrations by Reimagining MySQL as a PostgreSQL Extension

presented by Mason Sharp and Jonah Harris

Syntax discrepancies. Data type mismatches. Application rewrites. These daunting pain points are faced by every developer and DBA considering a migration between database vendors. In this session, we'll dive into a revolutionary PostgreSQL extension that directly addresses these challenges, positioning PostgreSQL as the future of MySQL.

Much like AWS Babelfish for SQL Server, this extension ...

more

12:00 - 12:50 San Pedro Dev
13:00
PostgresConf Organizers Friday Lunch

presented by PostgresConf Organizers

Friday Lunch Friday Lunch Friday Lunch Friday Lunch Friday Lunch Friday Lunch

13:00 - 14:00 Almaden
14:00
Gwen Shapira Transaction Isolation in Postgres
Understand transaction isolation levels once and for all with many examples and a bit of history

presented by Gwen Shapira

Transactions are a key part to many modern databases, relational and non-relational systems alike. At a basic level, transactions allow us to treat a series of operations as a single unit. The reason transactions are so important is because they provide guarantees that developers can then use as assumptions when writing code. This means that there are entire set of concerns that you, the develo...

more

14:00 - 14:50 Santa Clara Essentials
Gleb Otochkin Alan Li Vector Search in PostgreSQL using Different ANN Algorithms
How to make the ANN vector search faster

presented by Gleb Otochkin and Alan Li

The Vector data type is one of the most used data types for the latest AI applications prototypes and implementations. It is commonly used in applications such as image retrieval, natural language processing, and recommender systems. Vector search is a technique used to find similar vectors in a high-dimensional space and how we do it has a direct impact on the system performance. We will disc...

more

14:00 - 14:50 San Pedro Dev
Billy VanCannon PCI-DSS on Postgres Encryption and Database access
Encryption for data compliance and security

presented by Billy VanCannon

Encryption is widely accepted as a very powerful access control mechanism and the only one directly applied to data. Despite this, it isn’t as widely used as it could be. Using the PCI-DSS security framework for payment card data, we will investigate what it says about encryption regarding audit scope and securing credit card information. We will show the role of encryption can be expanded t...

more

14:00 - 14:50 Winchester Ops
15:00
Conrad Hofmeyr Local-first application architecture using Postgres logical replication
Building a highly-scalable sync engine with dynamic partial replication

presented by Conrad Hofmeyr

Local-first app development has some significant advantages over the cloud-first app development paradigm. For app developers, having local access to data simplifies state management and removes the bottleneck of waiting for API or backend functionality. For end-users, local data provides an instantly reactive UI since there is no need to wait for network requests and apps keep working through ...

more

15:00 - 15:20 San Pedro Dev
Min-Hank Ho Securing Postgres for use with GenAI
A review of the options to protect Postgres data used in GenAI to meet compliance requirements

presented by Min-Hank Ho

Businesses want to leverage private data for GenAI because it can save them time, money, and resources. They can also derive new insights and use their data for a competitive advantage. Postgres plays an important role in enabling GenAI applications, not only as a vector database provider through the use of extensions like pgvector, but also as the data source at the beginning of GenAI pipeline...

more

15:00 - 15:50 Santa Clara Essentials
15:30
Samuel Hu Bounded and Unbounded Data for RAG Systems: Postgres Is All You Need
Postgres Is All You Need

presented by Samuel Hu

PostgreSQL, renowned as the world's most popular OLTP database, stands at the forefront of transaction data workloads. However, this presentation will elaborate on why PostgreSQL dominates in the realm of Retrieval-Augmented Generation (RAG) systems too, highlighting its versatility and ecosystem in handling not only bounded, but even further, unbounded data. The presentation contains a live. ...

more

15:30 - 15:50 San Pedro Dev
BAJI SHAIK Beyond Boundaries: Mastering 2-Level Encryption Migration in PostgreSQL

presented by BAJI SHAIK

Ensuring data security is paramount, especially in industries governed by HIPAA compliance. However, migrating encryption protocols from Oracle to PostgreSQL presents unique challenges due to their divergent methodologies. In this presentation, we delve into a compelling case study of a customer grappling with the intricacies of 2-level encryption migration. Explore the nuances of Oracle's encr...

more

CANCELED 15:30 - 15:50 Winchester Ops
16:00
Sai Srirampur How can we make pg_dump and pg_restore 10 times faster?
N/A

presented by Sai Srirampur

pg_dump and pg_restore are reliable tools for backing up and restoring Postgres databases. They are widely used for various real-world use cases, including Database Migrations, Disaster Recovery, and more.They offer fine grain control, allowing selection of specific db objects for backup and restore, choice of dump format (plain text or compressed), and parallel processing of multiple tables....

more

16:00 - 16:20 San Pedro Dev
Perren Walker Discover the Power of PostgreSQL's Modularity and Extensibility
A Survey of PostgreSQL Extensions & Use-Cases

presented by Perren Walker

This training will cover some of the most popular PostgreSQL extensions, their use cases and a deep dive into their usage. Gain a comprehensive understanding of PostgreSQL extensions and their role in expanding database functionalities.

Explore major extensions, emphasizing PostGIS, pg_routing, hstore, uuid-ossp, pg_trgm, pg_stat_statements, pg_vector, pgbigm, and TimescaleDB.

Learn prac...

more

16:00 - 16:50 Santa Clara Essentials
Ibrar Ahmed Scaling PostgreSQL: Navigating Horizontal and Vertical Scalability Pathways
Scaling PostgreSQL

presented by Ibrar Ahmed

As businesses grow and data traffic intensifies, PostgreSQL database systems are often thrust into the spotlight, faced with the critical challenge of accommodating increasing workloads. In the database realm, scalability is the magic word. But how does one choose between vertical (scaling up) and horizontal (scaling out) scalability? And more importantly, how are these effectively implemented ...

more

16:00 - 16:50 Winchester Ops
16:30
Sai Srirampur What does it take to build a first class data movement tool for Postgres?
N/A

presented by Sai Srirampur

Every datastore is unique with a diverse set of features and data modeling characteristics. For example, PostgreSQL has 4 ways to ingest data, 5 ways to read data, 300+ data types and 300+ database configs. Building data movement solutions that scale, therefore, requires an emphasis on the unique design and capabilities of each data store.

However, most existing data movement tools focus on ...

more

16:30 - 16:50 San Pedro Dev