Skip to content

Root Fan

Linux & Oracle DBA Blog

  • Home
  • Contact
  • About
  • Index

Tag: performance

Posted on September 26, 2025September 30, 2025

PostgreSQL SQL Tuning: How to Find and Fix Slow Queries

Colorful abstract pattern background

Even the best hardware can’t save you from poorly written SQL.

PostgreSQL provides powerful tools to analyze query execution and optimize performance.

In this article, we’ll explore the fundamentals of SQL tuning so you can identify bottlenecks and make your queries run faster.

Continue reading “PostgreSQL SQL Tuning: How to Find and Fix Slow Queries”

Posts pagination

Previous page Page 1 Page 2

Unmissable Posts

  • Copy Password File From Primary ASM to Standby ASM on Oracle 19c
  • Oracle Exadata vs ExaCC vs ExaCS
  • How to Read an AWR Report in Oracle
  • Oracle 19c Data Guard Configuration Step by Step
  • Top 7 Oracle Wait Events Explained

Recent Posts

  • 5 Oracle to PostgreSQL Migration Projects That Failed (And Why)
  • Oracle to PostgreSQL Migration Best Practices: A Checklist for DBAs and Architects
  • Oracle to PostgreSQL Migration Cost: A Realistic Breakdown
  • Why Companies Are Leaving Oracle for PostgreSQL (And How to Do It Safely)
  • 8 Architectural Differences Between Oracle and PostgreSQL That Impact Performance

Categories

  • Apache
  • Exadata
  • Firewall
  • Linux
  • Oracle
  • Postfix
  • PostgreSQL
  • Security
  • Ubuntu

Unmissable posts

  • Oracle to PostgreSQL Migration Best Practices: A Checklist for DBAs and Architects
  • Copy Password File From Primary ASM to Standby ASM on Oracle 19c
  • How to Read an AWR Report in Oracle
  • 5 Oracle to PostgreSQL Migration Projects That Failed (And Why)
  • Oracle to PostgreSQL Migration Cost: A Realistic Breakdown
  • 5 Oracle to PostgreSQL Migration Projects That Failed (And Why)
  • Oracle to PostgreSQL Migration Best Practices: A Checklist for DBAs and Architects
  • Oracle to PostgreSQL Migration Cost: A Realistic Breakdown
  • Why Companies Are Leaving Oracle for PostgreSQL (And How to Do It Safely)
  • 8 Architectural Differences Between Oracle and PostgreSQL That Impact Performance

Categories

  • Apache
  • Exadata
  • Firewall
  • Linux
  • Oracle
  • Postfix
  • PostgreSQL
  • Security
  • Ubuntu

EN
EN
ES FR

  • Facebook
  • Twitter
  • Email
Privacy Policy Proudly powered by WordPress