Loading…
Postgres Build 2021
Attending this event?

Sign up or log in to bookmark your favorites and sync them to your phone or calendar.

Tuesday, November 30
 

8:30am GMT

Registration and Networking
Tuesday November 30, 2021 8:30am - 9:00am GMT
TBA

9:00am GMT

Welcome Message
Speakers
avatar for Simon Riggs

Simon Riggs

PostgreSQL Fellow, EDB
Simon built and ran 2ndQuadrant until it merged recently with EDB, helping many customers with their Postgres solutions. As a technologist he has contributed widely to PostgreSQL across 16 years and now continues his work with the PostgreSQL community, as well as being an author of... Read More →


Tuesday November 30, 2021 9:00am - 9:15am GMT

9:15am GMT

Future Postgres Challenges
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.

Speakers
avatar for Bruce Momjian

Bruce Momjian

Vice President, Postgres Evangelist, EDB


Tuesday November 30, 2021 9:15am - 10:00am GMT
TBA

10:00am GMT

Walkthrough of the day
Speakers
avatar for Simon Riggs

Simon Riggs

PostgreSQL Fellow, EDB
Simon built and ran 2ndQuadrant until it merged recently with EDB, helping many customers with their Postgres solutions. As a technologist he has contributed widely to PostgreSQL across 16 years and now continues his work with the PostgreSQL community, as well as being an author of... Read More →


Tuesday November 30, 2021 10:00am - 10:15am GMT

10:15am GMT

Postgres, still going strong?
Where did Postgres come from, how did it evolve into becoming the world’s leading data management system and where will it go after tomorrow?
Join me in an exploration of the vital elements that lead to this (r)evolution. Big multinational software vendors lose out to a disorganized bunch of geeks? Or is there something more fundamentally happening?

We will shine a light on some key learnings to see if we can “crack the code of Postgres”, something we do not have to do for the server itself, as that is fully Open Source!

Speakers
avatar for Jan Karremans

Jan Karremans

Director of Product Marketing, EDB


Tuesday November 30, 2021 10:15am - 10:55am GMT
TBA

10:15am GMT

Slow things down to make them go faster
It's easy to get misled into overconfidence based on the performance of powerful servers, given today's monster core counts and RAM sizes. However, the reality of high concurrency usage is often disappointing, with less throughput than one would expect. PostgreSQL is very particular about how it likes to deal with high concurrency, so let's look at potential pitfalls when you throw a lot of work at your database.

Speakers
avatar for Jimmy Angelakos

Jimmy Angelakos

Senior PostgreSQL Architect, EDB
Computer scientist who has worked with Open Source tools for more than 20 years. He has taught Databases & Programming for Oracle University, worked as Head of Software Development for an SME building vertical transport solutions, transaction processing & interoperability systems... Read More →


Tuesday November 30, 2021 10:15am - 10:55am GMT
TBA

11:00am GMT

Deploying Battle-Hardened Postgres Configurations And Architecture at Scale
PostgreSQL is the relational database that has been named Database Management System of the year by DB-Engines. A few reasons for that achievement are: open source, cost effective, portable, cloud available and most importantly high reliability.

Speakers
avatar for Vibhor Kumar

Vibhor Kumar

Vice President, Performance Engineering, EDB
Vibhor has many years of leadership experience in designing innovative business solutions for customers. He has In-depth experience with cloud technology, management, training and database technologies like Oracle, MySQL, PostgreSQL, DB2, and EDB Postgres Advanced Server. He has mastery... Read More →
avatar for Doug Ortiz

Doug Ortiz

Postgres DevOps Engineer, EDB
Doug Ortiz skills encompass multiple platforms such as: AWS, Azure, GCP, Big Data, Data Analytics, DevOps, Linux, Kubernetes, Docker, Terraform, Ansible, Python, Scala, GraphQL, .Net, SharePoint, Office, Neo4J, MySQL, PostgreSQL, and SQL Server. He possesses a Master’s Degree in... Read More →


Tuesday November 30, 2021 11:00am - 11:40am GMT
TBA

11:00am GMT

When and How to write TAP tests for PostgreSQL
This is a talk about the When, How and Why of using TAP tests with PostgreSQL. It will give attendees an understanding of these and material to extend that knowledge, both in understanding existing tests and the ability to create new tests.

