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 at 2ndQuadrant...

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...

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 unexpected solutions to specific use cases. For instance, ENUM types are extremely...

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 PostgreSQL table page layout ”. The session was hosted by...

How can you achieve an RTO of 5 minutes for the backups of your PostgreSQL databases? And what about RPO=0 for zero data loss backups? To tackle such questions and more, 2ndQuadrant arranged a live webinar “ PostgreSQL continuous backup and PITR with Barman ”. The session was hosted by Gabriele Bartolini, Head of Support at 2ndQuadrant. This webinar gave an overview of Disaster Recovery of...

TPAexec is an orchestration tool that uses Ansible to build Postgres clusters that follow Trusted Postgres Architecture (TPA). TPA basically includes a set of recommendations from 2ndQuadrant about how to set up a Postgres cluster in various scenarios. These represent the best practices followed by 2ndQuadrant, and are as applicable to quick testbed setups as it is to production environments. This...

Cloud-Native BDR is a multi-master database system based on PostgreSQL and designed for Kubernetes 1.15+ that thanks to the WriteAnywhere architecture, allows your applications to reach up to 6-nines uptime availability in a year. To further explore this topic, 2ndQuadrant arranged a live webinar, “ Cloud Native BDR and PostgreSQL ”, hosted by Gabriele Bartolini. This webinar presented a perfect...

The Postgres Implementation of Multi-Version Concurrency Control has many technical advantages and strengths. However, if you are deploying a large database, with a heavy write update, insert and delete workload, the concepts around Transaction wrap around are very important to understand — so proper design, monitoring, and administration decisions can be made. To explore this topic further...

The collation feature allows specifying the sort order and character classification behavior of data per-column, or even per-operation. The sort order of text in an SQL database is influenced by these so-called collations. These usually work behind the scenes, but they offer a number of interesting customization possibilities, while also being a potential source of operational problems and user...

PostgreSQL uses MVCC to handle concurrent clients through snapshots instead of locks. This lets the server handle a larger transaction load and allows for a rich set of tools for developers to access data concurrently. In order to get a deeper understanding of MVCC and Vacuum basics in PostgreSQL, as well as the pros and cons that come from its usage , 2ndQuadrant hosted a live webinar, MVCC and...