Postgres Webinar Series Program

2020-01-06
11:00
Ryan Lambert Getting Started with PostGIS and OpenStreetMap

presented by Ryan Lambert


video

This is the first of six (6) sessions covering how to find, load, and consume OpenStreetMap data using PostGIS and PostgreSQL. This session covers what PostGIS and OpenStreetMap are, and why they are important in our modern world. No prior experience with PostGIS or OpenStreetMap is required for this introductory session.

The session recording and links shown are available at: https://blo...

more

11:00 - 12:00 Online GIS
2020-01-14
11:00
Ryan Lambert Loading PostGIS with osm2pgsql

presented by Ryan Lambert


video

This session dives into how to install, configure and use osm2pgsql on Linux to load OpenStreetMap data into PostGIS.  Loading the data into PostGIS is the first step required to begin consuming and leveraging OpenStreetMap data.  Where to download OSM data, best practices, helpful tricks and common pitfalls are all covered.

11:00 - 12:00 Online GIS
2020-01-28
11:00
Ryan Lambert Exploring OpenStreetMap from PostGIS:  Tools and Queries

presented by Ryan Lambert


video

This session introduces the tools, concepts and basic queries needed for working with spatial data stored in PostGIS.  Building on the prior session, this session illustrates how to query and visualize OpenStreetMap data loaded to PostGIS.  Tools discussed in this session include GUI software as well as on-line resources for learning more about OpenStreetMap's Key/Value data structure.  

11:00 - 12:00 Online GIS
2020-02-11
11:00
Ryan Lambert PostGIS Spatial Queries and Performance Tuning

presented by Ryan Lambert


video

This session is a deep dive into complex spatial queries and performance tuning with PostGIS.  Common performance headaches are explored with a variety of approaches to remedy.  GIST indexes, proper data modeling, and materialized views are demonstrated.

11:00 - 12:00 Online GIS
2020-02-12
10:00
 Erik Brandsberg Enterprise Authentication and Connection Pooling

presented by Erik Brandsberg


video

Join us in learning all about Enterprise Connection Pooling and Authentication with Postgres! In this digital breakout session you will learn how to:

  • Reduce Postgres resource utilization with with per user and global connection pooling limits.
  • Simplify database access management with 1) Active Directory and LDAP and 2) Group extraction for Postgres.

10:00 - 11:00 Online Ops
2020-02-19
11:00
Andrew Ellicott Sebastian Dressler FPGA: an Easier Path to Parallelism for Postgres?
It’s easier than you think! Accelerating query performance 55x with FPGA

presented by Andrew Ellicott and Sebastian Dressler


video

Amazon recently announced FPGA acceleration for Redshift, most clouds now offer FPGA-equipped instances, and FPGA prices are dropping.

Is it time for you to consider hardware acceleration for Postgres?

Adding an FPGA processor to your free, open source Postgres server, along with the Swarm64 FPGA extension for Postgres, enhan...

more

11:00 - 12:00 Online Ops
2020-02-26
11:00
Ryan Lambert PostgreSQL 12 and PostGIS 3.0

presented by Ryan Lambert


video

PostgreSQL 12 and PostGIS 3.0 bring an amazing plethora of improvements to PostGIS-enabled databases.  This session highlights a number of reasons to upgrade to the latest and greatest versions!  Parallel query improvements, generated columns and covering GIST indexes are some of the highlights.

11:00 - 12:00 Online GIS
2020-03-03
11:00
Ryan Lambert Advanced Operations and Features

presented by Ryan Lambert


video

This final session focuses on PostGIS, scratching the surface of a range of the advanced operations PostGIS is capable of.  Preparing data in a different formats (GeoJSON, MVT) for external dependencies, 3D rendering, and routing are some of the topics covered.

11:00 - 12:00 Online GIS
2020-04-15
10:00
Jim Walker The Architecture of a Geo-Distributed SQL Database

presented by Jim Walker


video

