Skip to content

script written in Perl that will assist you with your postgres configuration

License

Notifications You must be signed in to change notification settings

FastVPSEestiOu/pgsqltuner-perl

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 
 
 

Repository files navigation

pgsqltuner-perl

GPL Licence

pgsqltuner - script written in Perl that will assist you with your postgres configuration

Usage

./pgsqltuner.pl -m memory_in_Gb -p postgres_version
# Or with autodetect
./pgsqltuner.pl

Example

wget --no-check-certificate -q https://raw.githubusercontent.com/FastVPSEestiOu/pgsqltuner-perl/master/pgsqltuner.pl -O - | perl
We have 6.0 Gb total memory
We have postgres 9.5
We have kernel.shmmax 32.0MB


#### Recommendations ####
checkpoint_completion_target = 0.9
effective_cache_size = 3GB
fsync = off
maintenance_work_mem = 192MB
max_wal_size = 1536MB
shared_buffers = 768MB
synchronous_commit = off
wal_buffers = 2MB
work_mem = 6MB

wget https://raw.githubusercontent.com/FastVPSEestiOu/pgsqltuner-perl/master/pgsqltuner.pl -O pgsqltuner.pl --no-check-certificate -q
chmod +x pgsqltuner.pl
./pgsqltuner.pl -m 4 -p 8.4
We have 4 Gb total memory
We have postgres 8.4
We have kernel.shmmax 32.0MB


#### Recommendations ####
checkpoint_completion_target = 0.9
checkpoint_segments = 32
effective_cache_size = 2GB
fsync = off
maintenance_work_mem = 128MB
shared_buffers = 20MB
synchronous_commit = off
wal_buffers = 1MB
work_mem = 4MB

Contribute

pgsqltuner young and need YOU!

About

script written in Perl that will assist you with your postgres configuration

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages