Silicon Valley 2022 Program

 Andres Arrieta Digital Rights and Privacy: Concerns for the 21st century

presented by Andres Arrieta

The Electronic Frontier Foundation has been protecting and fighting for our civil liberties for over 30 years. In those 30 years a lot has happened: Our relationship to the internet has fundamentally changed, and yet, in many ways, our understanding of how it works has remained stagnant.

30 years ago, the Internet was a mystical place of wizardry with many unknowns, and a realm which was di...


09:40 - 10:00 Ballroom Data
Chad Berkley Managing growth and career development for software companies
Organizational and career growth observations in fast-growing companies and markets

presented by Chad Berkley

PostgreSQL is currently the fourth most popular RDBMS (behind SQL Server, MySQL and Oracle) with usage growing faster than any other relational database (source: DB-Engines). This indicates a strong and growing community, backed by many companies that have placed their bet that PostgreSQL will drive growth for years to come. With this growth comes the challenges of building an engineering org...


10:10 - 10:30 Ballroom Dev
Nitish Korla Postgres: Through the lens of Cloud Platform

presented by Nitish Korla

We will discuss the general trends around Postgres adoption in the cloud platform, and key challenges and opportunities being faced on that front. The keynote will also share some insights around what the anticipated accelerated cloud adoption in future means to the wider Postgres OSS community, and how Google can potentially help on that front.

10:40 - 11:00 Ballroom Data
Kirk Roybal PostgreSQL and Managed Hosting Services

presented by Kirk Roybal

This session will peel back the curtain on PostgreSQL managed hosting services. It will show you what the vendors don't say during the sales pitch, what the disadvantages of managed services are, and how they limit your deployment and response times. We will discuss the ramifications of the decisions to limit your services, and get a quick peek at what you can do about it.

11:10 - 11:30 Ballroom Ops
Alexandra Elchinoff Karthik Ranganathan The Biography of a Modern Cloud Native Application
Told from the perspective of data

presented by Alexandra Elchinoff and Karthik Ranganathan

Modern cloud native applications lead exciting lives - from their birth in the cloud and dealing with massive unplanned success to surviving cloud outages and handling customers worldwide. In this talk, Yugabyte CTO Karthik Ranganathan walks through the eventful life of a successful cloud native app, as seen from the perspective of the data layer.

11:40 - 12:00 Ballroom Yugabyte Distributed SQL Summit
PostgresConf Organizers Thursday Lunch

presented by PostgresConf Organizers

Thursday Lunch

12:00 - 13:00 Ballroom
Alexandra Elchinoff Denis Magda Lessons Learned: Moving a PostgreSQL Application From On-Premise to a Cloud Native Architecture

presented by Alexandra Elchinoff and Denis Magda

Join this swift demo-driven session where Denis migrates a contemporary e-commerce application from an on-premise architecture to a highly available cloud native solution. In a matter of 20 minutes, you'll witness and learn: - How much effort should you put into upgrading from a single-server Postgres instance to cloud native YugabyteDB cluster. - How to make the API and backend layers highly...


13:00 - 13:20 Ballroom Yugabyte Distributed SQL Summit
Mehboob Alam Everett Berry TDE: State of Encryption in Postgres
A Guide to Transparent Data Encryption in PostgreSQL

presented by Mehboob Alam and Everett Berry

As a Postgres client targeting enteprises, Arctype is very interested in how the community can secure sensitive data to the highest standard. Transparent Data Encryption is a standard feature in Oracle and Microsoft databases, and it's long Postgres development timeline is preventing some enterprises from switching. This talk will start with a discussion of what security and compliance standard...


13:00 - 13:50 Winchester Data
Amit Kapila Past, Present, and Future of Logical Replication

presented by Amit Kapila

In this talk, I will tell how the Logical Replication has been evolved over years in PostgreSQL. This will explain some of the major recent enhancements like facilitating logical replication of two-phase and large in-progress transactions.

I will share my views on how this technology can be leveraged to build a highly scalable and available database solution for large Enterprises. After that...


