Skip to content
This repository has been archived by the owner on Apr 15, 2018. It is now read-only.
/ pgtune Public archive
forked from kofemann/pgtune

PostgreSQL configurator for OSM2Vectortiles or other DW workloads

Notifications You must be signed in to change notification settings

osm2vectortiles/pgtune

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

26 Commits
 
 
 
 
 
 

Repository files navigation

pgtune

A tool to optimize PostgreSQL for OSM2Vectortiles (DW) workloads.

Usage:

$ ./pgtune.py -c 20 ->> /var/lib/pgsql/9.x/data/postgresql.conf

Example output:

./pgtune.py -c 20 -S
#
# OSM2Vectortiles friendly configuration for PostgreSQL 9.5
#
# Config for 7GB memory and 20 connections
#
checkpoint_completion_target = 0.9
default_statistics_target = 1000
effective_cache_size = 5GB
maintenance_work_mem = 486MB
max_connections = 20
max_wal_size = 4GB
min_wal_size = 1GB
shared_buffers = 1GB
synchronous_commit = off
vacuum_cost_delay = 50
wal_buffers = 16MB
wal_compression = on
wal_writer_delay = 10s
work_mem = 97MB
#
# other goodies
#
log_line_prefix = '%m <%d %u %a %r> %%'
log_temp_files = 0
log_min_duration_statement = 20
log_checkpoints = on
log_lock_waits = on
listen_addresses = 'localhost'
shared_preload_libraries = 'pg_stat_statements'

LICENSE

This work is based on https://github.com/kofemann/pgtune and published under public domain license.

About

PostgreSQL configurator for OSM2Vectortiles or other DW workloads

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Python 100.0%