Speakers
avatar for Andrew Dunstan

Andrew Dunstan

Senior Principal Engineer, Database Server, EDB
Andrew has been contributing to PostgreSQL since 2003, and has been a committer since 2005. He has contributed to a wide range of features such as the native Windows port, CSV import and export, parallel pg_restore, and JSON support. He created and still maintains the PostgreSQL Build... Read More →


Tuesday November 30, 2021 11:00am - 11:40am GMT
TBA

11:45am GMT

Embarking on a Successful Database Migration Journey to PostgreSQL
More and more organizations are choosing to migrate their database applications off legacy database technology onto databases such as Postgres. Before undertaking a database migration journey, it is important to understand what is involved in a database migration. This talk explores the topic of database migrations, particularly migrations to Postgres, with the goal of highlighting the factors to consider, the steps to take, the types of tools to use, and the resources that are required that will increase the chances of a successful migration.

Speakers
avatar for Matthew Lewandowski

Matthew Lewandowski

Field CTO, EDB
Matt Lewandowski is a Field CTO at EDB, working in the CTO organization. Matt has extensive engineering and technology experience, including over 25 years of experience developing, delivering, and implementing database applications and solutions for public sector and commercial customers... Read More →


Tuesday November 30, 2021 11:45am - 12:25pm GMT
TBA

11:45am GMT

Fix your Strings!
Strings are one of the most used types in databases, storing pretty much any data without enforcing rules on the inserted input. Yet too much freedom leads to inconsistencies: is it Aivan or Aiven? Øyvind or Oyvind? Wine or Whine?
Starting with pattern matching, passing by regular expressions, ending with advanced functionalities exposed by the fuzzystrmatch and unaccent extensions we'll go over what PostgreSQL has to offer. If you care about your (string) data quality, this session is for you!

Speakers
avatar for Francesco Tisiot

Francesco Tisiot

Developer Advocate, Aiven
Francesco comes from Verona, Italy, and works as a Developer Advocate at Aiven. With his many years of experience as a data engineer, he has stories to tell and advice for data-wranglers everywhere. Francesco loves sharing knowledge with others as a speaker and writer, and is on a... Read More →


Tuesday November 30, 2021 11:45am - 12:25pm GMT
TBA

12:30pm GMT

Solving PostgreSQL wicked problems
PostgreSQL is a very popular and feature-rich DBMS. At the same time, PostgreSQL has a set of annoying wicked problems, which haven't been resolved in decades. Miraculously, with just a small patch to PostgreSQL core extending this API, it appears possible to solve wicked PostgreSQL problems in a new engine made within an extension.

Speakers
avatar for Alexander Korotkov

Alexander Korotkov

Founder, OrioleDB
Alexander Korotkov is a PostgreSQL Major Contributor & Committer, and PhD in computer science. He contributed many fields of PostgreSQL including indexing, statistics, concurrency, extensibility, and more. In 2015 Alexander co-founded and became the technical chief and development... Read More →


Tuesday November 30, 2021 12:30pm - 1:10pm GMT
TBA

12:30pm GMT

Lesser known features of PostgreSQL
In the talk I'm going to present a few lesser know, but useful features of PostgreSQL you may never heard about!

Speakers
avatar for Haki Benita

Haki Benita

Team Leader, Haki Benita
A tech lead specializing in databases, web development, and performance tuning. Check out hakibenita.com


Tuesday November 30, 2021 12:30pm - 1:10pm GMT
TBA

1:10pm GMT

Lunch / Networking
Tuesday November 30, 2021 1:10pm - 1:40pm GMT
TBA

1:10pm GMT

Cloud Native Postgres Product Demo
Cloud Native Postgres adds agility to Postgres from a deployment and an auto-healing perspective, making Postgres the ultimate data store for microservices and more.

Speakers
avatar for Sergio Romera

Sergio Romera

EMEA Senior Sales Engineer, EDB


Tuesday November 30, 2021 1:10pm - 1:40pm GMT

1:40pm GMT

Touring the PostgreSQL optimizer
The PostgreSQL optimizer is an important component of the database server which is highly important to achieving good performance. Learn all about the optimizer and understand how it works, what it does and how one can assure good performance.

Speakers
avatar for Hans-Jürgen Schönig