13:00 - 13:50 Santa Clara Dev
Alexandra Elchinoff Mihnea Iancu Driving 150K warehouses on TPC-C

presented by Alexandra Elchinoff and Mihnea Iancu

In the world of cloud native applications, databases need to perform even at massive scale. Come learn how Yugabyte successfully scaled the TPC-C to 150,000 warehouses on a single distributed SQL cluster! Mihnea Iancu from the Yugabyte Engineering team will discuss the results and provide insights into the product improvements made to get there—and beyond!

13:30 - 13:50 Ballroom Yugabyte Distributed SQL Summit
Lee Roland Scaling Beyond PgBouncer & Pgpool-II: Advanced Traffic Management
Survey of Database Proxies

presented by Lee Roland

Database proxies manage connections to improve performance and scale. In this session, we will highlight deficiencies of open-source Pg-bouncer and Pg-Pool-II that users should know, and propose solutions. Features to be discussed include:

 - Connection pooling
 - Read/write split with Strong Consistency
 - Query caching
 - Persisted connection, automated Postgres failover...

14:00 - 14:20 Winchester Ops
Alexandra Elchinoff Amit Chauhan Demo Hour
YugabyteDB in Action!

presented by Alexandra Elchinoff and Amit Chauhan

Join us for a fast-paced, straight-talk, zero-filler show and tell by Yugabyte’s Field Engineers. This demo hour session features two awesome back-to-back demos.

Demo 1: Architecting Resilient, Geo-distributed Stateful Apps Experience the joy of seeing a resilient and failure-resistant Yugabyte database in action. In this demo, we'll see how with a few clicks, Yugabyte database is confi...


14:00 - 14:50 Ballroom Yugabyte Distributed SQL Summit
Pavlo Golub When it all GOes right
How to write cross-platform application for PostgreSQL

presented by Pavlo Golub

This talk covers how to use PostgreSQL together with the Golang (Go) programming language. I will describe what drivers and tools are available and which to use nowadays.

In this talk I will cover what design choices of Go can help you to build robust programs. But also, we will reveal some parts of the language and drivers that can cause obstacles and what routines to apply to avoid risk...


14:00 - 14:50 Santa Clara Dev
Avinash Vallarapu Are databases on cloud DBaaS platforms really faster and cheaper as they are claimed ?
Problems with scalability while migrating to PostgreSQL on DBaaS

presented by Avinash Vallarapu

  • It is a known fact that Cloud vendors attract a lot of migrations to PostgreSQL. Managed infrastructure, database migration tools combined with zero software license are the strongest reasons for increased migrations to cloud. However, cloud vendors may promote their DBaaS platforms much more than their capabilities with scalability. Customers may not be aware of some technical limitations th...

14:30 - 15:20 Winchester Ops
Alexandra Elchinoff Yogesh Mahajan Analyzing PostgreSQL Compatibility: Amazon Aurora, Spanner, YugabyteDB and CockroachDB

presented by Alexandra Elchinoff and Yogesh Mahajan

Join Yugabyte Sr. Director Product Management, Yogesh Mahajan, for a discussion of key criteria that you can use to evaluate PostgreSQL compatibility in databases. We will apply this comparison framework to analyze four distributed SQL databases: Google Spanner, Amazon Aurora, CockroachDB, and YugabyteDB.

Compatibility with a widely-adopted SQL API is no longer an option for distributed SQL ...


15:00 - 15:20 Ballroom Yugabyte Distributed SQL Summit
Ivan Novick Jacque Istok Scaling PostgreSQL to New Heights
Solving operational complexity at scale with VMware Greenplum

presented by Ivan Novick and Jacque Istok

PostgreSQL hits scalability limits when reaching terabyte scale. To solve this, engineers resort to data sharding. However, when sharding data, then re-assembling the data and joining data between PostgreSQL instances becomes a bottleneck. As the number of shards, or number of postgres instances continues to grow, operational complexity and performance get incrementally difficult to manage....


