May 26, 2020

Mostly mistaken and ignored parameters while optimizing a PostgreSQL database - Percona Live 2020

Avi Vallarapu talked about Optimizing a PostgreSQL database may be a challenge if some of the important parameters are ignored. And a bigger challenge may be the algorithm behind setting those parameters correctly. In my experience with PostgreSQL Consulting for more than a decade, I have seen a bigger list of parameters that are wrongly set or ignored. This talk details such a list of important PostgreSQL parameters considering the latest...

Percona Live SessionsPostgreSQLPerformance Optimization


May 26, 2020

Working With PostgreSQL As A JSON Document Store - Robert Bernier - Percona Live Online 2020

JSON, JavaScript Object Notation, is an open format and machine-readable standard facilitating data interchange between application and the persistent datastore on the modern webstack. This talk focusses on the ability of postgres to act as the authoritative datastore and when correctly designed and implemented can match any of the popular technologies in use today. In this tutorial, we will show you how to work with PostgreSQL JSON data...

Percona Live SessionsPostgreSQL


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.

PostgreSQLScalability


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

PostgreSQLOperations


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.

PostgreSQLMongoDBMySQL


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


Pages