Hans-Jürgen Schönig

CEO, Cybertec
Hans-Jürgen Schönig has been in professional PostgreSQL for more than 20 years and has worked for customers around the globe on 24x7 support, performance, scaling as well as HA.


Tuesday November 30, 2021 1:40pm - 2:20pm GMT
TBA

1:40pm GMT

The long road to upgrading PostgreSQL, without noticing it happened
This talk will not only go over how to perform a “near” zero downtime upgrade using different logical replication options, but also cover things that, if not taken care of in time, can end up in an extended upgrade, or worse, in one that failed.

Speakers
avatar for Martin Marqués

Martin Marqués

Senior Support Engineer Team Manager, EDB
Martín is a Senior Support Engineer, currently leading one of the Support Teams at EDB. He’s also a Mathematician and University Professor that started using Linux and Open Source software in the ’90s. He’s been working with PostgreSQL for 21 years. He’s been System Administrator... Read More →


Tuesday November 30, 2021 1:40pm - 2:20pm GMT
TBA

2:25pm GMT

An introduction to server-side programming in PostgreSQL
While I've seen many PostgreSQL databases, small, large and even larger, surprisingly only a few of them made of use of server-side programming in PostgreSQL. That is even more surprising, as data should be processed where data is, and that usually is in the database. There is nothing better you can do for performance. In this talk we'll look at what PostgreSQL provides, how you can use it, and we'll see some common examples that help you to get started with procedures and functions.

Speakers
avatar for Daniel Westermann

Daniel Westermann

Principal Consultant, dbi services
Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering, and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his... Read More →


Tuesday November 30, 2021 2:25pm - 3:05pm GMT
TBA

2:25pm GMT

Low Code: Oracle to PostgreSQL migration a practical report
We report on our experiences with the migration of a complex Oracle application to Postgres. This is the standard product PLAU to handle trainings for more than 10.000 unemployed people per year.

We cover the topics PL/SQL to PL/pgSQL, queries & views, replacement for typical Oracle functions, transactions, performance tuning, testing, tools and some more from the practice of a product manufacturer.

Speakers
avatar for Roland Hörmann

Roland Hörmann

CEO, SIB Visions GmbH
Roland Hörmann is the founder and managing director of SIB Visions GmbH. He has many years of experience in the development of enterprise solutions. His focus of interest is on efficient software development and framework development in the area of modern business applications. He... Read More →


Tuesday November 30, 2021 2:25pm - 3:05pm GMT
TBA

3:15pm GMT

Cloud Native PostgreSQL, an operator for Kubernetes
Are you looking forward to using PostgreSQL in a Cloud Native environment based on Kubernetes?
This talk is the perfect opportunity for you to see where Cloud Native PostgreSQL, developed by EDB, is currently standing and how it can be integrated into your Kubernetes and OpenShift Container Platform workloads.
Cloud Native PostgreSQL is a Kubernetes operator that allows you to use the open source PostgreSQL database with your Cloud Native applications, as well as EDB Postgres Advanced.
Cloud Native PostgreSQL is built on solid concepts and principles such as immutable infrastructure, declarative configuration and application containers, making it ideal to use in your CI/CD pipelines as part of the applications’ E2E tests.
Join me to discover how our operators adapt to public/private/hybrid environments, how core features such self-healing, high-availability, scalability, and updates work, and - last but not least - what our DevSecOps culture and processes have produced in the area of security.

Speakers
avatar for Gabriele Bartolini

Gabriele Bartolini

VP Cloud Native, EDB, EDB
A long time open-source programmer and entrepreneur, Gabriele has a degree in Statistics from the University of Florence. After having consistently contributed to the growth of 2ndQuadrant and its members through nurturing a lean and devops culture, he is now leading the Cloud Native... Read More →


Tuesday November 30, 2021 3:15pm - 3:55pm GMT
TBA

3:15pm GMT

The power and versatility of PostgreSQL - where does it come from and what does it mean for today’s enterprise
Key decisions taken in the Postgres design and the community over the last 25+ years are still driving Postgres' success today. After a brief review of those decisions, the talk describes where and how enterprises leverage Postgres today, and outlines the recommended best practices to leverage Postgres in the modern enterprise

Speakers
avatar for Marc Linster

Marc Linster