Join us for a deep dive into the internals of CockroachDB, an open source, distributed SQL database. In this technical presentation, Bill Kendall will cover the usage of Raft for consensus, the challenges of data distribution, distributed SQL execution, and how CockroachDB has solved some of the thornier challenges of distributed ACID transactions and SQL optimization.

10:00 - 11:00 Online Dev
2020-04-29
10:00
Chris Casano How to Deploy a SQL Database on Kubernetes

presented by Chris Casano


video

CockroachDB was architected as a cloud-native database and is a perfect choice for your distributed applications and services that run on Kubernetes. Please join us for this webinar where we will provide a hands-on demo of running CockroachDB on Kubernetes. We will talk through:

  • How to use Persistent Volumes with each CockroachDB pod
  • How to use Replica Sets to manage the cluster
  • Atta...
more

10:00 - 11:00 Online Ops
2020-05-06
19:00
Henrietta Dombrovskaya NORM - Bridging the Gap Between Applications and Databases

presented by Henrietta Dombrovskaya

Life without ORM - is it possible and how we can get there? In this talk, Hettie will present the approach developed and implemented at Braviant Holdings. NORM (No-ORM) allows building performant and scalable applications and is praised by developers for its ease of use.

19:00 - 20:00 Online Dev
2020-05-07
10:00
Joshua D. Drake Erez Alsheich How to Move Data from Oracle to Postgres in Near-Real Time
Increasing performance and reducing complexity of migrations

presented by Joshua D. Drake and Erez Alsheich

Replicating live data (thousands of events per second) from Oracle to Postgres doesn’t have to be difficult. But the latency and complexity of traditional solutions, such as ETL, legacy CDC and homegrown scripts, have proven to be costly and inefficient. When you are replicating live data from one data platform to another, the process should be simple, inexpensive and as near real time as poss...

more

10:00 - 11:00 Online Migrations
2020-05-12
10:00
Bryn Llewellyn YugabyteDB: a distributed PostgreSQL database

presented by Bryn Llewellyn


video

YugabyteDB is an open-source, cloud-native, high-performance database that belongs in the emerging distributed SQL category. Its storage layer uses a “shared nothing” architecture inspired by Google Spanner that brings linear write scalability, low read latency, and intrinsic fault tolerance. And, uniquely in its category, its query layer is implemented by using the “upper half” of the PostgreS...

more

10:00 - 11:00 Online Case Study
2020-05-21
11:00
Ibrar Ahmed A Deep Dive into PostgreSQL Indexing

presented by Ibrar Ahmed


video

Indexes are a basic feature of relational databases, and PostgreSQL offers a rich collection of options to developers and designers. To take advantage of these fully, users need to understand the basic concept of indexes, to be able to compare the different index types and how they apply to different application scenarios. Only then can you make an informed decision about your database index...

more

11:00 - 12:00 Online Ops
2020-06-02
10:00
Joshua Drake Alton Dinsmore How to Move Data from Oracle to Postgres in Near-Real Time

presented by Joshua Drake and Alton Dinsmore


video

Replicating live data (thousands of events per second) from Oracle to Postgres doesn’t have to be difficult. But the latency and complexity of traditional solutions, such as ETL, legacy CDC and homegrown scripts, have proven to be costly and inefficient. When you are replicating live data from one data platform to another, the process should be simple, inexpensive and as near real time as possi...

more

10:00 - 11:00 Online Ops
2020-06-09
11:00
Justin Reock Community vs. Enterprise Open Source – Which is Right for Your Business?

presented by Justin Reock


video

New monetization models such as open core have presented questions for IT professionals. Do we stick with the freedom and agility of community releases, or do we pay for the enterprise counterparts? Explore patterns in Enterprise Edition add-ons, look at some concrete examples such as Confluent vs. Kafka, and be better prepared to decide where you spend your open source license dollars.

11:00 - 12:00 Online Case Study
2020-06-10
11:00
Tong Zhang Bring Compression to Postgres at Zero Cost of Performance

