Bringing together some of the world's top PostgreSQL experts.
Postgres is a great database engine but what are the best ways to load data into it? In order to explore Bulk Data Loading in PostgreSQL in detail, 2ndQuadrant arranged a live webinar, “Best Practices for Bulk Data Loading in PostgreSQL", which explored the answers to some of the most common questions related to bulk data loading: […]
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 […]
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, […]
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 […]
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 […]
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 […]
BDR from 2ndQuadrant presents true high availability for mission critical databases running on PostgreSQL across various industry verticals such as financial services, telecommunications, and more. In order to explore BDR and its features in detail, 2ndQuadrant arranged a live Fireside Chat session on “BDR – Advanced Clustering & Scaling for PostgreSQL”. Guest: Simon Riggs, CEO […]
Partitioning is an integral data management strategy for high-performance and high-volume database applications. PostgreSQL provides excellent partitioning support that is constantly evolving. In order to explore this topic in detail, 2ndQuadrant arranged a live webinar, “PostgreSQL Partitioning Roadmap”. The session was hosted by Simon Riggs, Founder, and CEO at 2ndQuadrant. The webinar looked at the […]
PostgreSQL has fantastic data types such as ENUM, ARRAY, and JSON, to name a few. These data types were added to cover use cases that were not easily solved with the existing types. Due to their post-relational nature, they remain unusual and even strange to some developers, but once you learn them, you can create […]
Ever wondered how PostgreSQL actually stores your data in tables? What about the indexes? Where and how are they stored? The PostgreSQL database does a splendid job of managing your persistent data by using files on your regular file systems. In order to explore this topic in detail, 2ndQuadrant arranged a live webinar “Understanding the […]