CTO, EDB
Marc Linster, Ph.D., is EDB’s Chief Technology Officer. Marc leads EDB's Office of the CTO, where he and his team of PostgreSQL experts work with key customers and strategic partners on providing strategic technical direction, visionary thought leadership, and leveraging key technology... Read More →


Tuesday November 30, 2021 3:15pm - 3:55pm GMT
TBA

4:00pm GMT

Sharing experiences along the Postgres journey
In this session, we will explore why organisations adopt open source and the reasons for selecting PostgreSQL as their preferred DBMS. We will discuss business cases and anecdotes from PostgreSQL users and the role that PostgreSQL plays in their IT architectures.

Speakers
avatar for Rick Mallon

Rick Mallon

Head of Product Domain BSS Customer & Partner Engagement, Ericsson
avatar for Martin Schmitter

Martin Schmitter

Solutions Architect Database - Senior Database Administrator, RWE
avatar for Roland Bender

Roland Bender

Global Head of Databases, Boehringer Ingelheim
Working for 27 years for Boehringer Ingelheim / different departments/positionsStarted as an industrial clerk / studied economics (strong background in finance and controlling)Since ever enthusiastic to understand the technology and find ways to make the best use of it for our businessI... Read More →
avatar for Jan Karremans

Jan Karremans

Director of Product Marketing, EDB


Tuesday November 30, 2021 4:00pm - 4:45pm GMT

4:50pm GMT

Closing the event for the day
Speakers
avatar for Simon Riggs

Simon Riggs

PostgreSQL Fellow, EDB
Simon built and ran 2ndQuadrant until it merged recently with EDB, helping many customers with their Postgres solutions. As a technologist he has contributed widely to PostgreSQL across 16 years and now continues his work with the PostgreSQL community, as well as being an author of... Read More →


Tuesday November 30, 2021 4:50pm - 5:00pm GMT
 
Wednesday, December 1
 

8:30am GMT

Registration and Networking
Wednesday December 1, 2021 8:30am - 9:00am GMT

9:00am GMT

Welcome Message
Speakers
avatar for Steve Price

Steve Price

Enablement & GTM Leader, EDB


Wednesday December 1, 2021 9:00am - 9:15am GMT

9:15am GMT

Quo vadis, Postgres in the cloud? Kubernetes or DBaaS?
Moving to the cloud is hard, and moving databases to the cloud is even harder. Public cloud or private cloud? IaaS or PaaS? Kubernetes for the application, or for the database and the application? This talk will juxtapose EDB Cloud Native Postgres, a self-managed Kubernetes and container based database solution, and EDB Cloud, a fully managed database service,  that is built on EDB Cloud Native Postgres. The talk will review cloud architecture considerations and provide guidance for decision makers.

Speakers
avatar for Marc Linster

Marc Linster

CTO, EDB
Marc Linster, Ph.D., is EDB’s Chief Technology Officer. Marc leads EDB's Office of the CTO, where he and his team of PostgreSQL experts work with key customers and strategic partners on providing strategic technical direction, visionary thought leadership, and leveraging key technology... Read More →


Wednesday December 1, 2021 9:15am - 10:00am GMT

10:00am GMT

Walkthrough of the day
Speakers
avatar for Steve Price

Steve Price

Enablement & GTM Leader, EDB


Wednesday December 1, 2021 10:00am - 10:15am GMT

10:15am GMT

Consistency and Conflict in PostgreSQL Replication
How consistent is my PostgreSQL cluster? Can I write and read on every node as if they were only one? Can I scale horizontally? Will the Elders of the Internet protect my cluster from failure? Get closer to the answer to all these questions in this talk without rhymes.

Speakers
avatar for Boriss Mejias

Boriss Mejias

Solution Architect, EDB
I'm a holistic system software engineer (aka Solution Architect), PostgreSQL consultant and trainer, free software user, and headbanger. I have been working with PostgreSQL since version 9.1. First, as part of my job related to other projects, and with full dedication since 2017... Read More →


Wednesday December 1, 2021 10:15am - 10:55am GMT
TBA

10:15am GMT

How PostgreSQL aggregates work (through pictures) and how to create and use custom aggregates
Aggregates are one of the most commonly used features of PostgreSQL, but many people don’t understand how they work. This talk will provide a brief overview of how aggregates work in PostgreSQL through pictures including:
-Transition, final and combine functions
-Parallel aggregation
-Aggregate de-duplication and optimization