presented by Tong Zhang


video

This talk will present a solution that allows Postgres users to achieve significant data storage savings through compression at zero CPU/performance cost. The key is to deploy Postgres on new compression-capable solid-state drives (SSDs), which is developed following the current industry trend of empowering data storage devices with additional computing capability. This proposed talk will discu...

more

11:00 - 12:00 Online Case Study
2020-06-16
11:00
Avinash Vallarapu Mostly mistaken and ignored PostgreSQL parameters while optimizing a PostgreSQL database

presented by Avinash Vallarapu


video

Optimizing a PostgreSQL database may be a challenge if some of the important parameters are ignored. And a bigger challenge may be the understanding of the algorithm behind setting those parameters correctly. In my experience with PostgreSQL Consulting for more than a decade, I have seen a bigger list of parameters that are wrongly set or ignored. This talk details a list of important PostgreSQ...

more

11:00 - 12:00 Online Ops
2020-06-17
11:00
Luis Manuel Carril Michael Tegtmeier Postgres vs. MongoDB for real-time machine learning on wind turbine data

presented by Luis Manuel Carril and Michael Tegtmeier


video

Wind turbines generate a large amount of SCADA data, approximately 500 different metrics each second. Turbit Systems captures and analyzes wind turbine data in real time, using machine learning algorithms to automatically detect the slightest technical fault, recommend corrective measures, and continuously improve turbine behavior and efficiency.

In this webinar, you’ll learn why Turbit Syst...

more

11:00 - 12:00 Online Case Study
2020-06-23
10:00
Julian Fischer Turning PostgreSQL into a Cloud Native Data Service
Lessons learned from operating thousands of PostgreSQL servers

presented by Julian Fischer


video

In this talk you will learn about the distilled experience of operating thousands of PostgreSQL database servers. The presentation covers feedback gathered from operating a full lifecycle automation for PostgreSQL across all major on-premise and public infrastructures. Find out how enterprise requirements can be met at scale using state of the art open source tools. A series of common pitfalls ...

more

10:00 - 11:00 Online Case Study
2020-06-25
10:00
Jim Walker Chris Casano Scaling PostgreSQL: Never Shard Again and Gain Effortless Scale

presented by Jim Walker and Chris Casano


video

Sharding is how most of us scale Postgres. It works, however, it is not without its challenges. What key should we shard on? How big will my shards need to be? How will sharding affect performance? What application-level mods will need to happen? What happens if we need to re-shard the database?

Automating the sharding process seems right. We should be able to define a shard and let the db t...

more

10:00 - 11:00 Online Case Study
2020-06-30
11:00
Jobin Augustine Deeper Understanding of PostgreSQL Execution Plan: At plan time and run time

presented by Jobin Augustine


video

Right execution plans can deliver maximum performance and throughput from your PostgreSQL database. It is important to understand all factors which affect the execution plan which includes costing, datatypes, indexing, filter and join conditions, pruning, runtime exclusions, etc. Poor understanding of the planner leads to suboptimal performance. There are substantial improvements in new vers...

more

11:00 - 12:00 Online Ops
2020-07-07
10:00
Ibrar Ahmed A Deep Dive into PostgreSQL Indexing

presented by Ibrar Ahmed


video

Indexes are a basic feature of relational databases, and PostgreSQL offers a rich collection of options to developers and designers. To take advantage of these fully, users need to understand the basic concept of indexes, to be able to compare the different index types and how they apply to different application scenarios. Only then can you make an informed decision about your database index st...

more

10:00 - 11:00 Online Ops
2020-07-15
10:00
dharshan rangegowda Working with JSON Data in PostgreSQL vs. MongoDB

presented by dharshan rangegowda


video

Developers love working with JSON. Document stores like MongoDB have proved to be very popular. Both MongoDB and PostgreSQL have built-in support for the 'JSON' data type. Understand the pros and cons of working with JSON in both of these databases - when should you use MongoDB vs. PostgreSQL? If you are already comfortable with PostgresSQL, should you continue to use it for your JSON data? In ...

