2021 Postgres Conference Webinars Program

presented by Sathish Kumar Thiyagarajan

Traditionally, we use Languages and Frameworks interact with Relational Databases. While these are effective in many ways, One problem is that, each of these brings new learning curve. It will be nice if we use SQL itself as the core skill and build application with plain simple SQL skills. In this webinar, I will demo this approach with a case study that builds simple, high performing Java app...

presented by Tatiana Krupenya and Sergei Rider

The number of PostgeSQL forks keeps growing. Some of them are really ancient, while others are relatively new.

Redshift, Greenplum, Cockroach, Timescale, RDS, Vertica, you name it. All modern clouds have their own forks of traditional PostgreSQL.

But are these databases our familiar PostgreSQL, or something absolutely different?

DBeaver supports all the main PostgreSQL forks, and we c...

presented by Igal Sapir

As Postgres gains popularity in the DBMS world, it has become a very attractive alternative for Microsoft SQL Server, allowing organizations that make the leap to take advantage of modern features while saving big money on software licensing. In this talk I will go over the top reasons to choose Postgres over SQL Server and outline a plan for performing such migrations.

Key learnings:

• ...

presented by Sebastian Dressler

Are you using PostgreSQL for query-intensive applications like reporting and charting, analytics (OLAP/HTAP), or data warehousing?

Join us on February 4 to learn straightforward ways to get the best possible query performance from PostgreSQL.

Swarm64 Solution Architect, Sebastian Dressler, will cover proven PostgreSQL configuration tuning best practices that have helped PostgreSQL users s...

presented by Abdullah Uz Tansel

Throughout the history, exchange of trusted information among people played an essential role in every aspect of their lives: socially, economically and politically. Blockchain is an innovation in database technology for keeping temper proof (trusted) data in a permanent, immutable, decentralized, global, and trustless ledger. It combines distributed computing, databases, networks and cryptogra...

presented by Sambhav Jain

This webby will quickly take you through the journey of understanding and (subsequently) debunking the myths around the importance of indexing in improving database performance. We will look at the core indexes in addition to some extensions that might just make your applications blazing fast, if implemented right. This webby will cover:

• In-built index types in PostgreSQL
• 3rd-party ...

presented by Jessica Sharp

Do you support the PostgreSQL database behind a demanding application? Do your users have queries that mysteriously get progressively slower over time and then run normally again without explanation? Is AutoVacuum working on a particular table(s) almost all the time? This presentation offers guidance on identifying good practices around monitoring AutoVacuum, how to approach tuning, and how to ...

presented by Erik Brandsberg

Database proxies intelligently manage Postgres connections to improve performance and scale. In this session, we will highlight deficiencies of 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 failove...

presented by Ryan Lambert

This session will be a live demo to show how easy it is to import high quality OpenStreetMap data into PostGIS / Postgres. The long-used osm2pgsql tool has a new Flex output (Flex == "flexible") that has completely changed the game! This demo highlights how the osm2pgsql Flex output is being used by PgOSM-Flex to provide a high quality "off-th...

presented by Benjamin Rogojan

Interview Query recently reported that the number of data engineering roles at companies continues to grow annually, where as surprisingly, the number of data scientists has shrank back in comparison.

Data engineers spend much of their time building data pipelines and managing data warehouses, and there are lots of tools for data engineers to choose from when it comes to developing data ...

presented by Philip Schlump

Blockchains provide a number of useful features that a traditional SQL database fails to provide. These include immutable data, consensus and data replication.

In this example a authenticated blockchain is implemented by using a number of features of PostgreSQL and extending PostgreSQL to allow for Peer To Peer (P2P) communication and block consensus.

This also acts as a good example ...

presented by Vlad Ilyushchenko and Brian Smith

The nature of time series data means that 90% of the transactions occurring are new records being inserted, and queries are most likely to be recent time ranges. The Open Source QuestDB is optimized for this usage pattern. We have several features that provide high-performance inserts and reads over other PostgreSQL based Time Series solutions. This webinar covers how storage and ingestion work...

presented by Ahsan Hadi

Finally we have stored procedures in PostgreSQL 11, better late than never.

PostgreSQL versions prior to 11 only supported functions, the support for stored procedures was added in PostgreSQL 11. It is added as a new schema object which is similar to functions and but without a return value and with some subtle differences and benefits.

The main benefits of Stored procedure are the follow...

presented by Andy Pavlo

Database management systems (DBMS) expose dozens of configurable knobs that control their runtime behavior. Setting these knobs correctly for an application's workload can improve the performance and efficiency of the DBMS. But such tuning requires considerable efforts from experienced administrators, which is not scalable for large DBMS fleets. This problem has led to research on using machine...

presented by Andrew Ellicott

Do you need faster Amazon RDS query performance? Need to scale end-user reporting and dashboarding in your RDS applications or add more complex analytics?

Join us to learn about PG Nitrous, a new PostgreSQL cloud solution hosted on AWS EC2 by Swarm64. In this webinar we will demonstrate how to accelerate Amazon RDS PostgreSQL query performance by 30x by using PG Nitrous as a fast-query repli...

presented by Alex Arica

Kubegres is a Kubernetes operator allowing to deploy a cluster of PostgreSQL instances with data replication, failover and backup enabled out-of-the box. It brings simplicity when using PostgreSQL considering how complex managing stateful-set's life-cycle and data replication could be with Kubernetes. To manage replications, failover and backup, Kubegres is 100% rely...

presented by Christopher Travers