Then we will go over how you can use this knowledge to construct custom aggregates for use in your applications, with examples of how to design custom aggregates to fill specific needs and work efficiently.

Speakers
avatar for David Kohn

David Kohn

Software Engineer, Timescale
David Kohn is a Software Engineer at Timescale. He started out as an electrochemist and fell into databases over 5 years ago, since then he’s worked almost exclusively on PostgreSQL. He has helped design applications and tools for very high volume, multi-terabyte installations... Read More →


Wednesday December 1, 2021 10:15am - 10:55am GMT

11:00am GMT

Database Benchmarking in GitLab
The goal of this talk is about how to increase the database uptime, and prevent possible problems in production during rollouts or changes in the setup. We are generating an environment similar to production, with similar traffic to GitLab.com, where we are talking about over 50.000 transactions per second!

Speakers
avatar for Nikolay Samokhvalov

Nikolay Samokhvalov

Founder, Postgres.ai
Nikolay Samokhvalov is the Founder of Postgres.ai: helping developers speed up development and improve quality via using thin cloning, putting large databases to CI/CD pipelines, and robust SQL optimization tools. The core product: Database Lab: https://postgres.ai/products/how-it-worksPostgreSQL... Read More →
avatar for Jose Finotto

Jose Finotto

Staff Engineer, GitLab
Jose Finotto is a Staff Engineer at Gitlab for the Infrastructure department, leading efforts for the implementations of solutions and integrations between all the Gitlab infrastructure ecosystems, mainly in projects principally focused on the database aspect. With more than 18 years... Read More →


Wednesday December 1, 2021 11:00am - 11:40am GMT
TBA

11:00am GMT

PostgreSQL Indexing / Overview and improvements
PostgreSQL provides a wide range of index types - from the traditional index types like btree or hash indexes, full-text gin indexes, to less known types like brin, gist etc. In this talk I'd like to present a brief overview of the index types, along with some unique and handy features and main improvements in recent PostgreSQL versions.

Speakers
avatar for Tomas Vondra

Tomas Vondra

Senior Principal Engineer / Database Server, EDB
Long-time PostgreSQL contributor and committer, working on various features related to optimizer, extended statistics, and performance-related topics.


Wednesday December 1, 2021 11:00am - 11:40am GMT
TBA

11:45am GMT

Bulk inserts with PostgreSQL: Four methods for efficient data loading
Inserting bulk data into PostgreSQL is a task many engineers have to do, but knowing how to do it efficiently can be a challenge. In this talk we will discuss four ways to insert data at high rates using: the built-in COPY command, language SDKs, multi-valued INSERT statements, and even a trick that incorporates array parameters that can outperform other options in some circumstances. We'll also discuss the impact of each option on server resources and the overall impact to the database being modified.

Speakers
avatar for Ryan Booz

Ryan Booz

Director, Developer Advocacy, Timescale
Ryan is a Developer Advocate at Timescale, the supercharged time-series database built on PostgreSQL. Prior to Timescale, Ryan worked for more than 17 years as a developer, DBA, and product manager in multiple ISVs delivering SaaS products based on time-series data. Ryan is a long-time... Read More →


Wednesday December 1, 2021 11:45am - 12:25pm GMT
TBA

11:45am GMT

An infrastructure-as-code approach to PostgreSQL-backed IoT sensor data sharing
The British Geological Survey's sensor data API is backed by PostgreSQL databases.
It has been built via an infrastructure-as-code approach using Docker, Ansible, Flyway and GitLab CI.
Streaming replication via pglogical provides redundancy and selected publication of data.
This talk outlines the architecture explains some of the benefits of this approach

Speakers
avatar for John Stevenson

John Stevenson

Senior Software Developer, British Geological Survey
Dr. John A. Stevenson is a geologist turned software developer at the British Geological survey.  He is interested in data engineering, with an emphasis on scientific and geospatial data.He likes using open source tools (PostgreSQL, Python, Linux, Git) because they make it easy to... Read More →


Wednesday December 1, 2021 11:45am - 12:25pm GMT
TBA

12:30pm GMT

