67 подписчиков

# OLAP workload preset for Postgres Pro 17

# System: 8 CPU, 8GB RAM, SSD, Linux

echo "# OLAP-specific configuration for Postgres Pro 17"

echo "shared_buffers = 2GB"

echo "effective_cache_size = 6GB"

echo "work_mem = 64MB"

echo "maintenance_work_mem = 2GB"

echo "max_parallel_workers_per_gather = 6"

echo "max_parallel_workers = 8"

echo "random_page_cost = 1.1"

echo "seq_page_cost = 1.0"

echo "checkpoint_timeout = 30min"

echo "max_wal_size = 4GB"

echo "min_wal_size = 2GB"

echo "log_min_duration_statement = 1000" # Логировать медленные запросы >1 сек

echo "log_statement = 'none'" # Отключить логирование всех запросов для производительности

Около минуты

29 марта