2ndQuadrant’s Webinar series covers a wide range of topics related to PostgreSQL. The library below includes recordings of past webinars delivered from world-class experts. Register for our upcoming Webinars here.
Performance Improvements since PostgreSQL 8.3
25 November 2020
This webinar by Tomas Vondra discussed all the performance Improvements since PostgreSQL 8.3
COMMIT Without Fear – The Beauty of CAMO
11 November 2020
This webinar by Tom Kincaid explored the Postgres Synchronous COMMIT deployment models and discussed the limitations associated with them.
Best Practices for Bulk Data Loading in PostgreSQL
28 October 2020
This webinar by Shaun Thomas explored the answers to some of the most common questions related to bulk data loading.
Managing and Monitoring PostgreSQL Clusters with OmniDB
14 October 2020
This webinar by Felipe Castro gave an overview OmniDB features and the many ways it can help a DBA manage PostgreSQL.
Highway to Zero Downtime PostgreSQL Upgrades
30 September 2020
This webinar by Martín Marqués gave a comprehensive overview of how to perform a “near” zero downtime upgrade using pglogical.
New Features in PostgreSQL 13
16 September 2020
This webinar by Peter Eisentraut explored new features & improvements in PostgreSQL 13, the new major update from the PostgreSQL community released in September 2020.
Webinar: JSON & ARRAY – Contemporary Postgres Data Types
2 September 2020
This webinar by Boriss Mejías was entirely dedicated to JSON/JSONB/ARRAY, and how to axe the archaic EAV pattern from your database.
Webinar: Similarity Queries in PostgreSQL
19 August 2020
In this webinar, the host Euler Taveira dived into the topic of Similarity Queries and presenting PostgreSQL features and extensions that can be used to tackle approximate queries.
Webinar: PostgreSQL on Windows
12 August 2020
In this webinar, Andrew talked in detail about PostgreSQL on Windows covering the brief History of PostgreSQL on Windows, GUIs, PostgreSQL Extensions/Development, and Upgrading PostgreSQL on Windows.
Webinar: Being Committed – A Review of Transaction Control Statements 3/3
5 August 2020
In the third session of this three-part webinar, Transactions and Locking, The Blind Spot of In-Flight Commit and Commit-At-Most-Once were discussed in detail.
Webinar: Being Committed – A Review of Transaction Control Statements 2/3
29 July 2020
In the second session of this three-part webinar, Replicated Transactions, Performance Expectations, and Hidden Costs of Transactions were discussed in detail.
Webinar: Being Committed – A Review of Transaction Control Statements 1/3
22 July 2020
PostgreSQL offers many advanced features that applications can use to store information reliably and efficiently for the longer term. One such feature is the ability to control transactions.
Webinar: Enhancing Postgres High Availability
15 July 2020
This webinar explained how Postgres High Availability isn’t just about putting together the right pieces, what components should be considered and much more.
Fireside Chat: BDR – Advanced Clustering & Scaling for PostgreSQL
8 July 2020
Simon Riggs & Tom Kincaid explained how BDR is disrupting the PostgreSQL industry with its advanced features & deployment options.
PostgreSQL Partitioning Roadmap
1 July 2020
In this webinar, Simon Riggs (CEO, 2ndQuadrant) gave a detailed breakdown of PostgreSQL partitioning and looked at it’s past and future development.
Fantastic Data Types and Where to Use Them
24 June 2020
This webinar discussed all the different levels of use cases where Fantastic Data Types such as ENUM, ARRAY, and JSON (and more) provide natural and explicit solutions.
Understanding the PostgreSQL table page layout
17 June 2020
This webinar explored the workings of TOAST mechanism, along with PostgreSQL’s ability to cope with large multi-GB sized tables and understand table page layout better.
PostgreSQL continuous backup and PITR with Barman
10 June 2020
This webinar gave an overview of Disaster Recovery of PostgreSQL databases with Barman, covering its major features and showing a live demo.
PostgreSQL deployments & TPAexec
3 June 2020
This webinar talked about PostgreSQL with Trusted Postgres Architecture(TPA) and discussed how TPAexec is designed to make life simpler in terms of PostgreSQL cluster deployments.
Cloud Native BDR and PostgreSQL
27 May 2020
This webinar explored how Cloud-Native BDR & PostgreSQL products developed by 2ndQuadrant work & how they can be integrated into your Kubernetes workloads.
Tuple Freezing & Transaction Wraparound Through Pictures
20 May 2020
Get an overview of the Postgres MVCC architectures, & the meaning & dangers associated with Transaction wraparound & the role Tuple Freezing plays in avoiding outage events.
Collations: Introduction, Features, Problems
13 May 2020
How modern collations affect the management of databases, especially upgrades, role of Unicode, relevant development projects for future PostgreSQL versions and much more.
MVCC and Vacuum Basics in PostgreSQL
6 May 2020
This webinar discussed MVCC and Vacuum Basics in PostgreSQL, & talked about the pros and cons of MVCC, usage of “VACUUM”, and why VACUUM and FREEZE are very common words in the PostgreSQL community.
KNN Indexing in PostgreSQL
29 April 2020
This webinar explored the K nearest neighbor (KNN) in PostgreSQL, which is a proximity algorithm to find data in order of distance. Join this webinar to learn more about KNN Indexing in PostgreSQL.
Date/Timestamp types in PostgreSQL
22 April 2020
This webinar talked about the powerful, native support for handling Date/Timestamp data types, in addition to the various data types you can use in both structured & unstructured formats.
Creating Graph Databases in PostgreSQL
15 April 2020
PostgreSQL is a hyper-converged DBMS, offering functionalities that otherwise require a specialized database technology. In this webinar, Simon Riggs demonstrated how PostgreSQL can be used as a Graph Database using native functions. This webinar was conducted by Simon Riggs, CEO at 2ndQuadrant.
pg_catalog Unveiled! That part of PostgreSQL you are probably underusing
8 April 2020
This webinar explored how to exploit pg_catalog, how to send the information to other monitoring tools, and how the tables in pg_catalog are fundamentally interconnected. This webinar was conducted by Boriss Mejias, PostgreSQL Consultant at 2ndQuadrant.
Identity Columns and Generated Columns in PostgreSQL
2 April 2020
This webinar covered Identity Columns and Generated Columns in PostgreSQL, with a focus on real-world use cases and examples. Different types of column methods were explored, & how they can be part of your business logic. This webinar was conducted by Peter Eisentraut, CTO at 2ndQuadrant.
The State of Full Text Search in PostgreSQL 12
12 March 2020
This webinar gave an overview about the Full Text Search feature in PostgreSQL. It included a short intro about the concepts involved, followed by a discussion of functions, operators, indexes, and collation support in Postgres in relevance to searching for text. This webinar was conducted by Jimmy Angelakos, Senior PostgreSQL Architect at 2ndQuadrant.
All you need to know about CREATE STATISTICS
26 February 2020
This webinar gave 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. This webinar was conducted by Tomas Vondra, Database Engineer at 2ndQuadrant.
Application Schema Migration
5 February 2020
This webinar covered the issues with Database schemas in production databases, aiming at a technical audience of both application architects & devops/SREs/DBAs. It also covered options you have for updating those schemas as your application evolves, & the various difficulties faced.
BDR – Latest Features & Updates
15 January 2020
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?
11 December 2019
This webinar discussed Disaster Recovery options in Postgres and how PITR can help in certain scenarios. This webinar was conducted by Martín Marqués, Head of Support Operations at 2ndQuadrant.
Using SSL with PostgreSQL and pgbouncer
13 November 2019
This webinar covered 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, and Delegation of authentication to pgbouncer using a map. This webinar was conducted by Andrew Dunstan, PostgreSQL Architect at 2ndQuadrant.
PostgreSQL Partitioning with Simon Riggs
23 October 2019
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
25 September 2019
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
28 August 2019
This webinar gave an overview of Window Functions in PostgreSQL and illustrate each specific feature with detailed examples. Topics covered were: Intro to Window Functions in PostgreSQL, How to use Window Functions for business intelligence, GROUPS mode & exclusions & Illustration of Window Functions specific features.
Postgres Vacuuming Through Pictures
24 July 2019
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
26 June 2019
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.
Security and Compliance with PostgreSQL
24 April 2019
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.
Achieving High Availability with PostgreSQL
26 February 2019
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.
Banking on PostgreSQL – Financial Application Considerations
29 January 2019
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.
BDR and pglogical Update
8 January 2019
This webinar covered: Latest on pglogical and BDR, Overview of existing features, Updates on new features and Roadmap. The webinar was conducted by Simon Riggs – CEO 2ndQuadrant.
Introduction to OmniDB
28 November 2018
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 by Rafael Castro & William Ivanski – Principal Consultants at 2ndQuadrant.
PostgreSQL is NOT your Traditional SQL database
30 October 2018
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 by Gülçin Yıldırım Jelínek .
New features in PostgreSQL 11
2 October 2018
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.
Database Security in PostgreSQL
12 September 2018
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.
Ansible & PostgreSQL
10 July 2018
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.
Introduction to BDR
16 May 2018
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
4 April 2018
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 at 2ndQuadrant.
Data Integration with PostgreSQL
13 February 2018
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
12 December 2017
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.