Postgres Anonymization & Data Privacy
What is Anonymization and Data Privacy , Why it is Important and How it can be achieved with PostgreSQL.

Speakers
avatar for Shilpa Oswal

Shilpa Oswal

Principal Technical Officer, Centre for Development of Advanced Computing
Shilpa Oswal is an adept professional in the area of databases and MIS Reporting with more than 15  years of work experience. She has expertise in designing databases. She is handling production databases on PostgreSQL as well as MIS reporting for various projects in e-Governance... Read More →


Wednesday December 1, 2021 12:30pm - 1:10pm GMT
TBA

12:30pm GMT

Using Open Source to Build an API Economy
Join the Q&A at Postgres Build with EDB CTO Marc Linster and Frank Robben, CEO Belgian Crossroads Bank for Social Security, eHealth platform and Smals. During this talk, you will learn about Smals and their use of open source to develop an API economy and its application. Frank will also share insights into how this concept is helping the healthcare sector across Europe.

Speakers
avatar for Marc Linster

Marc Linster

CTO, EDB
Marc Linster, Ph.D., is EDB’s Chief Technology Officer. Marc leads EDB's Office of the CTO, where he and his team of PostgreSQL experts work with key customers and strategic partners on providing strategic technical direction, visionary thought leadership, and leveraging key technology... Read More →
avatar for Frank Robben

Frank Robben

CEO, Smals
Since 1985, Frank Robben is a continuous driving force behind administrative simplification, process optimization and computerization in the Belgian social, health care and public sector. Frank thereby pays particular attention to the implementation of security by design and privacy... Read More →


Wednesday December 1, 2021 12:30pm - 1:10pm GMT

1:10pm GMT

Lunch / Networking
Wednesday December 1, 2021 1:10pm - 1:40pm GMT
TBA

1:10pm GMT

Big Animal Product Demo
BigAnimal is fully-managed PostgreSQL in the cloud from the database fanatics at EDB.

Speakers
avatar for Vinnie Grack

Vinnie Grack

EMEA Senior Cloud Architect, EDB


Wednesday December 1, 2021 1:10pm - 1:40pm GMT

1:40pm GMT

When less is more -- Scaling Postgres without breaking the bank
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.

Speakers
avatar for Richard Yen

Richard Yen

Principal Support Engineer, EDB
Richard has been using PostgreSQL since v. 7.4 in 2003. He is a Principal Support Engineer at EnterpriseDB, providing technical support to DBAs and developers around the world, and works with many clients ranging from private corporations to government organizations and financial... Read More →


Wednesday December 1, 2021 1:40pm - 2:20pm GMT
TBA

1:40pm GMT

Everything You Wanted to Know About Databases as a Developer but were too afraid to ask your DBA
Even though databases form the backbone of many applications, developers are often not provided with the training that they need to understand how databases work. This presentation therefore aims to tell you, as a developer, everything you wanted to know about databases but were too afraid to ask your DBA. You will come away with enough information about databases in general, and about PostgreSQL in particular, to allow you to develop applications that interact with your databases in the best way possible.

Speakers
avatar for Karen Jex

Karen Jex

Senior Database Consultant, EDB
Karen was an Oracle DBA for 20 years before starting to work with PostgreSQL databases. She liked them so much that she became a Senior Database Consultant with EnterpriseDB. She was once described as “quite personable for a DBA” which she decided to take as a compliment. Outside... Read More →


Wednesday December 1, 2021 1:40pm - 2:20pm GMT
TBA

2:25pm GMT

Navigating the journey from self managed to fully managed databases in the cloud
Moving to the Cloud is hard, and moving your databases to the Cloud is even harder. Many variables need to be accounted for from application compatibility to availability, to security principles, to quality of support. Further complicating the journey is both the commoditization of cloud databases and the proliferation of open source database technology. It’s become commonplace for the major CSPs to throw into their catalog any and all open source databases under the guise of giving their users ‘choice’. Whether the expertise and sophistication necessary to manage those databases is present is not always at the forefront. At EDB, we know that your data is the lifeblood of your business, and that who you entrust to run your database workloads on in the Cloud is not something to be compromised. Join us to learn about what to consider when moving your databases to the cloud and how to avoid finding yourself in a position of compromise after it is too late.

Speakers
avatar for Jozef de Vries

