Percona Essentials

Percona
Platform

Percona Platform

A unified experience for developers and database administrators to monitor, manage, secure, and optimize database environments on any infrastructure.

Percona
Monitoring and
Management

Percona Monitoring and Management

Monitor the health of your database infrastructure, explore new patterns in behavior, and improve the performance of your databases no matter where they’re located.

Percona Resources

Software
Downloads

All of Percona’s open-source software products, in one place, to download as much or as little as you need.

Product
Documentation

A single source for documentation on all of Percona’s leading, open-source software.

Percona Blog

Percona Blog

Our popular knowledge center for all Percona products and all related topics.

Community

Percona Community Hub

A place to stay in touch with the open-source community

Events

Percona Events Hub

See all of Percona’s upcoming events and view materials like webinars and forums from past events

About

About Percona

Percona is an open source database software, support, and services company that helps make databases and applications run better.

Percona in the News

See Percona’s recent news coverage, press releases and industry recognition for our open source software and support.

Our Customers

Our Partners

Careers

Contact Us

Hypothetical Indexes in PostgreSQL

Hypothetical Indexes in PostgreSQL

At recent conferences, we have received a curious question from users who have used Oracle in the past and are now using PostgreSQL: “Do we have hypothetical indexes in PostgreSQL ?”. The answer to that question is EXPLAIN <QUERY>. However, if you...
Bloom Indexes in PostgreSQL

Bloom Indexes in PostgreSQL

There is a wide variety of indexes available in PostgreSQL. While most are common in almost all databases, there are some types of indexes that are more specific to PostgreSQL. For example, GIN indexes are helpful to speed up the search for element values within...
PostgreSQL Upgrade Using pg_dump/pg_restore

PostgreSQL Upgrade Using pg_dump/pg_restore

In this blog post, we will explore  pg_dump / pg_restore, one of the most commonly used options for performing a PostgreSQL upgrade. It is important to understand the scenarios under which pg_dump and pg_restore utilities will be helpful. This post is the second of...
PostgreSQL Upgrade Using pg_dumpall

PostgreSQL Upgrade Using pg_dumpall

There are several approaches to assess when you need to upgrade PostgreSQL. In this blog post, we look at the option for upgrading a postgres database using pg_dumpall. As this tool can also be used to back up PostgreSQL clusters, then it is a valid option for...