by Shivam Dhapatkar | Oct 9, 2023 | Monitoring, Percona Software, PostgreSQL
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....
by Ibrar Ahmed | Apr 5, 2019 | Insight for Developers, PostgreSQL
PostgreSQL is a powerful open source relational database management system. It extends the SQL language with additional features. A DBMS is not only defined by its performance and out of the box features, but also its ability to support bespoke/additional...
by Jobin Augustine | Oct 5, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
In this current series of blog posts, we have been discussing various relevant aspects when building an enterprise-grade PostgreSQL setup, such as security, back up strategy, high availability, and different methods to scale PostgreSQL. In this blog post, we’ll...
