by Ibrar Ahmed | Apr 1, 2025 | Insight for DBAs, Open Source, PostgreSQL
This blog was first authored by Ibrar Ahmed in 2018. We’ve updated it in 2025 for clarity and relevance, reflecting current practices while honoring their original perspective. If your PostgreSQL performance seems to be lagging, you’re not imagining things. It...
by Nickolay Ihalainen | Feb 21, 2019 | Insight for DBAs, PostgreSQL
Modern CPU models have a huge number of cores. For many years, applications have been sending queries in parallel to databases. Where there are reporting queries that deal with many table rows, the ability for a query to use multiple CPUs helps us with a faster...
by Jobin Augustine | Feb 13, 2019 | Insight for DBAs, PostgreSQL
PostgreSQL is emerging as the standard destination for database migrations from proprietary databases. As a consequence, there is an increase in demand for database side code migration and associated performance troubleshooting. One might be able to trace the latency...
by Ibrar Ahmed | Aug 29, 2018 | Insight for DBAs, PostgreSQL
For optimum performance, a PostgreSQL database depends on the operating system parameters being defined correctly. Poorly configured OS kernel parameters can cause degradation in database server performance. Therefore, it is imperative that these parameters are...
by Avinash Vallarapu | Aug 10, 2018 | Insight for DBAs, PostgreSQL
The performance of a PostgreSQL database can be compromised by dead tuples since they continue to occupy space and can lead to bloat. We provided an introduction to VACUUM and bloat in an earlier blog post. Now, though, it’s time to look at autovacuum for...