15:00 - 15:20 Santa Clara Data
Ian Pytlarz Protect Purdue: Data Driven University Operations in a Pandemic
Using Greenplum and Postgres to deliver in-person instruction during COVID

presented by Ian Pytlarz

The COVID Pandemic was an unprecedented challenge for universities across the world. How could operations continue in person without unacceptable risk of life and illness? Purdue decided to pursue methods of safe in-person education shortly after lockdowns began in March. The ability to open safely was achieved in large part through data-driven decision making. Executives and the medical team r...


15:40 - 16:30 Santa Clara Data
Pavlo Golub Professional PostgreSQL scheduling made easy
How to run cron jobs on steroids

presented by Pavlo Golub

The talk firstly introduces all appropriate levels of database scheduling and then focuses on PostgreSQL and the means it provides. The talk explains the meaning and importance of key approaches. Postgres community has already developed several tools in that area. Some popular common options (pg_cron, pgAgent, etc.) will be highlighted together with the problems that different scheduling approa...


15:40 - 16:30 Winchester Ops
Alexandra Elchinoff The Scalable, Resilient Data Layer at the Heart of Modern Retail

presented by Alexandra Elchinoff

Retail organizations are embracing a data model-first approach to application modernization in order to deliver better customer experiences, boost profitability and increase responsiveness. Yugabyte VP of Solutions Suda Srinivasan talks to retail industry veteran and data engineering leader Richie Bachala about how innovative retail and retail tech organizations are redesigning the data archite...


15:40 - 16:00 Ballroom Yugabyte Distributed SQL Summit
Bruce Momjian Fireside chat: Building Postgres w/Bruce Momjian & Greg Kemnitz
Building the original Postgres code-base at Berkeley

presented by Bruce Momjian

<placeholder> * The early Postgres years at Berkeley * Database design challenges * Database industry trends

16:10 - 16:30 Ballroom Dev
An Open Source Oracle-compatible Database Based on PostgreSQL

presented by GRANT ZHOU

There are many users who need to migrate their applications from Oracle to the open source Postgres, but in order to support the new database, users often need to re-develop the application, which is inconvenient. If there is a database based on Postgres and compatible with most Oracle syntax and functions, it will be too convenient for customers. However, the official Postgres project will no...


16:40 - 17:00 Ballroom Data
Wojciech Koszek P_______SQL: Engine behind a de-identified medical data platform
How built platform for storing millions of de-identified medical records with PostgreSQL

presented by Wojciech Koszek

Receiving, de-identifying and processing medical data pose many challenges in the real-world. Non-uniformity, multitude of formats, lack of structure and a volume of data create unique problems in data storying, querying and management. Careful separation of sensitive data is required at all times, and retaining this separation ends with some interesting design problems. In this talk we present...


16:40 - 17:00 Santa Clara Data
Hannu Krosing Do you vacuum everyday ?

presented by Hannu Krosing

Postgresql has an amazing MVCC architecture. But it falls over in a small number of well-known cases (and a new one we recently found with temp tables). I have been a happy PostgreSQL user since 1995, and it was possible to run global-scale databases with the MVCC limitations - if you really knew how it works - at least since 2004/5 when we built the Skype database backend on PostgreSQL and s...


16:40 - 17:00 Winchester Ops
Ben Vandiver Google Journey: Bringing a PostgreSQL Interface to Cloud Spanner

presented by Ben Vandiver

PostgreSQL has emerged as the “API” for relational data management. Its proven success in a wide range of applications and solid open-source foundation have cultivated a broad ecosystem of users, packaged offerings, and tools. The move to managed services in the cloud gives many organizations a once-in-a-generation opportunity to rationalize their database usage. An increasing number of them ar...


17:00 - 17:20 Winchester Dev
David Benoit Simplifying System Architecture by Rethinking the Role of the Database
Infrastructure has evolved. Its time we changed how we build systems.

presented by David Benoit

