Silicon Valley 2022 Program

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

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

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.

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.

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.

presented by PostgresConf Organizers

Thursday Lunch

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

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

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

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!

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

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

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

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

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

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

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

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

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

presented by Bruce Momjian

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

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

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

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

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

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

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

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

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.

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

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

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

presented by PostgresConf Organizers

Friday Morning break

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.

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.

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

presented by PostgresConf Organizers

Friday Lunch

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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