webinars Archives - 2ndQuadrant

Posts

PostgreSQL Partitioning by Simon Riggs [Full Webinar Video]

October 23, 2020/0 Comments/in Webinars /by Bilal Ibrar

This webinar on PostgreSQL Partitioning (originally conducted in 2019), is now available to watch on our YouTube channel. This webinar gave an overview of PostgreSQL partitioning and how it plays a key role in sensible management and improved performance with very large databases. Particular use cases were also highlighted, along with taking a look at […]

Webinar: Highway to Zero Downtime PostgreSQL Upgrades [Follow Up]

October 5, 2020/0 Comments/in Webinars /by Bilal Ibrar

In the past, major upgrades of terabyte size PostgreSQL databases required extended downtime or great amounts of work. With logical decoding, a whole new world of opportunities appeared for upgrades that require a very small amount of downtime. This webinar gave a comprehensive overview of how to perform a “near” zero downtime upgrade using pglogical, […]

New Features in PostgreSQL 13 [Full Webinar Video]

September 24, 2020/0 Comments/in Liaqat's PlanetPostgreSQL, Webinars /by Liaqat Andrabi

The PostgreSQL Global Development Group today announced the release of PostgreSQL 13. The new release boasts improvements in performance and security as well as notable features such as the SQL-standard WITH TIES clause to use with LIMIT, B-tree deduplication, improvements for large databases, and more. The many features and enhancements in PostgreSQL 13 help improve […]

Webinar: New Features in PostgreSQL 13 [Follow Up]

September 21, 2020/0 Comments/in Webinars /by Bilal Ibrar

There are numerous features and enhancements in PostgreSQL 13 that help improve the overall performance of PostgreSQL while making it considerably easier to develop and manage applications. The PostgreSQL community has been able to release a major revision every year, demonstrating their amazing vitality and creativity — and in order to take a deep dive […]

Webinar: JSON & ARRAY – Contemporary PostgreSQL Data Types [Follow Up]

September 4, 2020/0 Comments/in Webinars /by Bilal Ibrar

The Entity-Attribute-Value (EAV) data model is a design pattern to overcome the limitations of traditional relational databases. Its goal is to encode entities with a variable and a disparate number of attributes. It is efficient in terms of storage and it respects the rules of normalization. However, it doesn’t scale well, it degrades performance in […]

Business Intelligence with Window Functions in PostgreSQL [Webinar]

September 3, 2020/0 Comments/in Liaqat's PlanetPostgreSQL, Webinars /by Liaqat Andrabi

Window functions in PostgreSQL are a very useful tool; and since their introduction 10 years ago, they have been gradually adopted for various use cases where a simple aggregation is just not flexible enough — case in point, incremental totals and moving averages. The features introduced in PostgreSQL complete the implementation according to the SQL:2011 […]

Webinar: Similarity Queries in PostgreSQL [Follow Up]

August 20, 2020/0 Comments/in Webinars /by Bilal Ibrar

Similarity queries are a popular requirement in many applications that need data integration, record linkage, data cleaning, data de-duplication, and fuzzy matching. PostgreSQL provides many features that allow you to run similarity queries. In order to explore this topic in detail, 2ndQuadrant arranged a live webinar, “Similarity Queries in PostgreSQL”, to dive into this topic […]

Postgres Vacuuming Through Pictures [Webinar]

August 20, 2020/0 Comments/in Liaqat's PlanetPostgreSQL, Webinars /by Liaqat Andrabi

Vacuuming is a key feature of PostgreSQL databases to keep databases healthy and optimized. When enabled, autovacuum conserves space by removing obsolete disk usage and optimizes database performance by speeding up sequential scans, among many other benefits. As part of the ongoing PostgreSQL Webinar Series, 2ndQuadrant hosted a webinar on Postgres Vacuuming Through Pictures, which […]

Webinar: Being Committed – A Review of Transaction Control Statements 3/3 [Follow Up]

August 6, 2020/0 Comments/in Webinars /by Adnan Nazar

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. In the third and final session, Gianni Ciolli, Head of Professional Services at 2ndQuadrant covered: Transactions and Locking: improve transaction flow by reducing contention. The Blind Spot […]

Webinar: Being Committed – A Review of Transaction Control Statements 2/3 [Follow Up]

July 30, 2020/0 Comments/in Webinars /by Adnan Nazar

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. In the second session, Gianni Ciolli, Head of Professional Services at 2ndQuadrant covered: Replicated Transactions: replication can provide extra reliability, if properly used. Performance Expectations: will transactions […]

Read 2ndQuadrant’s response to the COVID – 19 emergency here