Sometimes I look at the architecture of systems and they seem overly complicated. Sometimes there are good reasons. Sometimes there aren't. Can we have something better as our foundation? Is all this complexity really necessary? For a small scale service? For a global service?

I present an option for building database backed services, complete with client / public side APIs, and 3rd pa...


09:00 - 09:20 Winchester Dev
Alexander Korotkov Solving PostgreSQL wicked problems
A miracle done as an extension

presented by Alexander Korotkov

It's more than 25 years since PostgreSQL was developed by the Open Source community. Through this time, we can track how the PostgreSQL community did a brilliant job adding new features and improving existing things, making PostgreSQL one of the most popular DBMSes in the world.

At the same time, we can see a set of wicked problems in PostgreSQL design, which came from Berkley or were added ...


09:00 - 09:50 Santa Clara Dev
Chirag Dave Managing extensions in RDS/Aurora

presented by Chirag Dave

Introduction to PostgreSQL extensions available to RDS PostgreSQL and Aurora PostgreSQL. This talk will highlight the use of aws_lambda, aws_s3.table_import_from_s3 and aws_s3.query_export_to_s3

09:00 - 09:50 Ballroom AWS Data Day
Andrey Borodin Introducing SPQR: Stateless Postgres Query Router
On a road to liquid OLTP sharding

presented by Andrey Borodin

SPQR is a lightweight OLTP sharding solution written in Go. In this talk, I'm going to discuss design decisions that led us through FDW-based sharding, CustomNode-based sharding, C-implemented lightweight query routing, and finally to SPQR design.

09:30 - 09:50 Winchester Dev

presented by Robert Treat

It's 2021 and we are still dealing with integer overflow. Just a few months ago I came within 24 hours of watching one of the worlds tech unicorns come to a stop due to possible int overflow problems. Join me while I discuss the nature of the problem, why we still see it today, and cover many of the various options to work your way through a pending int overflow. I also talk about some of the m...


10:00 - 10:50 Winchester Ops
Sukhpreet Bedi Sundar Raghavan Using aws_ml/aws_comprehend in Aurora PostgreSQL
Using aws_ml/aws_comprehend in Aurora PostgreSQL

presented by Sundar Raghavan and Sukhpreet Bedi

Amazon Aurora machine learning enables you to add ML-based predictions to applications via the familiar SQL programming language, so you don't need to learn separate tools or have prior machine learning experience. It provides simple, optimized, and secure integration between Aurora and AWS ML services without having to build custom integrations or move data around. In this session, learn more ...


10:00 - 10:50 Ballroom AWS Data Day
Charly Batista PL/Java - Extend the power of your database
How to use Java to extend your database powers

presented by Charly Batista

There are some cases when we need to empower our database and Postgres offers many options, including Java. During this talk, we'll not only see how to install and configure PL/Java but we'll walk through examples on how to access database objects, loop through a resultset, and return the result back as a single object like a TEXT. While this sounds interesting we'll also show some complex exam...


10:00 - 10:50 Santa Clara Dev
PostgresConf Organizers Friday Morning Break
Friday Morning Break

presented by PostgresConf Organizers

Friday Morning break

10:50 - 11:10 Ballroom
Bruce Momjian Future Postgres Challenges

presented by Bruce Momjian

Postgres has been a vibrant project for decades, and probably will be popular for decades to come. However, as with any complex endeavor, challenges are always lurking. This talk explores the many project, competitive, and technical challenges in the future that could derail its success. By exploring these challenges, we will be better able to avoid them.

11:10 - 12:00 Winchester Data
Yury Selivanov EdgeDB - A graph-relational database

presented by Yury Selivanov

The talk is an introduction to EdgeDB -- the first graph-relational database based on PostgreSQL. We'll discuss the graph-relational model and how it is different from the classical relational model, talk about EdgeQL -- a new query language aimed to match and surpass SQL, and look at how EdgeDB addresses many pain-points that developers have with relational databases.

11:10 - 12:00 Santa Clara Dev
Wanda  He 5 Tips for Building Scalable Application with ORM and Amazon RDS PostgreSQL

