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 Webinars

Postgres Vacuuming Through Pictures

Date and Time: Wed, July 24, 2019 at 4pm UTC

This webinar will cover key concepts of Postgres Vacuum and Autovacuum. It will include 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.

Primary topics covered in this webinar are:

  • Overview
  • Key Concepts behind Vacuum and Autovacuum
  • Vacuum Operations
  • Tuning Vacuum for Postgres deployment
  • Real-life examples of Tuning Vacuum

Speaker: Tom Kincaid | General Manager North America

Geo Spatial Application Development with PostGIS

Geo Spatial Application Development with PostGIS

Date and Time: Wed, August 28, 2019 at 4pm UTC

Topics covered in this webinar will be added later.

Speaker: TBA

Past Webinars

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 by Gianni Ciolli, Head of Professional Services at 2ndQuadrant on 26th June 2019.

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 by Boriss Mejías – PostgreSQL Consultant at 2ndQuadrant on 24th April 2019.

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 by Martin Marqués – Deputy Head of Support at 2ndQuadrant on 26th February 2019.

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 by Shaun Tomas – Principal consultant at 2ndQuadrant on 29th January 2019.

Postgres-BDR and pglogical Update

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

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 by Rafael Castro & William Ivanski – Principal Consultants at 2ndQuadrant on 28th November 2018.

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 by Gülçin Yıldırım Jelínek on 30th October 2018.

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 by Peter Eisentraut – Major PostgreSQL Contributor, 2ndQuadrant on 2nd October 2018.

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 by Kirk Roybal – Principal Consultant, 2ndQuadrant on 12th September 2018.

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 by Tom Kincaid – General Manager North America, 2ndQuadrant on 10th July 2018.

Introduction to Postgres-BDR

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

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 by Pavan Deolasee – PostgreSQL Developer, 2ndQuadrant on 4th April 2018.

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 by Shaun Thomas – Principal Consultant at 2ndQuadrant on 13th February 2018.

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 by Andrew Dunstan – Principal Contributor of JSON functionality to PostgreSQL on 12th December 2017.

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.

UK +44 (0)870 766 7756

US +1 650 378 1218

Stay in touch with us

Subscribe to our monthly newsletter to hear the latest developments from 2ndQuadrant and related technologies.

We’ll also send you any important news or updates that we think you’ll find useful.

We value your privacy and will not pass your details on to anyone else.

2ndQuadrant Updates