May 26, 2020

Parallelism in PostgreSQL - Ibrar Ahmed - Percona Live Online 2020

PostgreSQL’s architecture is process-based instead of thread-based. PostgreSQL launches a process “postmaster” on startup and after that spans a new process whenever a new client connects to PostgreSQL. Before version 10 there was no parallelism in a single connection. It is true that multiple queries from a different client can have parallelism because of process architecture, but a single query runs serially and did not have parallelism...

Percona Live SessionsPostgreSQL

May 26, 2020

Declarative Caching with Postgres and Redis - Kyle Davis - Percona Live Online 2020

The concept of caching is not complicated: store the results of a query for a short period of time in a fast storage engine so you touch the slow and/or expensive database less. This simple concept often hides application-level complexity as not all queries should be cached. Deciding what to cache and what not to cache depends on many factors:
Will there be a performance benefit? Already short running queries may have negligible...

Percona Live SessionsPostgreSQLOperations

May 22, 2020

Will Postgres Live Forever? - Bruce Momjian - Percona Live Online 2020

This presentation explains how OpenSource software can live for a very long time, and covers the differences between proprietary and open source software life cycles. It also covers the increased adoption of open source, and many of the ways that Postgres is innovating to continue to be relevant.

Percona Live SessionsPostgreSQL

Apr 24, 2020

The Evolution of PostgreSQL Partitioning

PostgreSQL Partitioning has evolved in different versions of PostgreSQL and now has solid scalability features. PostgreSQL has three different kinds of partitioning: Range, List, and Hash Partitioning. This webinar will cover the basics of all kinds of Partitioning and all the improvements done in the PostgreSQL releases. We will also review examples of how partitioning works in real-life uses cases.


Apr 17, 2020

Why PostgreSQL is Becoming a Migration Target in Large Enterprises

The adoption and market share of PostgreSQL is growing at a rapid rate. And it's not just new installations or applications - there are huge levels of migrations happening from other database systems as well. We will discuss the reasons for selection and migration to PostgreSQL, why it's becoming a preferred open-source database and demonstrate simple migration using Oracle_FDW.

This talk covers:

• Major Trends...


Mar 12, 2020

17 Things Developers Need to Know about Databases

Most applications use databases, yet many fail to follow even the most basic best practices resulting in poor performance, downtime and security incidents.
In this presentation, we will look into the foundational best practices you as a Developer should know about databases, with particular focus on the most popular Open Source Databases - MySQL, PostgreSQL, and MongoDB.


Jun 19, 2019

A Deep Dive Into PostgreSQL Indexing

Please watch Percona’s Senior Software Engineer, Ibrar Ahmed as he presents his talk "A Deep Dive Into PostgreSQL Indexing".

Indexes are a basic feature of relational databases, and PostgreSQL offers a rich collection of options to developers and designers. To fully take advantage of these, users need to understand the basic concept of indexes, and to be able to compare the different index types and how they apply to different...

PostgreSQLCloudPercona MySQL Webinars

Jun 19, 2019

Fast, Reliable, Secure and Affordable: MongoDB on AWS EC2

Paul Marcelin delivers the talk, "Fast, Reliable, Secure and Affordable: MongoDB on AWS EC2", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

Self-managing MongoDB on AWS EC2 gives you the best of a leading open-source database and a leading cloud computing platform. I will explain the AWS concepts you need to know to set up and maintain a fast, reliable, secure and affordable MongoDB...

Percona Live SessionsPostgreSQLMongoDBCloud Solutions

Jun 17, 2019

MySQL Performance Optimization and Troubleshooting with Percona Monitoring and Management

Peter Zaitsev (Percona) delivers the talk, "MySQL Performance Optimization and Troubleshooting with Percona Monitoring and Management", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

Optimizing MySQL performance and troubleshooting MySQL problems are two of the most critical and challenging tasks for MySQL DBA's. The databases powering your applications need to be able to handle heavy...

Percona Live SessionsOpen Source DatabasePostgreSQLMariaDBMySQLPercona Monitoring and Management

Jun 17, 2019

Building PostgreSQL as an Enterprise Grade Setup Using Open Source Tools

Avinash Vallarapu (Percona) delivers the talk, "Building PostgreSQL as an Enterprise Grade Setup Using Open Source Tools", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

"I migrated from a proprietary database software to PostgreSQL. I am curious to know whether I can get the same features I used to have in the proprietary database software."

The market coined the term "enterprise...

Percona Live SessionsPostgreSQL