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

  • How to Check PDB Status in Oracle
  • How to Change AWR Retention Period in Oracle Database
  • Implementing Transparent Data Encryption in Oracle 19c Step by Step
  • Copy Password File From Primary ASM to Standby ASM on Oracle 19c
  • How to Read an AWR Report in Oracle

Recent Posts

  • How to Read an AWR Report in Oracle
  • PostgreSQL Performance Tuning: How to Optimize Your Database Server
  • PostgreSQL SQL Tuning: How to Find and Fix Slow Queries
  • Oracle Exadata vs ExaCC vs ExaCS
  • Oracle Query to Check RMAN Backup Status

Categories

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

Unmissable posts

  • How to Change AWR Retention Period in Oracle Database
  • How to Find Alert Log File Location in Oracle
  • Oracle Query to Check RMAN Backup Status
  • How to Check Database Size in Oracle 19c
  • How to Run an Oracle SQL Script Using nohup on Linux
  • How to Read an AWR Report in Oracle
  • PostgreSQL Performance Tuning: How to Optimize Your Database Server
  • PostgreSQL SQL Tuning: How to Find and Fix Slow Queries
  • Oracle Exadata vs ExaCC vs ExaCS
  • Oracle Query to Check RMAN Backup Status

Categories

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

EN
EN
ES FR

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