Silicon Valley 2023 Program

Emir Okan AlloyDB: PostgreSQL in a way that only Google can deliver it

presented by Emir Okan

Summary: Google Cloud launched AlloyDB in 2022 to provide a fully managed PostgreSQL-compatible database service for the most demanding enterprise workloads. In this talk, you will learn how AlloyDB combines the best of Google with PostgreSQL, for superior performance, scale, and availability, both in Google Cloud and in your own environments with our recently launched downloadable edition, All...


09:40 - 10:00 Almaden Ballroom, Main Level Data
Ry Walker The Growing Postgres Ecosystem

presented by Ry Walker

While Postgres has a long history of success, the best may be yet to come for the community due to a growing number of tools, extensions, companies, and use cases.

10:10 - 10:30 Almaden Ballroom, Main Level Ops
Jignesh Shah Bringing developers and Postgres closer together
AWS Keynote

presented by Jignesh Shah

Postgres is commonly referred to one of the most loved databases by developers, but why is that? Let's explore what Postgres has done to earn that reputation. We’ll also look into the future of what needs to happen for Postgres to retain that love as developers’ needs evolve.

10:40 - 11:00 Almaden Ballroom, Main Level AWS RDS and Aurora
Leta Keane How to Escape the Cult of Expertise
growth mindset and how the words "I don't know" can save you

presented by Leta Keane

Tech is a field full of experts. How do we know when our own love of knowhow is holding us back? If we can't admit that we don't know something, are we really able to keep learning? How does this idea of Expertise contribute to the lack of diversity and inclusion on our teams?

This talk will examine grit, growth mindset, and the ways our love of knowing everything can actually keep us from c...


11:10 - 11:30 Almaden Ballroom, Main Level Dev
Karthik Ranganathan Embrace, Extend, Evolve: Making PostgreSQL Work for Cloud Native Applications

presented by Karthik Ranganathan

PostgreSQL continues its reign as the most widely used open source database due to its powerful feature set and rich ecosystem of tools and extensions. Join Yugabyte’s co-founder and CTO, Karthik Ranganathan, as he delivers a masterclass on building a future-proof distributed SQL database that fully “speaks” PostgreSQL and is designed specifically for cloud-native applications.

11:40 - 12:00 Almaden Ballroom, Main Level Yugabyte DSS
PostgresConf Organizers Thursday Lunch

presented by PostgresConf Organizers

The Thursday Lunch in the Almaden

12:00 - 13:00 Almaden Ballroom, Main Level
Lee Roland 3 Techniques to Improve Postgres Response Times without Code Changes
Improve Performance via SQL Offload

presented by Lee Roland

In this session, we will discuss ways to offload SQL for low latency; all without code changes. We will discuss how database proxies (commercial and open-source) can intelligently cache, split and route queries for optimal Postgres performance and scale. During the presentation, it will be an interactive discussion with Q&A. Come join us.

13:00 - 13:50 San Pedro, Lvl C Dev
 Kannan Muthukkaruppan Evolution of Transactional Databases
SV PGConf 2023

presented by Kannan Muthukkaruppan

Over 150 different relational databases are currently ranked by DB-Engines. With so many options, no wonder picking the “right” database for your new app is challenging.

How do you know which new databases to consider, and how can you evaluate which historical database features—from INGRES to Oracle to NoSQL and beyond—are right for this modern cloud native world?

Join legendary Oracl...


13:00 - 13:50 Almaden Ballroom, Main Level Yugabyte DSS
Jorge Torres PostgreSQL and NLP: How to build an ChatGPT application in minutes

presented by Jorge Torres

In this session you will learn how to build a full stack NLP machine learning application that incorporates the latest classifier, translator, and Chat-GPT functions - all with standard SQL commands, how to operate these applications in production environments leveraging MindsDB & PostgreSQL, and how to transfer this knowledge to applications of your own.

13:00 - 13:20 Winchester, Main Level Dev
Brian Hodge Understanding Transaction Isolation and Serializability

presented by Brian Hodge

