Silicon Valley 2022 Program

2022-01-20
10:50
 Kelsey Hightower Postgres: The Universal Database Protocol

presented by Kelsey Hightower

PostgreSQL has a rich history of over 40 years of development, forks, product offshoots and now cloud support. Find out how now, Postgres and related technologies are using this stalwart Open Source project to become a Universal Protocol for enterprise and globally distributed data services.

10:50 - 11:10 Ballroom Data
12:00
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 ...

more

12:00 - 12:50 Market Dev
Hans-Jürgen Schönig Support horror stories: Fighting the trenches
Fixing the fixable ...

presented by Hans-Jürgen Schönig

Our support team has seen many different things causing problems, downtime, data loss or simply inconvenience. The question is: What can we learn from that and what can one do to avoid such mistakes in the future? What are the most relevant support cases reaching us time and time again? And more importantly: Which precautions can be taken to avoid such mistakes? Indexing, backups, monitoring, e...

more

12:00 - 12:20 Winchester Ops
12:30
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...

more

12:30 - 12:50 Winchester Data
14:00
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...

more

14:00 - 14:50 Market Dev
Robert Treat ADVANCED INT->BIGINT CONVERSIONS

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

more

14:00 - 14:50 Winchester Ops
15:00
Richard Yen When Less is More
Scaling Postgres without breaking the bank

presented by Richard Yen

When an application scales up, the underlying database often needs to be tweaked to keep up with the incoming demand. Intuitively sysadmins and database admins scale up the hardware and tune configuration parameters to meet higher demand. Unfortunately, it's not always the case that more hardware and resources will lead to better performance. In this talk, we'll cover why scaling up isn't ju...

more

15:00 - 15:20 Winchester Ops
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...

more

15:00 - 15:20 Market Dev
15:40
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...
more

15:40 - 16:00 Winchester Ops
Oleg Bartunov The Curse of TOAST

presented by Oleg Bartunov

TOAST allows to store a long attributes in postgres tuple. Being useful in the past, nowadays it's a sticking point for non-atomic data types like jsonb, which is one of the main driver of growing popularity of postgres. I will present the results of our experiments with modifying TOAST, which allows us to improve jsonb performance by orders of magnitude.

15:40 - 16:00 Market Dev
16:10
Henrietta Dombrovskaya How to use bitemporal functions: a hands-on guide

presented by Henrietta Dombrovskaya

We have been developing the pg_bitemporal library for over six years. It started as a proof of concept; however, it has been used in the industrial setting at Braviant Holdings for the past four years. Responding to practical business needs, several functions not included in the original specs were added along with bitemporal integrity constraints support. Significant performance improvements ...

more

16:10 - 17:00 Market Dev
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...

more

16:10 - 17:00 Winchester Ops
2022-01-21
09:00
Sukhpreet Bedi Sundar Raghavan Using aws_ml/aws_comprehend in Aurora PostgreSQL
Using aws_ml/aws_comprehend in Aurora PostgreSQL

presented by Sukhpreet Bedi and Sundar Raghavan

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

more

09:00 - 09:50 Ballroom AWS Data Day
10:00
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.

10:00 - 10:50 Ballroom AWS Data Day
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.

10:00 - 10:50 Winchester Data
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...

more

10:00 - 10:50 Market Dev
11:00
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...

more

11:00 - 11:50 Winchester Dev
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...

more

11:00 - 11:50 Market 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 ...

more

11:00 - 11:50 Ballroom AWS Data Day
12:00
Laura Ellis Tiffany Cross Data Democratization: Enabling Citizen Data Scientists

presented by Tiffany Cross and Laura Ellis

The most successful businesses will equip every layer in the organization with the data needed to identify and drive growth. The search for this self-service data platform and underlying culture has fueled IBMs own internal business transformation in IBM Cloud Platform. Unsurprisingly, the path involves both technical and cultural challenges. Technically, you need to ensure that your data shows...

more

12:00 - 12:20 Winchester Data
Hamid Akhtar POSTGRESQL REPLICATION CONFLICTS: AVOIDING PITFALLS

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

more

12:00 - 12:20 Market 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...

more

12:00 - 12:20 Ballroom AWS Data Day
13:20
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...

more

13:20 - 14:10 Winchester Data
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...

more

13:20 - 14:10 Ballroom AWS Data Day
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...

more

13:20 - 14:10 Market Dev
14:20
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...

more

14:20 - 15:10 Ballroom AWS Data Day
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...

more

14:20 - 14:40 Winchester 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...
more

14:20 - 15:10 Market Ops
14:50
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...

more

14:50 - 15:40 Winchester Dev
15:20
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...

more

15:20 - 16:10 Ballroom AWS Data Day
16:20
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

16:20 - 17:10 Ballroom AWS Data Day