Skip to content

Root Fan

Linux & Oracle DBA Blog

  • Home
  • Contact
  • About
  • Index

Tag: optimization

Posted on September 30, 2025September 30, 2025

PostgreSQL Performance Tuning: How to Optimize Your Database Server

green hill near body of water

Tuning SQL queries is only part of the performance story.

To get the best out of PostgreSQL, you also need to tune the database server and operating system.

In this article, we’ll explore the key aspects of performance tuning, from hardware considerations to PostgreSQL configuration parameters.

Continue reading “PostgreSQL Performance Tuning: How to Optimize Your Database Server”

Unmissable Posts

  • Copy Password File From Primary ASM to Standby ASM on Oracle 19c
  • Oracle Exadata vs ExaCC vs ExaCS
  • Oracle 19c Data Guard Configuration Step by Step
  • How to Read an AWR Report in Oracle
  • 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 Exadata vs ExaCC vs ExaCS
  • RMAN Script to Take Full Database Backup Plus Archivelog
  • How to Check Oracle Database Character Set
  • A Comprehensive Guide to Using Huge Pages in Oracle Databases
  • How to Run an Oracle SQL Script Using nohup on Linux
  • 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