PostgreSQL
Performance Tuner

PGTuner

Optimize your PostgreSQL database performance with intelligent tuning recommendations and real-time monitoring

Automatically analyze your database configuration, identify bottlenecks, and get actionable insights to boost your PostgreSQL performance by up to 10x

Performance Analytics (coming soon)
Auto-Tuning
Query Optimization (coming soon)

Database Analysis

Deep dive into your PostgreSQL configuration and identify optimization opportunities with comprehensive analysis

Smart Tuning

AI-powered recommendations tailored to your specific workload patterns and database requirements

PostgreSQL Configuration Tuner

Provide your system specifications and workload details to get personalized PostgreSQL configuration recommendations

System, Workload and Optimization Mode

Tell us about your server hardware and operating system

1 Core128 Cores
2 GiB1024 GiB

Workload Configuration

Describe your database workload and usage patterns

Memory Configuration

Configure memory allocation and optimization settings

1 MiB8192 MiB
1 MiB4096 MiB

Usable RAM (MiB)

Usable memory after excluding system and monitoring overhead

MiB

Disk: Data and WAL Specifications

Warning:

If you are using RAID, please ensure below calculation are suitable for RAID0 where READ and WRITE can be scaled equally (not linearly) and all disks has same capacity. If you are wandering if these calculations are correct, benchmark your whole volume in throughput (MiB/s) and random IOPS (with 8KiB page size) and set the number of disks to be 1 to disable the RAID estimation.

Note:

that for a performant PostgreSQL server, you should host your database on at least 4 disks or 4 separate volumes: 1 for PostgreSQL binaries, configuration, and transaction management; 1 for WAL; 1 for data and index; and 1 for database logging. Also, if you use tablespace to separate random IOPS for data/index volume then it would be great. You then also need a remote storage to store the backup, WAL archive, and compressed database logs.

Data & Index Partition/Volume

Tell us about your server data and index partition

50 1400000
50 MB/s14000 MB/s
5 GiB65536 GiB

WAL Partition/Volume

Tell us about your server WAL partition

50 IOPS1400000 IOPS
50 MB/s14000 MB/s
5 GiB65536 GiB

Anti-wraparound Vacuum Tuning

These settings are used to estimate what is the optimized scenario to perform aggressive anti-wraparound vacuum.

0 GiB32768 GiB
1000 TR20000000 TR

Data Integrity, Transaction Efficiency, Crash Recovery, and Replication

0 Replicas32 Replicas
0 Replicas32 Replicas
100 ms10,000 ms
Offshore Replication (regional or international)

Set to True meant that you are planning to have a geo-replicated replicas in the offshore country or continent. This would increase the wal_sender_timeout to 2 minutes or more.

NoYes

Tuning Mode

Tuning Your Database

Database Tuning

Enable Database General Tuning
NoYes
Enable Database General Tuning
NoYes

Check List Options Tuning

Include Comment

Enable it to add the comment into the response.

NoYes
Alter Style

Enable it to switch the format into ALTER SYSTEM SET.

NoYes
Analyze Memory Usage when Full Connection

Enable it when you need the memory display when all connections are in maximum usage.

NoYes
Ignore Non-Performance Setting

Enable it when you need the memory display when all connections are in maximum usage.

NoYes
Backup Settings

Enable it to add the request's information.

NoYes

Advanced Tuning Parameters

    These advanced parameters allowed you to have more control over the PostgreSQL database settings, such as higher memory utilization per connection, connection scaling, future-proofing your server against multiple profiles, and more. Some benefits of these advanced settings are:
  • • Reduce fine-grained memory control (session-based memory tuning) by application.
  • • Higher WAL utilization for high-transactional databases.
  • • Furthermore

Memory Result

Response