2ndQuadrant Webinars

Learn from Globally Renowned PostgreSQL Experts

Webinars by 2ndQuadrant

2ndQuadrant’s webinar series highlights important functions and features of PostgreSQL while allowing you to engage with globally recognized PostgreSQL experts. As the largest collective group of contributors in a single organization, 2ndQuadrant’s webinars give you access to learn information first hand from the experts that contributed to the code.

Upcoming Webinar

All you need to know about CREATE STATISTICS

Date and Time: Wed, February 26, 2020 at 4pm UTC

This webinar will give an overview on CREATE STATISTICS in PostgreSQL. This command allows the database to collect multi-column statistics, helping the optimizer understand dependencies between columns, produce more accurate estimates, and better query plans.

The following key topics will be covered during the webinar:

  • Why CREATE STATISTICS is needed
  • How the command helps the optimizer and in query planning
  • Which cases CREATE STATISTICS addresses
  • What improvements related to CREATE STATISTICS are in store for future PostgreSQL versions

Speaker: Tomas Vondra, Database Engineer at 2ndQuadrant

The State of (Full) Text Search in PostgreSQL 12

The State of (Full) Text Search in PostgreSQL 12

Date and Time: Thu, March 12, 2020 at 4pm UTC

This webinar will talk about how to navigate the rich but confusing field of (Full) Text Search in PostgreSQL. It will include a short introduction about the concepts involved, followed by a discussion of functions, operators, indexes, and collation support in Postgres in relevance to searching for text. It will also provide examples of usage, along with some stats demonstrating the differences.

Speaker: Jimmy Angelakos, Senior PostgreSQL Architect at 2ndQuadrant

Identity Columns and Generated Columns in PostgreSQL_WebinarPage

Identity Columns and Generated Columns in PostgreSQL

Date and Time: Thu, April 2, 2020 at 4pm UTC

This webinar will cover using and managing Identity Columns and Generated Columns in PostgreSQL, with a focus on real-world use cases.

Identity Columns offer a standard-conforming and robust way to create auto-incrementing fields in tables. Generated Columns are computed from other columns and enable more flexible schema design and performance benefits for your database.

Key topics covered in this webinar will be:

  • Creating Identity Columns
  • Managing Identity Columns
  • Identity Columns vs. other auto-incrementing column methods
  • Creating Generated Columns
  • Stored vs. Virtual columns
  • Replacing triggers with Generated Columns

Speaker: Peter Eisentraut, Chief Technology Officer at 2ndQuadrant

Past Webinars

Application Schema Migration Webinar

Application Schema Migration

This webinar covered the issues we face with Database schemas in production databases, aiming at a technical audience of both application architects and devops/SREs/DBAs. It also covered the options you have for updating those schemas as your application evolves, covering the various difficulties you will face. This webinar was conducted by Simon Riggs, Founder and CEO of 2ndQuadrant.

BDR – Latest Features & Updates

This webinar aimed to bring you up-to-speed with the latest features, a comprehensive analysis of its architecture, Disaster Recovery, Latency and Worldwide Clusters with BDR, making applications compliant with BDR and the cutting edge use-cases. This webinar was conducted by Simon Riggs, Founder and CEO of 2ndQuadrant.

You forgot to put the WHERE in DELETE?

This webinar discussed Disaster Recovery options in Postgres and how PITR can help in certain scenarios. The other topics covered in the webinar were: Description of database backups, Types of backups you can take from a PostgreSQL server, Different use cases for backups, Disaster scenarios and best ways to recover from them and things to consider when taking backups. This webinar was conducted by Martín Marqués, Head of Support Operations at 2ndQuadrant.

Webinar: Using SSL with PostgreSQL and pgbouncer

Using SSL with PostgreSQL and pgbouncer

This webinar covered the following topics: What SSL provides – encryption and authentication, Levels of SSL verification, Client certificates and server certificates, Use of self-signed certificates for testing, Creation and use of Certificate Authorities, Use of intermediate Certificate authorities, SSL cipher suites, Server settings for SSL, libpq settings for SSL, Multi-factor authentication with client certificates, Setup of pgbouncer with server and client certificates, and Delegation of authentication to pgbouncer using a map. This webinar was conducted by Andrew Dunstan, PostgreSQL Architect at 2ndQuadrant.

PostgreSQL Partitioning

This webinar covered the following topics: Overview of PostgreSQL partitioning features, recent Improvements to PostgreSQL partitioning and parallelism, specific use cases and how partitioning works in each case and what PostgreSQL partitioning features to expect in the future.

New Features in PostgreSQL 12

This webinar covered the following topics: Introduction to PostgreSQL 12, SQL/JSON
– Improvements to Partitioning, REINDEX CONCURRENTLY, Progress Monitoring, Generated Columns, Case-insensitive Collations and Plans for PostgreSQL 13. The webinar was conducted by Peter Eisentraut, Core Team Member of PostgreSQL project.

Business Intelligence with Window Functions in PostgreSQL

This webinar gave an overview of Window Functions in PostgreSQL and illustrate each specific feature with detailed examples. Topics covered were: Introduction to Window Functions in PostgreSQL, How to use Window Functions for business intelligence, Capabilities such as range frames, GROUPS mode and exclusions and Illustration of Window Functions specific features with detailed examples.

Postgres Vacuuming Through Pictures

