...
Tamaño RAM | 4 GB | 8 GB | 16 GB | 32 GB | 64 GB | 128 GB |
|---|---|---|---|---|---|---|
| shared_buffers | 1GB | 2GB | 4GB | 8GB | 16GB | 32GB |
| effective_cache_size | 1536MB | 4GB | 8GB | 16GB | 32GB | 64GB |
| work_mem | 12MB | 12MB | 16MB | 20MB | 24MB | 28MB |
| maintenance_work_mem | 512MB | 1GB | 1GB | 1GB | 1GB | 1GB |
| max_connections | 63 | 103 | 153 | 203 | 253 | 303 |
dynamic_shared_memory_type | posix | posix | posix | posix | posix | posix |
effective_io_concurrency | 200 | |||||
max_worker_processes | 16 | |||||
max_parallel_workers_per_gather | 8 | |||||
max_parallel_workers | 16 | |||||
| fsync | off | off | off | off | off | off |
| enable_seqscan | off | off | off | off | off | off |
random_page_cost | 1.1 | 1.1 | ||||
Existen otras páginas relacionadas con la configuración de otros SGBD:
...