Transaction isolation is a part of database development that I often found intimidating and inaccessible, and therefore avoided. The barrier to entry seemed too high, and the default configurations seemed “good enough”.

Often, that’s true! However, any database developer who cares about the correctness and performance of their code will eventually need to understand isolation levels, their t...


13:00 - 13:50 Santa Clara, Lvl C Ops
Eric Lendvai Data Architecture and Modeling with DataWharf

presented by Eric Lendvai

Quick review of Data Architecture and Data Modeling theories. Introduction to DataWharf, an open-source data modeling web based tool. Even though DataWharf can handle multiple database backends, it was developed using PostgreSQL and is aware of most PostgreSQL features. DataWharf can be deployed on any web server and platform supporting FastCGI, or simply using Docker. DataWharf was designe...


13:30 - 13:50 Winchester, Main Level Dev
Michael Potter Migrating Mainframe/VSAM applications to Linux/Postgres
Moving IBM COBOL/VSAM applications from the mainframe to Linux/Postgres without changing code

presented by Michael Potter

We will demonstrate a IBM COBOL/CICS/VSAM application running on Linux/Postgres and do a detailed discussion on how VSAM is mapped to Postgres tables. We will also discuss how this is done without changing the COBOL source code.

[Speaker Notes: We could just do the demo and make this a 20 minute presentation. It is not likely that your normal attendees will be interested in this presentati...


14:10 - 15:00 Santa Clara, Lvl C Data
Jignesh Shah Taking anxiety out of PostgreSQL upgrades in Amazon RDS

presented by Jignesh Shah

Upgrading databases can be a painful process that is time consuming and require significant coordination or even downtime. However, upgrades are important because they enhance your database with the latest security patches, performance features, and more. In this session, we will discuss how PostgreSQL upgrades happen in Amazon RDS and the best strategies to plan for your next upgrade. We will ...


14:10 - 15:00 Winchester, Main Level AWS RDS and Aurora
Adam Hendel Postgres Extension Lifecycle

presented by Adam Hendel

Let’s walk through the lifecycle of a Postgres extension using pgx and trunk. The trunk toolkit abstracts away many complexities in extension development and installation, making the process more accessible to developers and users.

14:10 - 15:00 San Pedro, Lvl C Ops
Denis Magda Weathering the Cloud Storm: PostgreSQL High Availability Options

presented by Denis Magda

As the demand for reliable and continuous data access intensifies, it's important to understand the high availability (HA) options for PostgreSQL deployments in the cloud.

In this talk, we'll examine essential PostgreSQL HA solutions, including traditional techniques like streaming and logical replication, as well as the latest cloud-based approaches. Join us as we tolerate the storms in the...


14:10 - 15:00 Almaden Ballroom, Main Level Yugabyte DSS
Michael Meskes Open Source in the Age of Cloud and Microservices

presented by Michael Meskes

The movement to cloud and microservice architectures have changed the industry quite a bit recently. These changes have an influence on open source both from a community and from a business perspective.

This presentation takes you on a journey of 30+ years of free and open-source software development. It shows the evolution of the movement and the ecosystem. With changes in business models o...


15:20 - 15:40 San Pedro, Lvl C Dev
 Mehboob Alam Torturing Postgres: autonomous testing for distributed architectures
The Future of Postgres is Distributed. Let's Break Postgres at Scale!

presented by Mehboob Alam

Torturing Postgres: extreme autonomous testing for distributed architectures

After 40 years of development, the path is clear. Multi-core architecture and multi-node deployment is key to future scalability and adoption of cloud-native architecture is imperative to keeping Postgres competitive and relevant to the next generation of startups and enterprise needs.

Traditional Postgres testin...


15:20 - 15:40 Winchester, Main Level Dev
Chris Sean Simplifying Data Replication with PostgreSQL
Efficient and Scalable Data Replication with PostgreSQL Made Easy

presented by Chris Sean

Replicating data from various sources into a central database is an important part of managing and making sense of large amounts of data in any organization. However, setting up data replication pipelines can be complex and often requires specialized knowledge.

This session will demystify data replication with PostgreSQL and provide you with the knowledge and tools to set up scalable data re...


15:20 - 16:10 Santa Clara, Lvl C Data
Karthik Ranganathan Future of Distributed SQL: 3 Things I’m Most Excited About

presented by Karthik Ranganathan

Join Yugabyte CTO and co-founder, Karthik Ranganathan, for a quick talk on his vision for the future of Distributed SQL. As one of the original creators of Cassandra at Facebook, he’s seen massive changes in the database landscape. In this session, we’ll hear from him on three specific areas of innovations that he believes are some of the most exciting things happening in the database space, ...


15:20 - 15:40 Almaden Ballroom, Main Level Yugabyte DSS
Jignesh Shah Developing PostgreSQL extensions using Trusted Language Extensions

presented by Jignesh Shah

In this session we will look at examples building your own custom PostgreSQL extensions using the new Trusted Language Extensions and deploy it in a cloud environment. Trusted Language Extensions for PostgreSQL is an open source development kit for building PostgreSQL extensions. It allows you to use multiple languages to build high performance PostgreSQL extensions and even safely run them on ...


15:50 - 16:40 San Pedro, Lvl C Dev
Seth Luersen YSQL Development for PostgreSQL Developers

presented by Seth Luersen

Dive into the robust features of Yugabyte Structured Query Language (YSQL), from PostgreSQL compatibility to row-level geo-partitioning, in this hands-on, BYOL session.

You'll begin by learning how YSQL is a fully-relational API with a high degree of PostgreSQL compatibility. Then, you will discover how YSQL supports both Data Definition Language (DDL) and Data Manipulation Language (DML)...


15:50 - 16:40 Almaden Ballroom, Main Level Yugabyte DSS
Chris Riggin Architecting for High Availability and Disaster Recovery with Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL

presented by Chris Riggin

This talk covers high availability and failover support in RDS PostgreSQL and Aurora PostgreSQL with Multi-AZ deployments and discuss options to plan disaster recovery setup in secondary AWS regions.

15:50 - 16:10 Winchester, Main Level AWS RDS and Aurora
Wanda  He Choosing the right storage for your RDS for PostgreSQL database

presented by Wanda He

Ensuring your database is using the right storage is important not only for optimizing costs, but also your performance. With three different storage types on Amazon RDS for PostgreSQL, you can tailor your storage depending on the needs of your database. In this session, we will talk about these different storage options, compare costs, dive into the performance dimensions for each type, and wa...


16:20 - 16:40 Winchester, Main Level AWS RDS and Aurora
Jan Wieck As the Inventor of Slony-I, I present to you Spock
Multi-Active Logical Replication for PostgreSQL

presented by Jan Wieck

Full support of multi-active logical replication in pgLogical has gone unsupported for many years. In this talk we will discuss the work we have done to bring back multi-active replication in a new derivative of pgLogical we call Spock. Spock is available as an open source PostgreSQL extension under a community open source license.

High performance web applications increasingly need present...


16:20 - 16:40 Santa Clara, Lvl C Data
Dana Van Aken The Machines Haven't Taken Over Yet: Incorporating Domain Knowledge into ML-driven Database Tuning Tools
by Dana Van Aken

presented by Dana Van Aken

Database management systems (DBMSs) expose dozens of configurable knobs that control their runtime behavior. Correctly tuning these knobs can improve the performance and efficiency of the DBMS. But it's a difficult task for humans as it requires understanding the complex and high-dimensional relationship between the database configuration, workload, environment, and performance. This problem ha...


16:50 - 17:40 Santa Clara, Lvl C Data
Denis Magda Distributed SQL Databases: The Whys and Hows

presented by Denis Magda

Combine the popular SQL interface and the strong consistency of relational databases with the horizontal scalability of NoSQL data stores. You’ll get a distributed SQL database, a relatively new category of relational DBs.

This talk introduces you to the whys and hows of distributed SQL.

First, we’ll find out why the world needs yet another database category. Next, using YugabyteDB as an ...


16:50 - 17:10 Almaden Ballroom, Main Level Yugabyte DSS
Luigi Nardi DBtune: Database tuning software as a service

presented by Luigi Nardi

Database management systems expose configurable parameters that control their runtime behavior. The general trend is that over the years, new parameters are added in each new system release, resulting in an explosion of parameters, e.g., PostgreSQL has hundreds of free parameters to date. Setting these parameters correctly improves the performance of an application and saves substantial cloud r...


16:50 - 17:10 San Pedro, Lvl C Ops
Ryan Booz 10 Things I Learned Solving Advent of Code Puzzles with PostgreSQL
Using the power of PostgreSQL to investigate complex data

presented by Ryan Booz

Since December 2015, Eric Wastl has been creating 25 daily coding puzzles each year known as The Advent of Code. In 2022, more than 250,000 developers from around the world worked each day to solve the challenges in a language of their choice, including some members of the PostgreSQL community. I decided to join them, knowing it would challenge my skills, knowledge, and understanding of the dat...


16:50 - 17:40 Winchester, Main Level Dev
Dave Stokes PostgreSQL High Availability: The Considerations and the Candidates
Better performance can be yours

presented by Dave Stokes

Almost every organization that I interact with wants a high availability system for PostgreSQL. This clearly depicts an active trend toward an increase in utilizing PostgreSQL for critical business applications. In some cases, it is a move away from other major database systems like Oracle or even Teradata. We are going to define the basic criteria for a high availability system, and have a qui...


17:20 - 17:40 San Pedro, Lvl C Ops
PostgresConf Organizers PostgresConf SV: Welcome Reception
Hosted by: Yugabyte

presented by PostgresConf Organizers

Welcome reception on 4/20 at 6:00PM in the Almaden room

18:00 - 20:00 Almaden Ballroom, Main Level
Dave Stokes MERGE() - A Quick Introduction
Unleash the Power of SQL with one new function!

presented by Dave Stokes

MERGE() is a powerful function for processing data like transaction logs. It is powerful as it allows you to insert, update, or delete data in one statement instead of using an application that requires numerous round trips between the server and the application to do the same tasks (which is much more resource and time intensive). However, this is not an easy function to learn from reading the...


09:30 - 09:50 Almaden Ballroom, Main Level Data
Bryn Llewellyn How to configure a PostgreSQL cluster for multitenancy

presented by Bryn Llewellyn

A multitenancy scheme for Postgres must allow many application backends to be co-installed in a single cluster so that each is securely isolated from every other one. (The term "application backend" is used to denote the complete set of artifacts that jointly implement an application's RDBMS functionality: schemas, schema-objects of all kinds, and the roles that own these.) It must be possible ...


09:30 - 11:00 Santa Clara, Lvl C Dev
Jose Finotto Full Stack Postgres on Kubernetes with StackGres
How to admin a full stack solution for Postgres on Kubernetes with StackGres

presented by Jose Finotto

The default Production PostgreSQL is not really batteries included: you need to supplement "core" Postgres with high availability, connection pooling, backups, monitoring and others. You need a Full Stack Postgres for production workloads.

If you run on the cloud, all of this is (should be) provided. But what if you are looking for alternatives and want to self-host? Obviously, you can do it...


09:30 - 09:50 San Pedro, Lvl C Ops
John Russell Dustin Brown All roads lead to Amazon Aurora

presented by John Russell and Dustin Brown

The Amazon Aurora database combines aspects of SQL compatibility with the open-source PostgreSQL database, a managed service, and an architecture that separates compute and storage. Using Aurora can involve learning and activities for any or all of these aspects. This session explores three pathways for getting started on Aurora: 1) Migrating the database schema and data and porting database ap...


09:30 - 10:20 Winchester, Main Level AWS RDS and Aurora
Aaron Cutshall SEAL Team Six
How to Build Effective Teams

presented by Aaron Cutshall

Teamwork is essential in all areas of our work life, including how we interact with other teams daily. Lessons learned from highly effective teams, such as SEAL Team Six, show six significant impacts on effectiveness: • Chain of Command • Team Cohesion • Standard Operating Procedures • Training • Mission Objectives • After-Action Analysis

Failure in any of these areas can impact ...


10:00 - 11:30 San Pedro, Lvl C Ops
CJ Estel Archiving Data
A playbook to help you get started

presented by CJ Estel

Join CJ Estel as he takes you down the path of how he uses pg_partman paired with some other scripts to automate partition and archival management. Learn how to work around foreign key constraints, table locks in converting large tables to partitioned tables in a production environment, and how partitions can complement your archival strategy. You will leave this session with a list of question...


10:00 - 10:50 Almaden Ballroom, Main Level Data
Chirag Dave Deploying Amazon RDS database for applications in Kubernetes

presented by Chirag Dave

Kubernetes is a portable, extensible, open-source platform for managing containerized workloads and services. Using the AWS Controller for Kubernetes (ACK) interface, you are able use AWS services directly from Kubernetes. In this session, we will talk about why you would want to use ACK for Amazon RDS, show you how you can use the ACK service controller for Amazon RDS to provision and manage d...


10:30 - 11:20 Winchester, Main Level AWS RDS and Aurora
Marcos Figueiredo Enabling Secure and Scalable Open-Source in Finance
Enabling Secure and Scalable Open-Source in Finance

presented by Marcos Figueiredo

The 2022 Red Hat ‘The State of Enterprise Open source’ report has found while the number of enterprises using proprietary software is expected to decline over the next two years, open-source software is increasingly being embraced.

The once perceived barriers to migrating to an open-source solution, such as apprehensions about compatibility, availability of support, lack of internal skills t...


11:00 - 11:20 Almaden Ballroom, Main Level Data
Haonan Wang Efficient PostgreSQL Query Writing: Avoiding Common Anti-Patterns and ORM Pitfalls

presented by Haonan Wang

As PostgreSQL continues to grow in popularity, it's important for developers to write efficient queries that can handle large amounts of data without sacrificing performance. In this talk, we'll explore some of the most common anti-patterns in query writing and discuss how to avoid them when working with PostgreSQL. Additionally, we'll focus on how using an ORM to develop applications, specific...


11:10 - 11:30 Santa Clara, Lvl C Dev
Tatiana Krupenya Let robots help with queries
Answers to the most popular questions about AI for database querying.

presented by Tatiana Krupenya

AI is one of the most popular topics these days. With this technology, you can write texts, draw pictures, and create music. And, of course, you can write queries to your database with ChatGPT-3.

Recently, we integrated this technology with DBeaver. The feature got good feedback from the open-source community and enterprises. We will be glad to answer the most frequent questions that we obt...


11:40 - 12:30 Almaden Ballroom, Main Level Data
Brian Hodge Improving the Ergonomics of Writing SQL

presented by Brian Hodge

Whether we like it or not, the SQL language is here to stay. And there are lots of things to love about SQL! But it’s also undeniable that, as a language, it is often verbose, inexpressive, and difficult to maintain.

To address those issues, we write style guides, build linters, and conduct code reviews. Those approaches all focus on the end result, but this talk is about the process of de...


11:40 - 12:30 Santa Clara, Lvl C Dev
Sivasamy Subramaniam Top 10 Tips for migrating to Amazon Aurora and Amazon RDS

presented by Sivasamy Subramaniam

Getting ready to migrate your workloads to a new database can seem like a daunting task. However, at AWS, we offer a number of tools and capabilities that simplify this process. In this session, we will discuss our top 10 tips and best practices for migrating your workloads to Amazon Aurora PostgreSQL Compatible Edition and Amazon RDS for PostgreSQL to make the process safer and faster.

11:40 - 12:30 Winchester, Main Level AWS RDS and Aurora
Bohan Zhang The Part of PostgreSQL I Hate the Most
what are the drawbacks of MVCC in Postgres and how to optimize it

presented by Bohan Zhang

Postgres is awesome. It is currently the fourth most popular database (source: DB-Engines), and its popularity continues to grow as strong as ever due to several factors: its rich set of features, mixing object storage and relational capabilities; its extensibility; and its status as an open source project. But as much as we love PostgreSQL, there are certain aspects about it that are not that ...


11:40 - 12:00 San Pedro, Lvl C Ops
Julian Fischer 10 Years of Automating Postgres
A recap.

presented by Julian Fischer

In this talk Julian Fischer will share lessons learned from automating PostgreSQL for more than a decade. Hear about the journey from shell scripts, Chef to BOSH as well as Kubernetes. You will learn about the evolution of data center virtualization and its relation to the paradigm shift from imperative to declarative management. See how infrastructure and operating system independent Postgres ...


12:10 - 12:30 San Pedro, Lvl C Ops
PostgresConf Organizers Friday Lunch

presented by PostgresConf Organizers

The Friday lunch in the Almaden

12:30 - 13:30 Almaden Ballroom, Main Level
Aaron Cutshall Discover the Power of Window Functions

presented by Aaron Cutshall

Window functions have nothing to do with the Windows operating system but provide a "window" in a data set when used in SQL queries. They are powerful, set-based methods to view data in unexpected ways. Window functions provide easy, set-based solutions to solve some common problems: - Using running totals - Performing operations on intervals - Identifying data gaps and islands - Performing...


13:30 - 14:20 Santa Clara, Lvl C Dev
Chandra Pathivada Ramesh Kumar Venkatraman Running PostgreSQL on AWS for SQL Server DBAs
Leverage your SQL expertise to learn and manage PostgreSQL on AWS Cloud

presented by Chandra Pathivada and Ramesh Kumar Venkatraman

If you are a SQL Server DBA, switching to PostgreSQL may seem like a difficult task. In this workshop, we will show you how to leverage your SQL Server expertise to run in Aurora PostgreSQL Compatible Edition and RDS for PostgreSQL. In this workshop session, learn the ins and outs of PostgreSQL administration and tips for migrating your workloads to AWS.

13:30 - 15:00 Winchester, Main Level AWS RDS and Aurora
Manish Pratap Singh Jeremy Launier Make Postgres Simple, Reliable, and Cost-Effective with Nutanix Database Service

presented by Manish Pratap Singh and Jeremy Launier

PostgreSQL is the open-source relational database of choice for developers building modern, cloud-native apps. But deploying and managing PostgreSQL can be complex, time-intensive, and fraught with risk. In this session, learn how Nutanix Database Service, the only hybrid multicloud Database-as-a-Service, enables reliable, secure, and cost-effective PostgreSQL operations at scale while deliveri...


13:30 - 14:20 Almaden Ballroom, Main Level Ops
Zak Tedder Citus: Orange You Glad It's Postgres
An Introduction to Postgres

presented by Zak Tedder

Are your queries getting slower, and slower? Well, now you can increase memory, CPU, disk I/O, and storage by scaling out instead of up! Citus is a Postgres extension that provides turn-key database distribution so your database can outgrow the confines of a single-machine instance. Learn the basics on how to install, configure, and execute a Citus cluster.

13:30 - 14:20 San Pedro, Lvl C Ops
Scott Bellware Message Stores and Event Sourcing with Message DB

presented by Scott Bellware

Message DB is a pure-Postgres, open source implementation of the most commonly-used features of dedicated event store technologies like Kafka or EventStoreDB, but with a fraction of the operational burden. If your systems are already well-served by PostgreSQL, then Message DB is an ideal choice for your message-based or event-sourced development needs. Far easier to install and run on both deve...


14:40 - 15:30 Santa Clara, Lvl C Dev
Srinivasa  Inaganti Postgres for Oracle DBAs - A Comparison Study
Comparing backup recovery and other Ops procedures

presented by Srinivasa Inaganti

This talk will be of interest to Oracle DBAs who are supporting or transitioning to PostgreSQL. In this talk, we will include live comparison demos, including:

  • Shutdown and startup modes
  • Script execution methods
  • Alert log Vs Postgres log
  • Pgdump Vs Datapump
  • Pgbackrest Vs RMAN
  • Monitoring using pg_stat_activity and other methods
  • And more

In total we will cover at least 2...


14:40 - 15:30 Almaden Ballroom, Main Level Ops
Grant McAlister Full Page Writes in PostgreSQL - Critical, Evil or Both - Why you should care and how to optimize

presented by Grant McAlister

The first portion of the session will cover the critical reason why PostgreSQL generates these full page writes (FPW) and how to monitor the rate of generation. Next we will demonstrate the negative effect of full page writes on performance, scale, backups and replication. Then we will cover various techniques to decrease the amount of full page writes and improve your databases performance/sca...


14:40 - 15:30 San Pedro, Lvl C Ops
Chandra Pathivada Ramesh Kumar Venkatraman Optimize Costs using Babelfish for Aurora PostgreSQL
Run Microsoft SQL Server applications on PostgreSQL with little to no code change

presented by Chandra Pathivada and Ramesh Kumar Venkatraman

Babelfish for PostgreSQL is an open-source project and feature of Amazon Aurora available under the Apache 2.0 and PostgreSQL licenses. It provides the capability for PostgreSQL to understand queries from applications written for Microsoft SQL Server. In this session, learn how you can optimize your licensing and maintenance costs by migrating with Babelfish for Aurora PostgreSQL without rewrit...


15:10 - 15:30 Winchester, Main Level AWS RDS and Aurora
Vadim Tkachenko Building a Serverless PostgreSQL with Neon Tech OpenSource and Percona Builds
During the talk, I will provide an overview of the architecture, the benefits of using Neon Tech OpenSource and Percona Builds, and a step-by-step guide on how to build your serverless PostgreSQL.

presented by Vadim Tkachenko

In this talk, I will present a comprehensive guide on building a serverless PostgreSQL using your own resources without dependencies on cloud providers. This solution leverages the power of Neon Tech OpenSource and Percona Builds to provide a seamless and efficient experience for developers looking to scale their PostgreSQL database.

By dividing the compute nodes and storage nodes, this solu...


15:50 - 16:40 San Pedro, Lvl C Ops
Kesiena Owho-Ovuakporie Features for Scalable PostgreSQL in Cloud Spanner

presented by Kesiena Owho-Ovuakporie

Cloud Spanner launched a PostgreSQL interface in 2022 with the goals of improving developer familiarity and application portability. A primary objective of our implementation was to provide Spanner's full scalability and fault tolerance capabilities. This proved challenging because Spanner's architecture is purpose-built for hyper scale, geo-distributed data and clients, and fully managed clou...


15:50 - 16:10 Santa Clara, Lvl C Dev
Chirag Dave Improving the security of your PostgreSQL databases using Amazon Aurora and Amazon RDS

presented by Chirag Dave

At AWS, we like to say that security is always job #1. Since Amazon Aurora and Amazon RDS are fully managed, AWS takes care of key security tasks like patching, isolation and security, and more. Furthermore, you have access to additional features that ensure your data is securely stored and accessed. In this session, you will get an introduction to the AWS Shared Responsibility Model, our key s...


15:50 - 16:40 Winchester, Main Level AWS RDS and Aurora
Peter Farkas Moving MongoDB Workloads to Postgres with FerretDB
The Quest to Migrate MongoDB Workloads Back to Open Source Using 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 ...


15:50 - 16:40 Almaden Ballroom, Main Level Ops
Grant Zhou Serverless Postgres Study and Practice
Discussing the concept of serverless computing and the Neon serverless open source solution

presented by Grant Zhou

In this talk, I will be discussing the concept of serverless computing and how it's changing the way we develop applications. We will dive into serverless applications, including an introduction to Neon and its architecture. I will walk you through how Neon is implemented using code and demonstrate a few use cases. By the end of this talk, you will have a better understanding of serverless comp...


16:20 - 16:40 Santa Clara, Lvl C Dev