presented by Wanda He

Are you building a data driven application? Are you using Object-Relational Mapping (ORM)?

Amazon RDS for PostgreSQL makes it fast and simple for you to get started with familiar database engines and ORM. As your business grows, you need a cloud solution that scales with you. In this talk, learn about tips to optimize ORM and Amazon RDS for PostgreSQL. Discover how to build a database with ...


11:10 - 12:00 Ballroom AWS Data Day
PostgresConf Organizers Friday Lunch

presented by PostgresConf Organizers

Friday Lunch

12:00 - 13:00 Ballroom
Bruce Momjian Non-Relational Postgres

presented by Bruce Momjian

Postgres has always had strong support for relational storage. However, there are many cases where relational storage is either inefficient or overly restrictive. This talk shows the many ways that Postgres has expanded to support non-relational storage, specifically the ability to store and index multiple values, even unrelated ones, in a single database field. Such storage allows for greater ...


13:10 - 14:00 Santa Clara Dev
Ibrar Ahmed Tune PostgreSQL for Read/Write Scalability.

presented by Ibrar Ahmed

PostgreSQL is one of the leading open-source databases. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. Nowadays, production systems have quite expensive machines, which require extra configuration for PostgreSQL. PostgreSQL provides extensive configuration parameters to configure it according to the available hardware. Sometimes it is hard to co...


13:10 - 14:00 Winchester Dev
Shayon Sanyal Sukhpreet Bedi Using Global database in Amazon Aurora PostgreSQL
Using Global database in Amazon Aurora PostgreSQL

presented by Shayon Sanyal and Sukhpreet Bedi

An Amazon Aurora Global database is designed for globally distributed applications, allowing a single Amazon Aurora database to span multiple AWS Regions. It replicates your data with no impact on database performance, enables fast local reads with low latency in each Region, and provides disaster recovery (DR) from Region-wide outages. In this session, learn how to plan for cross-Region DR and...


13:10 - 14:00 Ballroom AWS Data Day
Bryn Llewellyn How to navigate the “interval” minefield

presented by Bryn Llewellyn

