logologo
PostgreSQL Configurator

Select your version of PostgreSQL:

GB of RAM in your server:

Number of CPUs (= cores):

Disk Type:

Number of disks:

How big is your database?

How would you describe your workload?

How many concurrent open connections do you expect?

How many replicas do you need?

Which backup method are you planning to use?

Do you want to activate wal recycling?

Can you lose single transactions in case of a crash?

Are you willing to try out experimental features for better performance?

# DISCLAIMER - Software and the resulting config files are provided AS IS - IN NO EVENT SHALL # BE THE CREATOR LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL # DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION. # Connectivity max_connections = 100 superuser_reserved_connections = 3 # Memory Settings shared_buffers = '16384 MB' work_mem = '64 MB' maintenance_work_mem = '620 MB' huge_pages = try # NB! requires also activation of huge pages via kernel params, see here for more: https://www.postgresql.org/docs/current/static/kernel-resources.html#LINUX-HUGE-PAGES effective_cache_size = '45 GB' effective_io_concurrency = 200 # concurrent IO only really activated if OS supports posix_fadvise function random_page_cost = 1.25 # speed of random disk access relative to sequential access (1.0) # Monitoring shared_preload_libraries = 'pg_stat_statements' # per statement resource usage stats track_io_timing=on # measure exact block IO times track_functions=pl # track execution times of pl-language procedures if any # Replication wal_level = replica # consider using at least 'replica' max_wal_senders = 0 synchronous_commit = on # Checkpointing: checkpoint_timeout = '15 min' checkpoint_completion_target = 0.9 max_wal_size = '10240 MB' min_wal_size = '5120 MB' # WAL writing wal_compression = on wal_buffers = -1 # auto-tuned by Postgres till maximum of segment size (16MB by default) wal_writer_delay = 200ms wal_writer_flush_after = 1MB # Background writer bgwriter_delay = 200ms bgwriter_lru_maxpages = 100 bgwriter_lru_multiplier = 2.0 bgwriter_flush_after = 0 # Parallel queries: max_worker_processes = 8 max_parallel_workers_per_gather = 4 max_parallel_maintenance_workers = 4 max_parallel_workers = 8 parallel_leader_participation = on # Advanced features enable_partitionwise_join = on enable_partitionwise_aggregate = on jit = on max_slot_wal_keep_size = '1000 MB' track_wal_io_timing = on maintenance_io_concurrency = 200 wal_recycle = on # General notes: # Note that not all settings are automatically tuned. # Consider contacting experts at # https://www.cybertec-postgresql.com # for more professional expertise.
© 2000–2024 CYBERTEC PostgreSQL International GmbH