webinars Archives - 2ndQuadrant

Posts

Migration to PostgreSQL [Webinar]

July 8, 2020/0 Comments/in Liaqat's PlanetPostgreSQL, Webinars /by Liaqat Andrabi

Among the many reasons to Migrate to PostgreSQL, dedicated support and seamless transition are key drivers for a business considering migration. Being open-source software, PostgreSQL provides a highly reliable, stable, scalable, and secure database migration, keeping in mind the unique needs of every business. Migration to PostgreSQL, however, can still be an extensive process as […]

Webinar: PostgreSQL Partitioning Roadmap [Follow Up]

July 3, 2020/0 Comments/in Webinars /by Bilal Ibrar

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 […]

Webinar: Fantastic Data Types and Where to Use Them [Follow Up]

June 26, 2020/0 Comments/in Webinars /by Bilal Ibrar

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 […]

Webinar: Understanding the PostgreSQL table page layout [Follow Up]

June 19, 2020/0 Comments/in Webinars /by Bilal Ibrar

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 […]

Webinar: PostgreSQL continuous backup and PITR with Barman [Follow Up]

June 15, 2020/0 Comments/in Webinars /by Bilal Ibrar

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. […]

Webinar: PostgreSQL deployments & TPAexec [Follow Up]

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

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 […]

Webinar: Cloud Native BDR and PostgreSQL [Follow Up]

June 2, 2020/0 Comments/in Webinars /by Bilal Ibrar

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 […]

Webinar: Tuple Freezing & Transaction Wrap around Through Pictures [Follow Up]

May 27, 2020/0 Comments/in Webinars /by Bilal Ibrar

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 […]

Webinar: Collations: Introduction, Features, Problems [Follow Up]

May 19, 2020/0 Comments/in Webinars /by Bilal Ibrar

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 […]

Webinar: MVCC and Vacuum Basics in PostgreSQL [Follow Up]

May 8, 2020/0 Comments/in Webinars /by Bilal Ibrar

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 […]