more

10:00 - 11:00 Online Dev
2020-07-29
10:00
John Ashmead Debugging with PostgreSQL
A Strategic Approach

presented by John Ashmead


video

Depending on the project, debugging can take 50 to 90% of development time. But it usually gets less than 10% of the press. PostgreSQL has great tools for debugging, but they are most effective when deployed as part of an overall strategy.

We will look at strategies for debugging PostgreSQL: how to find bugs, how to fix them, and how to keep them from happening in the first place.

We’ll l...

more

10:00 - 11:00 Online Dev
2020-09-09
10:00
Sebastian Dressler PostgreSQL Parallelism Do’s and Don’ts

presented by Sebastian Dressler


video

Join us on September 9 for a 45-minute webinar on parallelism in PostgreSQL.

PostgreSQL can apply parallel processing to speed up query performance. But the PostgreSQL query planner and internals are complex, making it a challenge to predict how parallel processing will affect different queries.

In this webinar, you’ll learn parallelism best practices to maximize your PostgreSQL query pe...

more

10:00 - 11:00 Online Dev
2020-09-15
10:00
David Orlandi Monitoring Strategy Considerations

presented by David Orlandi


video

IT Administrators need to keep an eye on Availability, Performance, and Storage of mission- critical environments. There are many things to consider as you develop a Monitoring and Diagnostics strategy. Items to consider include:

  • All-in-one or Specialized?
  • Build vs Buy
  • Real-time diagnostics vs 24x7 monitoring
  • Architecture: Agents? Overhead? Flexibility?
  • Configuration: On-...
more

10:00 - 11:00 Online Ops
2020-09-16
10:00
Randy Chertkow How To Query Against Multiple Postgres Instances As If They're One Server Using Starburst Presto

presented by Randy Chertkow


video

When the data you need is located in multiple servers you're faced with time-consuming and difficult choices to query it. The easy button for solving this is to use open-source abstraction layers such as Starburst Presto which just needs the connection string for each of the servers to create a single federated point of access for you. The Presto abstraction layer:

  • Connects your Postgres...
more

10:00 - 11:00 Online Dev
2020-09-29
10:00
Sebastian Dressler Introduction to PostgreSQL ColumnStore Indexes

presented by Sebastian Dressler


video

Join us on September 29 for a 45-minute introduction to ColumnStore indexes in PostgreSQL.

Swarm64 DA 5.0 introduces ColumnStore indexes for PostgreSQL, which can be defined for any table and greatly reduce I/O to speed up query performance. They are ideal for data warehousing and analytics workloads.

Swarm64 Solution Architect, Sebastian Dressler, will cover the following:

  • How C...
more

10:00 - 11:00 Online Dev
2020-09-30
10:00
Randy Chertkow Live Demo: Creating A Single Point Of Access To Multiple Postgres Servers Using Starburst Presto

presented by Randy Chertkow


video

Starburst Presto is an open-source method to create a single point of access to multiple Postgres servers at once. In the first session, you saw the architecture and technology behind it. This session will:

  • Review the architecture and environment of Presto.
  • Share the practical considerations and engineering choices for deploying Starburst Presto to solve your problems.
  • Show the mos...
more

10:00 - 11:00 Online Data
2020-10-06
09:00
Kohei KaiGai Data processing more than billion rows per second

presented by Kohei KaiGai


video

Nowadays, GPU is not only for computing intensive workloads, but for I/O intensive big-data workloads also.

This talk introduces how SSD-to-GPU Direct SQL, implemented as extension of PostgreSQL, optimizes data flow from storages to processors over PCIe-bus for efficient execution of analytic/reporting workloads.

