Sep 23, 2020

PostgreSQL High-Performance Tuning and Optimization

Please watch Percona’s Senior Software Engineer, Ibrar Ahmed as he presents the “PostgreSQL High-Performance Tuning and Optimization" webinar.

PostgreSQL is one of the leading open-source databases. Out of the box, the default PostgreSQL configuration is not tuned for any workload. Thus, any system with least resources can run it. PostgreSQL does not give optimum performance on high permanence machines because it is not using the...

PostgreSQLPerformance Optimization

Aug 26, 2020

Understanding and Optimizing commit sychronization for maximum performance

Jobin Augustine present "Understanding and Optimizing commit sychronization for maximum performance"

Durability by PostgreSQL is taken for granted. PostgreSQL allows it to be tweaked at different levels. A better understanding of the commit synchronization and how it interacts with standby databases can help to optimize the performance while achieving the desired durability.

-Interaction with OS
-Interaction with the...


Aug 26, 2020

Migrating from MSSQL to PostgreSQL

Robert Bernier present "Migrating from MSSQL to PostgreSQL"

This presentation details the real world migration of an aging MSSQL enterprise server to PostgreSQL. The migration resulted in a more agile and responsive infrastructure tailored to today's circumstances and scaling opportunities.

- About the challenge
- About the solution
- The technical details
- Executing the migration
- Post migration


Aug 19, 2020

An introduction to pgcrypto

Robert Bernier present "An introduction to pgcrypto"

This talk introduces you to one of the more important postgres security extensions "pg_crypto". We'll cover the more base functions, and how they can be used with some simple examples.

- General Hashing Functions
- Password Hashing Functions
- PGP Encryption Functions
- Raw Encryption Functions
- Random-Data Functions


Aug 19, 2020

Joining Heterogeneous Databases is a reality, not a Myth

Ibrar Ahmed present "Joining Heterogeneous Databases is a reality, not a Myth."

PostgreSQL provides a way to communicate with external data sources. This could be another PostgreSQL instance or any other database.
The other database might be a relational database such as Clickhouse, MySQL or Oracle; or any NoSQL database such as MongoDB or Hadoop. To achieve this, PostgreSQL implements ISO Standard call SQL-MED in the form of...


Aug 19, 2020

Elephant by the pool: PostgreSQL connection poolers overview

Sergey Kuzmichev and Jobin Augustine present "Elephant by the pool: PostgreSQL connection poolers overview."

"Everything comes at a cost, including opening and maintaining connections to the database. With PostgreSQL, this can be especially true. Using connection pooler is a known solution, but choosing one can be a daunting task. Especially, when a new one has just appeared to the party.

This talk covers:
* The general...


Aug 19, 2020

Building Enterprise Grade PostgreSQL using Percona distribution for PostgreSQL

Avi Vallarapu present "Building an Enterprise Grade PostgreSQL using open source solutions"

"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 grade" or "enterprise ready" to differentiate products and service offerings for licensed database software. For example: there...


Jul 27, 2020

Multi-Primary Replication Solutions for PostgreSQL

Join Ibrar Ahmed, Sr. Software Engineer, Percona, as he discusses the concept of multi-primary replication and elaborates on the well-known multi-master replication available.
Scalability can be achieved horizontally or vertically. Vertical scalability means adding more resources/hardware to existing nodes to enhance the capability of the database to store and process more data, for example, adding a new process, memory, or disk to an...

PostgreSQLHigh AvailabilityPerformance Optimization

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