Jozef de Vries

SVP Product Development, EDB
Jozef de Vries is currently Senior Vice President, Product Development at EDB, where he is responsible for leading the product development efforts across the on-premise and cloud portfolio.


Wednesday December 1, 2021 2:25pm - 3:05pm GMT

2:25pm GMT

Table partitioning done right
This talk is out to dispel false myths about partitioning, like "partitioning will make all my queries faster" or "large table must be partitioned". In stead of these, I will show you how to use partitioning for your benefit.

We will review the different features of partitioning to put our reasoning on solid ground.

I will also talk about the limitations of partitioning and present traps that you should avoid.

To round off the talk, I will discuss how partitioning interacts with other database features.

Speakers
avatar for Laurenz Albe

Laurenz Albe

Talking Head, Cybertec
Laurenz Albe has worked with and contributed to PostgreSQL and related projects since 2006.He is the principal author and maintainer of the Oracle Foreign Data Wrapper, ora_migrator, and pgreplay.He joined Cybertec in 2017, where he provides consulting, support, training, and custom... Read More →


Wednesday December 1, 2021 2:25pm - 3:05pm GMT
TBA

3:15pm GMT

Do's and Don'ts of Postgres High Availability
Getting Postgres High Availability right is an adventure fraught with peril, where one false move may result in lost data _or worse_. Failure conditions are often lost amongst the din of implementation details and tooling. As ever, forewarned is forearmed, so we're here to teach you the right ways, and perhaps more importantly, _wrong_ ways to deploy your Postgres HA stack.

Speakers
avatar for Shaun Thomas

Shaun Thomas

High Availability Architect, EDB
Shaun has spent the last 20 years covering a gamut of roles from DBA, database architect, developer, consultant, conference speaker, author, and related fields. These days he focuses on Postgres High Availability, as most of his conference talks, webinars, and user group presentations... Read More →


Wednesday December 1, 2021 3:15pm - 3:55pm GMT
TBA

3:15pm GMT

The I in ACID
Why talking about old things like ACID properties? We all know everything we
need to know about that, right ? Well, I found out that even though this
properties were old, well known and beautifully documented, it didn't mean
people actually understood them. I found myself repeatedly explaining how it
works, what tradeoffs
were made and why.

Particularly, transaction isolation and its anomalies were not commonly known
and I found out developers adding extra layers in their application instead of
simply adjusting their database isolation level for that particular query.

Speakers
avatar for Lætitia Avrot

Lætitia Avrot

Database Consultant, EDB
Lætitia Avrot is a Senior Consultant for EDB in France.She began working with PostgreSQL in 2007. She also had to learn Oracle and SQL Server at the same time.She had a lot of exciting experiences with high availability, production crashes, disaster recovery plan, load balancing... Read More →


Wednesday December 1, 2021 3:15pm - 3:55pm GMT
TBA

4:00pm GMT

Where the DBMS Market is Going
There’s no doubt that cloud will be important. Ignore it at your peril.  SaaS will be big and DBaaS is going to be huge. In his talk at Postgres Build 2021, Mike Stonebraker will cover key considerations and provide guidance about the best way forward when it comes to cloud. Key points include moving decision support applications first and their migration to machine learning.  Other applications will follow, generating a requirement for multi-tenancy.  In addition, OSs should adapt to database services,  There will be a small number of dominant cloud vendors, who will attempt to get you on board with proprietary options — be ready to make the best decision for your organization.

Speakers
avatar for Michael Stonebraker

Michael Stonebraker

Chief Technology Officer, Paradigm4 and Tamr, Inc
Dr. Stonebraker has been a pioneer of data base research and technology for more than forty years.  He was the main architect of the INGRES relational DBMS, and the object-relational DBMS, POSTGRES.  These prototypes were developed at the University of California at Berkeley where... Read More →


Wednesday December 1, 2021 4:00pm - 4:45pm GMT
 
  • Timezone
  • Filter By Date Postgres Build 2021 Nov 30 -Dec 1, 2021
  • Filter By Venue Venues
  • Filter By Type
  • Break
  • Cloud and Kubernetes
  • Demo
  • Keynote
  • Panel
  • PostgreSQL for the Enterprise
  • PostgreSQL Tools and Features
  • PostgreSQL Use Cases