Silicon Valley 2023 Program

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

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.

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.

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

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.

presented by PostgresConf Organizers

The Thursday Lunch in the Almaden

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.

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

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.

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

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

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

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

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.

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

presented by PostgresConf Organizers

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

presented by PostgresConf Organizers

The Friday lunch in the Almaden

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

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.

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

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.

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

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

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

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

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

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

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

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

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