Aug 23, 2018

TimescaleDB: Re-Engineering PostgreSQL as a Time-Series Database Unlisted

Mike Freedman (Timescale) delivers the talk, "TimescaleDB: Re-Engineering PostgreSQL as a Time-Series Database", on DAY 2 of the Percona Live Open Source Database Conference 2018, 4/25, at Santa Clara, CA.

Time-series data is now everywhere and increasingly used to power core applications. It also creates a number of technical challenges: to ingest high volumes of data; to ask complex, queries for recent and historical time...

Percona Live SessionsOpen Source DatabasePostgreSQL


Aug 23, 2018

Distributed PostgreSQL

Simon Riggs (2ndQuadrant) delivers the talk, "Distributed PostgreSQL", on DAY 2 of the Percona Live Open Source Database Conference 2018, 4/25, at Santa Clara, CA.

This session is a review of the various ways in which PostgreSQL allows you to distribute your data across multiple nodes: remote data access, replication, sharding, distributed query and multi-master.

Percona Live SessionsPostgreSQLReplication


Aug 23, 2018

Aurora PostgreSQL Deep Dive

Grant McAlister (Amazon Web Services) delivers the talk, "Aurora PostgreSQL Deep Dive", on DAY 2 of the Percona Live Open Source Database Conference 2018, 4/25, at Santa Clara, CA.

In this session, we will dive deep into the unique features and changes that make up Aurora PostgreSQL - including understanding the architectural differences that contribute to improved scalability, availability, and durability. Some of the items that...

Percona Live SessionsPostgreSQLCloudScalabilityCloud Solutions


Aug 20, 2018

Your Herd of Elephants: PostgreSQL Replication

Christophe Pettus (PostgreSQL Experts Inc.) delivers the talk, "Your Herd of Elephants: PostgreSQL Replication", on DAY 2 of the Percona Live Open Source Database Conference 2018, 4/25, at Santa Clara, CA.

PostgreSQL version 10 has added logical replication, and now the field of replication options in PostgreSQL has gotten wide: Streaming replication, warm standby, logical replication?

We'll discuss what the options are,...

Percona Live SessionsPostgreSQLReplication


Aug 20, 2018

Automated DBA

Nikolay Samokhvalov (Nombox) delivers the talk, "Automated DBA", on DAY 2 of the Percona Live Open Source Database Conference 2018, 4/25, at Santa Clara, CA.

postgres_dba (https://github.com/NikolayS/postgres_dba) - is a brand new open source DBA tool set, which can be used by any application developer to find database issues possible solutions much faster.

In this...

Percona Live SessionsPostgreSQLSecurityPerformance Optimization


Aug 20, 2018

What's New in PostgreSQL?

Simon Riggs (2ndQuadrant) delivers the talk, "What's New in PostgreSQL?", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

A look at the latest production release PG10 and the latest features in the forthcoming PG11.

Percona Live SessionsPostgreSQL


Aug 13, 2018

Monitoring PostgreSQL with PMM (Percona Monitoring and Management)

Michael Coburn (Percona) delivers the talk, "Monitoring PostgreSQL with PMM (Percona Monitoring and Management)", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

Learn how to monitor PostgreSQL using PMM (Percona Monitoring and Management) so that you can:
* Gain greater visibility of performance and bottlenecks PostgreSQL
* Consolidate your PostgreSQL servers into the same...

Percona Live SessionsPostgreSQLPerformanceMonitoring and OperationsPercona Open Source Software


Aug 13, 2018

Securing Your Data on PostgreSQL

Payal Singh (OmniTI Computer Consulting Inc.) delivers the talk, "Securing Your Data on PostgreSQL", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

While most applications are aware of the minimum basic security features, there is often a lack of understanding about how best to manage them, especially with major security features being released with every major version of Postgres. As...

Percona Live SessionsPostgreSQLSecurity


Aug 13, 2018

How Microsoft Built MySQL, PostgreSQL and MariaDB for the Cloud

Jun Su (Microsoft) delivers the talk, "How Microsoft Built MySQL, PostgreSQL and MariaDB for the Cloud", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

Offering MySQL, PostgreSQL and MariaDB database services in the cloud is different than doing so on-premise. Latency, connection redirection, optimal performance configuration are just a few challenges. In this session, Jun Su will...

Percona Live SessionsPostgreSQLCloudMariaDBMySQLPerformance OptimizationScalabilityCloud Solutions


Aug 10, 2018

Tuning PostgreSQL for High-Write Workloads

Grant McAlister (Amazon Web Services) delivers the talk, "Tuning PostgreSQL for High-Write Workloads", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

In this session, we will cover a number of the way that you can tune PostgreSQL to better handle high write workloads. We will cover both application and database tuning methods as each type can have substantial benefits but can also...

Percona Live SessionsPostgreSQLQuery Tuning and Optimization


Pages