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.

Valkey Contribution

Product Documentation

Why Percona for MongoDB?

Why Percona for PostgreSQL?

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

Shivam Dhapatkar

Public Schema Security Upgrade in PostgreSQL 15

This post was originally published in 2023 and was updated in 2025. Security is always a moving target, and PostgreSQL 15 makes important changes that close off a long-standing risk: default privileges on the public schema. For years, any new user could create objects in the public schema unless you explicitly revoked their rights. That […]

The Powerful Features Released in PostgreSQL 17 Beta 2

The PostgreSQL Global Development team released the second beta version of PostgreSQL 17 on June 27th, 2024, and it is now available for testing. In this beta version, we can explore the new features that will be released in the official final release of PostgreSQL 17. In this blog, we will discuss some of the […]

How Can I Take a Backup of Configuration Files in PostgreSQL?

PostgreSQL configuration file parameters are very important when managing a PostgreSQL database, and this blog post will discuss the importance of backing those files up. The following are the primary configuration files of the PostgreSQL database: postgresql.conf: One of the most important configuration files for the PostgreSQL database is postgresql.conf file. This file contains a […]

PostgreSQL Tuple-Level Statistics With pgstattuple

Since Postgres table bloat degrades database performance, we can improve its performance by removing the table bloat. We can use the pgstattuple extension to identify the bloated tables. This extension provides several functions for obtaining tuple-level statistics. Because the pgstattuple functions produce extensive page-level information, access to them is, by default, limited. Only the pg_stat_scan_tables […]

What if the Backup Server Is Down and a Backup Is Needed? (Multi-repo Functionality of PgBackRest)

Our previous blogs discussed configuring and setting up backups using the pgBackRest solution. To briefly explain pgBackRest, it is an open source backup tool that takes FULL Backup, Incremental Backup, and Differential Backup for PostgreSQL databases. Repository means the location/path on the server or the cloud where the actual copy of the backup will reside. […]