Skip to content

Root Fan

Oracle & Postgresql DBA Blog

  • Home
  • Contact
  • About
  • Index
  • Services

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
  • PostgreSQL High Availability with Patroni, etcd, HAProxy and keepalived
  • PostgreSQL Monitoring: How to Keep Your Database Healthy
  • How to Set Up Real-Time Oracle to PostgreSQL Replication Using Debezium

Recent Posts

  • PostgreSQL repmgr Setup Replication with Automatic Failover
  • PostgreSQL 18 Backup & Recovery Lab on Ubuntu 24.04 — pg_dump, pg_basebackup and pgBackRest
  • How to Set Up Real-Time Oracle to PostgreSQL Replication Using Debezium
  • How to Install ora2pg on Ubuntu and Run a Migration Assessment Report
  • Oracle to PostgreSQL Migration Guide: OLTP and Data Warehouse Examples

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