PostgreSQL’s date-time apparatus is vast and complex. This is partly explained by the inescapable reality of astronomy and human convention. Moreover, the timestamp and interval data types, and timezone sensitivity, came only after date, and the rules for date arithmetic, were already in use. The rules for the newer data types are different from the older rules for date values. (For...


14:10 - 15:00 Santa Clara Dev
Ibrar Ahmed A Deep Dive into PostgreSQL Indexing

presented by Ibrar Ahmed

Indexes are a fundamental feature of relational databases, and PostgreSQL offers developers and designers a rich collection of options. To take advantage of these entirely, users need to understand the basic concept of indexes to compare the different index types and apply them to different application scenarios. Only then can you make an informed decision about your database index strategy an...


14:10 - 15:00 Winchester Dev
chandra pathivada Amazon Babelfish for Aurora
Migrate SQL Server workloads to Babelfish for Aurora

presented by chandra pathivada

Now the Babelfish for Aurora is available. This presentation is about how Babelfish helps customers to migrate SQL Server workloads to Postgres. In this presentation, we are going to give a demo of what is Babelfish , the internals of Aurora ,Aurora for SQL Server DBAs using Babelfish, and Labs on Application Migration.

14:10 - 15:00 Ballroom AWS Data Day
Matt Yonkovit How Users Will Dictate and Change the Next 20 Years of PostgreSQL
The Future Of PostgreSQL

presented by Matt Yonkovit

The future is now. The PostgreSQL community has built one of the most powerful and well-respected databases on the planet. Its versatility is unparalleled. What got us here however will not get us to where we need to go next. The next generation of users and developers think differently and have different expectations than most of us do. They expect easy. They expect a push button. They ...


15:20 - 15:40 Santa Clara Dev

presented by Hamid Akhtar

Experiencing replication conflicts is not too unfamiliar a sight. Whether one experiences replication lag, slots, locks, snapshots, tablespace issues, or other conflicts, establishing a set of best practices along with using proper observability tools will help avoid potential issues. This talk focuses on what to do and what not to in order to avoid database conflicts in streaming replication s...


15:20 - 15:40 Winchester Dev
Krishna Sarabu Sundar Raghavan Developing Event Driven Serverless applications using RDS/Aurora PostgreSQL
Improve throughput, scale and extensibility using Micro services and RDS/Aurora PostgreSQL

presented by Krishna Sarabu and Sundar Raghavan

Applications designed with even-driven architecture (EDA) provide increased availability, elasticity, scalability and cost optimization and promotes micro-services, which are small, specialized services performing a narrow set of functions. Event-driven architecture (EDA) is a software architecture paradigm promoting the production, detection, consumption of, and reaction to events. Event-drive...


15:20 - 16:10 Ballroom AWS Data Day
Rebecca Bilbro Beyond Off-the-Shelf Consensus
Better Data Synchronization through Open Source

presented by Rebecca Bilbro

There have never been more commercial tools available for building distributed data apps — from cloud hosting services, to cloud-native databases, to cloud-based analytics platforms. So why is it still so hard to make a successful app with a global user base?

One of the toughest challenges cloud offerings take on is the problem of consensus, abstracting away most of the complexity. That's no...


15:50 - 16:10 Winchester Dev
Alvaro Hernandez How to measure query performance
Or, alternatively, how NOT to measure query performance

presented by Alvaro Hernandez

If you don’t know how to measure query performance in Postgres, this talk is for you.

If you know how to do it and consider it a simple and solved problem, this talk is definitely for you.

It doesn’t sound too complicated. There are several tools and techniques to report query performance. But a deeper look reveals some troubling conclusions:

  • Some techniques may outright lie to you. ...

15:50 - 16:10 Santa Clara Data
Debra Cerda Jim Nasby Gopinath Pai Babelfish for PostgreSQL
Babelfish for PostgreSQL accelerates the journey to migrate SQL Server applications to PostgreSQL

presented by Jim Nasby, Debra Cerda, and Gopinath Pai

Babelfish for PostgreSQL is an open source project 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. Babelfish understands the SQL Server wire-protocol and T-SQL, the Microsoft SQL Server query language, so you don’t have to switch database driver...


16:20 - 17:10 Winchester Ops
Scott Mead Connection scalability for Enterprise Applications
Scale your database connectivity throughout the entire stack

presented by Scott Mead

Enterprise applications live and die by their ability to scale concurrently to the database. Choosing too few connections to your database gives your users a bad experience, choosing too many puts the database in a constant state of high CPU. Learn how to build a connection profile for your workload that provides maximum throughput and lowest latency while maximizing your database's system ut...


16:20 - 17:10 Ballroom AWS Data Day
Nikolay Samokhvalov Common DB Schema Change Mistakes
Why changing schema under load is hard and what to do about it

presented by Nikolay Samokhvalov

One of the easiest ways to "create a heavy load from nothing" is to write a couple of DDL commands and deploy them to production without thorough analysis and testing.

In this talk, we will discuss several widespread mistakes that many developers and DBAs regularly make during active application development, when there is a need to change DB schema – from adding new database objects or colum...


16:20 - 17:10 Santa Clara Dev
Shayon Sanyal Amazon Aurora Global Database Design Patterns for HA and DR
Amazon Aurora Global Database Design Patterns for HA and DR

presented by Shayon Sanyal

Amazon Aurora Global Database is designed for globally distributed applications, allowing a single Amazon Aurora database to span multiple AWS regions. It replicates your data with no impact on database performance, enables fast local reads with low latency in each region, and provides disaster recovery from region-wide outages. In this session, learn about the several use-cases and design patt...


17:20 - 17:40 Ballroom AWS Data Day
Unscheduled events
PostgresConf Organizers Thursday Morning Break

presented by PostgresConf Organizers

Thursday Morning break