Postgres Build 2021 has ended

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

PostgreSQL Tools and Features [clear filter]
Tuesday, November 30

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.

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

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!

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

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!

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

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.

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

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.

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

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

avatar for Marc Linster

Marc Linster

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
Wednesday, December 1

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.

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

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.

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

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.

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

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.

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

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.

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

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.

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

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.

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