Buy Percona ServicesBuy Now!

Fixing Common PostgreSQL Performance Bottlenecks

 | December 4, 2020 |  Posted In: PostgreSQL

Overview In this article, I look at how poorly designed sharding systems and replication systems in PostgreSQL affect query performance in high volume situations, and how to ensure data consistency across many servers.  I also discuss how excessive vacuuming generates I/O traffic, and how connection pooling is used to improve transaction throughput by caching connections […]

Read More

What If We Could Use Machine Learning Models as Tables – Percona Live ONLINE Talk Preview

 | October 12, 2020 |  Posted In: MariaDB, PLO-2020-10, PostgreSQL

Percona Live Online Agenda Slot: Tue 20 Oct • New York 1:30 p.m. • London 6:30 p.m. • New Delhi 11:00 p.m. • Singapore 1:30 a.m. (next day) Abstract In most machine learning tasks, one has to first organize data in some form and then turn it into information about the problem that needs to […]

Read More

Analytical Queries in MySQL – Percona Live ONLINE Talk Preview

 | October 9, 2020 |  Posted In: Events, MariaDB, MySQL, PLO-2020-10, PostgreSQL

Percona Live Online Agenda Slot: Tue 20 Oct • New York 6:00 p.m. • London 11:00 p.m. • New Delhi 3:30 a.m. • Singapore 6:00 a.m. Abstract MySQL’s sweet spot is known to be online transaction processing (OLTP), and it can support a very high load of short transactions. Many users will also want to […]

Read More

Kunlun Distributed DB Cluster Intro – Percona Live ONLINE Talk Preview

 | October 2, 2020 |  Posted In: Events, MySQL, Open Source Databases, PLO-2020-10, PostgreSQL

Percona Live Online Agenda Slot: Tue 20 Oct • New York 9:30 p.m. • London 02:30 a.m. (next day) • New Delhi 7:00 a.m. • Singapore 09:30 a.m. Abstract Kunlun Distributed Database Cluster is a distributed DBMS that aims to combine the best of both MySQL and PostgreSQL for a highly performant, highly available, highly […]

Read More

Database Schema Management Via Liquibase

 | October 1, 2020 |  Posted In: MySQL, PostgreSQL, Tools

Database Schema Management Via Liquibase

Creating the database for an application is simple and easy. However, database script management gets complicated in a hurry when you need to support multiple versions, work with multiple teams, and apply the same changes to multiple types of databases.  One open-source tool that helps teams track, version, and deploy database schema changes is Liquibase. […]

Read More

Percona Live ONLINE Opening Keynote: State of Open Source Databases by Peter Zaitsev

 | June 15, 2020 |  Posted In: AWS, Kubernetes, MariaDB, MongoDB, MySQL, Open Source Databases, PostgreSQL, Tools

Peter Zaitsev

Peter Zaitsev is CEO and co-founder of Percona. He opened Percona Live ONLINE with a keynote which took a look at the historical foundations of open source software and how they have shaped the field today. The history of open source software In the early days of computing, software and hardware were bundled together. While […]

Read More