Silicon Valley 2023 Program
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...more 10:00 - 10:20 Almaden Ballroom, Main Level Ops
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:30 - 10:50 Almaden Ballroom, Main Level Ops
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, ...more 11:00 - 11:20 Almaden Ballroom, Main Level Yugabyte DSS
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...more 11:30 - 11:50 Almaden Ballroom, Main Level Dev
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 ...more 13:00 - 13:50 Santa Clara, Lvl C Ops
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 Carlos, Lvl C Dev
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...more 13:00 - 13:50 Almaden Ballroom, Main Level Yugabyte DSS
presented by David Martin
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
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...more 13:30 - 13:50 Winchester, Main Level Dev
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 ...more 14:10 - 15:00 Winchester, Main Level AWS RDS and Aurora
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...more 14:10 - 15:00 Almaden Ballroom, Main Level Yugabyte DSS
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...more 14:10 - 15:00 Santa Clara, Lvl C Data
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 Carlos, Lvl C Ops
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 ...more 15:20 - 15:40 Winchester, Main Level Ops
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...more 15:20 - 16:10 Santa Clara, Lvl C Data
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...more 15:20 - 15:40 San Carlos, Lvl C Dev
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
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)...more 15:50 - 16:40 Almaden Ballroom, Main Level Yugabyte DSS
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 ...more 15:50 - 16:40 San Carlos, Lvl C Dev
presented by Wanda He
This section goes over storage options to run RDS for PostgreSQL, compares cost, performance dimensions each storage type, and walks through use cases of choosing the right storage.16:20 - 16:40 Winchester, Main Level AWS RDS and Aurora
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...more 16:20 - 16:40 Santa Clara, Lvl C Data
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...more 16:50 - 17:40 Winchester, Main Level Dev
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.16:50 - 17:40 San Carlos, Lvl C Ops
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 ...more 16:50 - 17:10 Almaden Ballroom, Main Level Yugabyte DSS
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...more 16:50 - 17:40 Santa Clara, Lvl C Data
How to execute major upgrades without impact the availability of the database cluster
presented by Jose Finotto
This talk aims to present the approach to execute a significant upgrade of PostgreSQL with a use case where the database is under a load of thousands of queries per second, and we could achieve this operation without bringing downtime to the database.
The proposal is not using any third-party component, we are just using our resources from the PostgreSQL open-source ecosystem. We will brains...more 09:30 - 09:50 San Carlos, Lvl C Ops
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...more 09:30 - 09:50 Almaden Ballroom, Main Level Data
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...more 09:30 - 10:20 Winchester, Main Level AWS RDS and Aurora
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 ...more 09:30 - 11:00 Santa Clara, Lvl C Dev
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...more 10:00 - 10:50 Almaden Ballroom, Main Level Data
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 ...more 10:00 - 11:30 San Carlos, Lvl C Ops
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...more 10:30 - 11:20 Winchester, Main Level AWS RDS and Aurora
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...more 11:00 - 11:20 Almaden Ballroom, Main Level Data
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...more 11:10 - 11:30 Santa Clara, Lvl C Dev
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...more 11:40 - 12:30 Santa Clara, Lvl C Dev
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
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 ...more 11:40 - 12:00 San Carlos, Lvl C Ops
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...more 11:40 - 12:30 Almaden Ballroom, Main Level Data
presented by Mehboob Alam
Testing methodologies w/ Antithesis12:10 - 12:30 San Carlos, Lvl C Dev
Leverage your SQL expertise to learn and manage PostgreSQL on AWS Cloud
presented by Chandra Pathivada, 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
Improving data integration between PostgreSQL platforms
presented by Bobby curtis
With the growth of cloud platforms and the shift to open-source database solutions, there is still the need for data integration between platforms. As organizations continue to shift to open-source solutions, the data movement will be as critical today and into the future. After many years of Oracle denying apply operations to PostgreSQL, Oracle introduced apply processes for PostgreSQL in late...more 13:30 - 14:20 San Carlos, Lvl C Ops
presented by Sam Welden
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...more 13:30 - 14:20 Almaden Ballroom, Main Level Ops
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...more 13:30 - 14:20 Santa Clara, Lvl C Dev
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...more 14:40 - 15:30 San Carlos, Lvl C Ops
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...more 14:40 - 15:30 Santa Clara, Lvl C Dev
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...more 14:40 - 15:30 Almaden Ballroom, Main Level Ops
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...more 15:10 - 15:30 Winchester, Main Level AWS RDS and Aurora
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...more 15:50 - 16:40 Winchester, Main Level AWS RDS and Aurora
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 ...more 15:50 - 16:40 Almaden Ballroom, Main Level Ops
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 Peter Zaitsev
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...more 15:50 - 16:40 San Carlos, Lvl C Ops
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...more 15:50 - 16:10 Santa Clara, Lvl C Dev
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...more 16:20 - 16:40 Santa Clara, Lvl C Dev