When things go wrong with large, heavily loaded systems, it can take a significant amount of time to recover. For this reason, the same response patterns with other critical systems (nuclear power plants, jumbo jets) apply to disaster management here as well.

This talk is a story of how we at Adjust managed one such disaster and what you can learn from it. The talk will also include what w...

presented by Alvaro Hernandez

Today, running Postgres on Kubernetes is not out of the ordinary. But given all of Kubernetes capabilities, doing a 1:1 between how you run Postgres on Kubernetes and how you run it outside of it is a loss of opportunity.

The Open-Source StackGres (https://stackgres.io) project has leveraged Kubernetes API to its fullest to make Postgres not run, but fly, on Kubernetes! Join this webinar w...

presented by Bruce Momjian

This presentation highlights the challenges of building and managing an open source team of volunteers. Topics include motivation, communication, and project management.

presented by Abbas Butt

This presentation will provide step by step details on how to deploy a highly available PostgreSQL cluster using Patroni, etcd and HAProxy. Patroni is a python based solution to provide HA and automatic failover in a PostgreSQL cluster. Patroni depends on etcd and HAProxy to provide all the features. This presentation will provide steps to deploy and test etcd and HAProxy independently. Once ...

presented by Zohaib Sibte Hassan

The talk is based on my original article that I wrote back in 2011 and followed up with friend feed case study. We will do a walk through history of HSTORE, and how we can now use JSONB support in PostgreSQL, discuss wha...

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

presented by Bruce Momjian

This presentation explains how open source software can live for a very long time, and covers the differences between proprietary and open source software life cycles. It also covers the increased adoption of open source, and many of the ways that Postgres is innovating to continue to be relevant.

presented by Bryn Llewellyn

Students of Computer Science are often given this famous assignment:

• Compute the Bacon numbers for actors listed in the IMDb up to, for example, five hops

The requirement is easy to understand and is readily communicated by the example "What is Al Pacino’s Bacon Number?" The answer is given by this path, where each step goes via a movie or TV show that starred some pair of actors: ...

presented by Justin Reock

The emergence and adoption of DevOps practices at scale, following "Constraints"-based approaches such as Agile and Lean, has helped many businesses optimize their production strategy and keep pace with customer demand. Despite these advancements, hidden productivity bottlenecks still exist in our common build, test, and CI practices. Developers spend an inordinate amount of time waiting on fee...

presented by Henrietta Dombrovskaya

Some queries just can’t run in a fraction of a second, no matter how well written. This does not mean they can’t be optimized. Many practitioners hold that since analytical reports do not have strict response time requirements, it is not important how fast or slow they run. In extreme cases, report developers make no effort to make sure that reports are complete in a reasonable time, giving the...

presented by Amit Kapila

Logical replication has been there since 10.0 and with each release, it is getting better. This talk will start with the basic architecture of Logical replication in PostgreSQL and then cover the various ways in which it can be helpful to users.

One of the shortcomings of logical replication as compare to physical replication is that currently, it allows the transaction to be replicated...

presented by Charly Batista

During this talk we will explain how PostgreSQL organizes the data internally, how the Free Space Map (FSM) works and how we can reorganize the data model to take advantage of data alignment inside blocks reducing the size of the data in disk and consequently in memory, which can save money and improve performance.

presented by Justin Reock

Our first session focused on some of the theory behind the emerging practice of Developer Productivity Engineering (DPE) and some of the key metrics that should be observed and improved to ensure developer success. In this session, we will focus on the first major productivity bottleneck that DPE addresses -- the amount of time it takes for developers to get feedback about their build, and the...

presented by John Ashmead

We will use Ruby-on-Rails to build a PostgreSQL backed website. We'll use some of the excellent tutorials to build a small site with users and micro-content. We’ll talk about what to watch out for, which tasks to leave to the web framework, what to do on the database side. We'll show the various stages of development and we will leave the final product up on the web, for your use. To add a b...

presented by Henrietta Dombrovskaya

Functions are among the most underused and misused of PostgreSQL objects. Since all modern programming languages include user-defined functions, people often assume that database functions are cut from the same cloth and if you know how to write functions and when to write functions in an application programming language, you can apply this knowledge to PostgreSQL. This could not be further fro...

presented by Bryn Llewellyn

Anecdotal reports indicate that PostgreSQL neophytes are daunted by the date and time data types, and by how operations that use values of these data types might be affected by the session's timezone setting. They find the topic to be mysterious and frightening. Even experienced developers struggle when they first embark on a critical project that relies on this functionality.

I recently com...

presented by Justin Reock

Our first two sessions focused on Developer Productivity Engineering (DPE) as a practice and the specific tools and techniques used to accelerate the software build process. Acceleration of the build is only one facet of an overall DPE strategy, as significant opportunities for improvement still exist for businesses in the time spent waiting on test executions to complete. Most build systems ...

presented by Jobin Augustine

There have been many presentations about the Different Indexes in PostgreSQL ( B-Tree, HASH, GIN, GiST etc), especially from the architecture perspective. But these talks always lacked details from the user perspective on the selection of indexes.
It is common to see that architects and developers fail to select the right types of index and the way it should be used.
Just an overview of ...

presented by Jobin Augustine

The Partitioning features in PostgreSQL is not something new. But it has matured over several years, release after release, especially the last 4 releases.
The evolutionary nature (small changes in each version) is often overlooked by users.
These small changes resulted in a build-up of a powerful Partitioning capability in PostgreSQL new versions. Now it is considered as capable of even...