Postgres Webinar Series Program

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

presented by Ryan Lambert

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
Bill Kendall The Architecture of a Geo-Distributed SQL Database

presented by Bill Kendall

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
2020-04-29
10:00
Chris Casano How to Deploy a SQL Database on Kubernetes

presented by Chris Casano

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
2020-05-19
10:00
dharshan rangegowda Working with JSON Data in PostgreSQL vs. MongoDB

presented by dharshan rangegowda

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
Unscheduled events
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

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

Ryan Lambert Getting Started with PostGIS and OpenStreetMap

presented by Ryan Lambert

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

GIS
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

Migrations
Ryan Lambert Exploring OpenStreetMap from PostGIS:  Tools and Queries

presented by Ryan Lambert

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.  

GIS
Ryan Lambert Loading PostGIS with osm2pgsql

presented by Ryan Lambert

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.

GIS
Ryan Lambert PostGIS Spatial Queries and Performance Tuning

presented by Ryan Lambert

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.

GIS
Ryan Lambert PostgreSQL 12 and PostGIS 3.0

presented by Ryan Lambert

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.

GIS
 Erik Brandsberg Enterprise Authentication and Connection Pooling

presented by Erik Brandsberg

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.