Silicon Valley 2022
Postgres Conference Silicon Valley is back and still the largest gathering about People, Postgres, Data on the West Coast! An inclusive and equitable event we bring together a best-in-talent combination of speakers, attendees, and sponsors to build opportunities for the global Postgres ecosystem.
The registration period ends in
Some of our speakers
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.
Jan 20 Non-Relational Postgres
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 efficiency and access simplicity, and can also avoid the negatives of entity-attribute-value (eav)...
Jan 20 When Less is More
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 just about putting in more money and proportionally allocating more resources.
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 were made. There is a definite business demand in the two-dimensional time support, and...
Jan 21 Amazon Babelfish for Aurora
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.
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 the flexibility to adjust, use, and break down other purpose-built databases as your business scales.
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 the full picture in a timely fashion, with quality information in the tool of choice. Culturally,...
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 easily scale Aurora reads across the world to place your applications close to your users. You also...
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, I will also talk about some of the important enhancements being discussed in this technology area...
has the most awesome program ever!
See rock-star speakers cover the topics of
Past, Present, and Future of Logical Replication by Amit Kapila
How to use bitemporal functions: a hands-on guide by Henrietta Dombrovskaya
When it all GOes right by Pavlo Golub
PL/Java - Extend the power of your database by Charly Batista
Non-Relational Postgres by Bruce Momjian
Tune PostgreSQL for Read/Write Scalability. by Ibrar Ahmed
POSTGRESQL REPLICATION CONFLICTS: AVOIDING PITFALLS by Hamid Akhtar
The Curse of TOAST by Oleg Bartunov
Beyond Off-the-Shelf Consensus by Rebecca Bilbro
How to navigate the “interval” minefield by Bryn Llewellyn
A Deep Dive into PostgreSQL Indexing by Ibrar Ahmed
Support horror stories: Fighting the trenches by Hans-Jürgen Schönig
When Less is More by Richard Yen
ADVANCED INT->BIGINT CONVERSIONS by Robert Treat
Professional PostgreSQL scheduling made easy by Pavlo Golub
Future Postgres Challenges by Bruce Momjian
Postgres: The Universal Database Protocol by Kelsey Hightower
TDE: State of Encryption in Postgres by Mehboob Alam
Data Democratization: Enabling Citizen Data Scientists by Laura Ellis
AWS Data Day
Using aws_ml/aws_comprehend in Aurora PostgreSQL by Sukhpreet Bedi
Managing extensions in RDS/Aurora by Chirag Dave
Amazon Aurora Global Database Design Patterns for HA and DR by Shayon Sanyal
Using Global database in Amazon Aurora PostgreSQL by Shayon Sanyal
Connection scalability for Enterprise Applications by Scott Mead
Amazon Babelfish for Aurora by chandra pathivada