Skip to content

Root Fan

Oracle & Postgresql DBA Blog

  • Home
  • Contact
  • About
  • Index
  • Services

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
  • PostgreSQL High Availability with Patroni, etcd, HAProxy and keepalived
  • Oracle Exadata vs ExaCC vs ExaCS
  • How to Read an AWR Report in Oracle
  • Top 7 Oracle Wait Events Explained

Recent Posts

  • Oracle to PostgreSQL Migration Guide: OLTP and Data Warehouse Examples
  • Oracle to Postgres Migration: CO Schema Issues and Fixes
  • Oracle to Postgres Migration Step by Step: The SH Schema (Partitions, Materialized Views, Bitmap Indexes)
  • ora2pg Migration Example: Oracle HR Schema to PostgreSQL
  • The Complete Oracle-to-PostgreSQL Data Type Mapping Guide

Categories

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

Unmissable posts

  • Oracle to PostgreSQL Migration Guide: OLTP and Data Warehouse Examples
  • Copy Password File From Primary ASM to Standby ASM on Oracle 19c
  • Oracle 19c RMAN Duplicate Database From Backup
  • How to Change Processes Parameter in Oracle 19c RAC
  • Oracle Exadata vs ExaCC vs ExaCS
  • Oracle to PostgreSQL Migration Guide: OLTP and Data Warehouse Examples
  • Oracle to Postgres Migration: CO Schema Issues and Fixes
  • Oracle to Postgres Migration Step by Step: The SH Schema (Partitions, Materialized Views, Bitmap Indexes)
  • ora2pg Migration Example: Oracle HR Schema to PostgreSQL
  • The Complete Oracle-to-PostgreSQL Data Type Mapping Guide

Categories

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

EN
EN
ES FR

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