This webinar covered key concepts of Postgres Vacuum and Autovacuum. It included extensive use of diagrams, illustrations, and animations to present Postgres Vacuum and tuning Postgres Vacuum concepts as well as real life stories demonstrating how tuning vacuum properly makes a difference in database performance.

Migration to PostgreSQL

This webinar covered: migration overview, why migrate to PostgreSQL, planning your migration, migrating business logic, converting data types, migrating SQL – function, procedures, triggers, typical challenges, and post-migration tests. The webinar was conducted on 26th June 2019 by Gianni Ciolli, Head of Professional Services at 2ndQuadrant.

Security and Compliance with PostgreSQL

This webinar covered: Advanced features for security in PostgreSQL, PCI compliance, Backup security, Schema level security and Row level security. The webinar was conducted on 24th April 2019 by Boriss Mejías – PostgreSQL Consultant at 2ndQuadrant.

Achieving High Availability with PostgreSQL

This webinar covered: Overview of High Availability concepts, High Availability with PostgreSQL streaming replication, Setting up a streaming replication cluster, best practices, Failover and switchover – Reconfiguring application setup, Pros & Cons of Automatic vs Manual failover, Backups and High Availability. The webinar was conducted on 26th February 2019 by Martin Marqués – Deputy Head of Support at 2ndQuadrant.

Banking on PostgreSQL – Financial Application Considerations

This webinar covered: Attributes of Financial Databases, Selecting Hardware, Maximizing Resources, Addressing Throughput, Incorporating Maintenance, High Availability and Backups. The webinar was conducted on 29th January 2019 by Shaun Tomas – Principal consultant at 2ndQuadrant.

BDR and pglogical Update

This webinar covered: Latest on pglogical and BDR, Overview of existing features, Updates on new features and Roadmap. The webinar was conducted on 8th January 2019 by Simon Riggs – CEO 2ndQuadrant.

Introduction to OmniDB

This webinar covered: What is OmniDB, Development – Past & Present, Supported DBMS, PostgreSQL Support, Interface and Features, PL/pgSQL debugger, Monitoring, Plugin System and Roadmap. The webinar was conducted on 28th November 2018 by Rafael Castro & William Ivanski – Principal Consultants at 2ndQuadrant.

PostgreSQL is NOT your Traditional SQL database

This webinar covered: Design choices of PostgreSQL, Arrays, Enum, JSON, JSONB and GIN, Full-Text Search in PostgreSQL and Why choose PostgreSQL? The webinar was conducted on 30th October 2018 by Gülçin Yıldırım Jelínek .

New features in PostgreSQL 11

This webinar covered: Introduction to PostgreSQL 11, Improvements to partitioning and parallelism, Stored procedures, JIT compilation, Security and Plans for PostgreSQL 12. The webinar was conducted on 2nd October 2018 by Peter Eisentraut – Major PostgreSQL Contributor, 2ndQuadrant.

Database Security in PostgreSQL

This webinar covered: Introduction to Database Security, PostgreSQL Security Architecture, PostgreSQL encryption, mandatory access control, roles, privileges, and row-level security, SASL Authentication plugins and SCRAM-SHA-256 authentication. The webinar was conducted on 12th September 2018, by Kirk Roybal – Principal Consultant, 2ndQuadrant.

Ansible & PostgreSQL

This webinar covered: Overview of Ansible and PostgreSQL, Best strategies for mixed cloud and on-premises deployments, How to create a variety of cluster types, How to deploy AlwaysOn PostgreSQL clusters and perform maintenance updates, How to backup servers for mixed on-premises and multi-cloud deployments. The webinar was conducted on July 2018 by Tom Kincaid – General Manager North America, 2ndQuadrant.

Introduction to BDR

This webinar covered: Introduction to BDR, BDR Architecture, High Availability, Disaster Recovery, Rolling Upgrades, Latency and Geographical Distribution with BDR, Common use cases for BDR and Making applications compliant with BDR. The webinar was conducted on 16th May 2018, by Simon Riggs – CEO 2ndQuadrant.

Power of Indexing in PostgreSQL

This webinar covered: Various ways to access data in PostgreSQL, Different types of indexes supported by PostgreSQL, Internals of BTree and BRIN indexes, Overview of GIN and GiST indexes and How to find missing and unused indexes. The webinar was conducted on 4th April, 2018 by Pavan Deolasee – PostgreSQL Developer at 2ndQuadrant.

Data Integration with PostgreSQL

This webinar covered: What is a Foreign Data Wrapper? How to simultaneously query MySQL, a Flat file, a Python script, a REST interface and a different Postgres Node, Stream to Kafka and Write data to… MongoDB!? The webinar was conducted on 13th February, 2017 by Shaun Thomas – Principal Consultant at 2ndQuadrant.

Introduction to JSON data types in PostgreSQL

This webinar covered: What’s the difference between JSON and JSONB? Accessing JSON values, When to use JSON, when to use JSONB, and when neither should be used. The webinar was conducted on 12th December 2017, by Andrew Dunstan – Principal Contributor of JSON functionality.

About 2ndQuadrant

2ndQuadrant provides PostgreSQL solutions for the Enterprise. Our support engineers have over 100 years of combined code contributions to the PostgreSQL project, making us the only company to contribute enterprise features to all of the last 13 releases.

This is paired with 17+ years of hands-on experience through client engagements and allows us to integrate customized solutions with our customers – making 2ndQuadrant the Gold Standard for PostgreSQL products & services.