stsdatamanagement

STS Data Management Modules, Utilities and Services

To create a database for testing use the following:

docker run --name postgres-5432 -e POSTGRES_PASSWORD=postgres -p 5432:5432 -d --restart unless-stopped postgres
-c max_connections=500
-c shared_buffers=2GB
-c effective_cache_size=6GB
-c maintenance_work_mem=512MB
-c checkpoint_completion_target=0.9
-c wal_buffers=16MB
-c default_statistics_target=100
-c random_page_cost=1.1
-c effective_io_concurrency=200
-c work_mem=1048kB
-c min_wal_size=2GB
-c max_wal_size=8GB
-c max_worker_processes=6
-c max_parallel_workers_per_gather=3
-c max_parallel_workers=6
-c max_parallel_maintenance_workers=3