Combination of this technology with comprehensive database features (e.g, co...

more

09:00 - 10:00 Online Data
2020-10-07
10:00
Jim Walker Chris Casano Database Isolation Levels, Data Issues and Global Transaction Consistency

presented by Jim Walker and Chris Casano


video

Dirty reads, phantom reads, write skew, ACID rain? These are all data concerns that are often overlooked, but can be very troubling and super expensive. Are you familiar with database isolation levels and how they can impact these data integrity?

In this session, we walk through a definition of these potential data issues and then map them talk about database isolation levels. We will then...

more

10:00 - 11:00 Online Data
2020-10-20
10:00
Eric Ridge PGX: Build Postgres Extensions with Rust

presented by Eric Ridge

With PostgreSQL recently being voted the second-most loved database, and Rust being voted the most loved programming language, it's about time we be able to integrate the two.

PostgreSQL's extension system is second-to-none, however its main barriers are the need for a background in C and an understanding of Postgres' source code.

"pgx" aims to mitigate these barriers by providing a P...

more

10:00 - 11:00 Online Ops
2020-10-21
10:00
James E. Marca Using PostgreSQL, PostGIS, and pgRouting for street sweeping

presented by James E. Marca

In responding to an RFP to optimize and improve street sweeping routes for a small city in California, we developed a solver based on Google's Operations Research Tools. While the guts of the solver uses OR-Tools, virtually everything else about the project is made possible by PostgreSQL, PostGIS, and pgRouting.

In this presentation, I talk about the various ways PostgreSQL and friends made ...

more

10:00 - 11:00 Online Case Study
2020-10-27
10:00
Pat Wright Logical Replication lessons learned for the Data Warehouse

presented by Pat Wright

Logical Replication was released in Postgres version 10. We have been using it for a Data Warehouse system for the last year and this talk will show you how to set it up for a Data Warehouse system and some of the pitfalls you will run into. We will have the opportunity to discuss what replication you should be using depending on the work you are doing. Perhaps Logical Replication is not the be...

more

10:00 - 11:00 Online Data
2020-10-28
10:00
Henrietta Dombrovskaya How to build local communities: a meetup perspective

presented by Henrietta Dombrovskaya

Today, Chicago PUG is the third-largest in the Western Hemisphere, but it was not the case three years ago. It is easy to announce a new User Group, but how to keep it running and growing? Nobody expected new pandemic and the effect it will take on our lives. The Open Source communities, including Postgres community, which live and breath live discussions, were hit heavily. How did we manage? W...

more

10:00 - 11:00 Online Case Study
2020-11-05
10:00
Ibrar Ahmed All about PostgreSQL Security

presented by Ibrar Ahmed

PostgreSQL provides different levels of security. This talk will cover all the available security techniques used in PostgreSQL 13. We’ll look at client-side security (LibPq, JDBC) through to server-side security. It will cover all supported authentication methods and the pros and cons of all these methods. Some of the key features of the talk are:

  • Introduction to Cryptography
  • SSL, TLS,...
more

10:00 - 11:00 Online Data
2020-11-10
10:00
Hans-Jürgen Schönig CYPEX: Revolutionizing PostgreSQL Application Development

presented by Hans-Jürgen Schönig

CYPEX is a user-friendly tool to quickly build PostgreSQL applications. Little coding is needed to achieve big results – which makes it one of the fastest development tools for PostgreSQL. Traditional application development has taken a lot of precious time which is not feasible anymore. Empower professional developers and enable everyone else in your organization to be a part of the solut...

more

10:00 - 11:00 Online Dev
2020-11-12
10:00
Abdullah Uz Tansel Blockchain as a Database

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

more

10:00 - 11:00 Online Data
Unscheduled events
Randy Chertkow Unlock Data In Postgres and Query It With Other Sources

presented by Randy Chertkow

Accessing all the platforms your data resides in continues to be a limitation across industries. With standards based SQL abstraction layers, you can create a single point of entry to a diverse set of data sources. Learn how Open source Presto easily provides access to all of your Postgres installations and other data stores as if it were a single data warehouse.

This session will:

  • Show...
more

Data