max_connections = 9000                  # (change requires restart)
superuser_reserved_connections = 1      # (change requires restart)

shared_buffers = 8GB

work_mem = 2MB

maintenance_work_mem = 64MB             # min 1MB

dynamic_shared_memory_type = posix      # the default is the first option
                                        # supported by the operating system:
                                        #   posix
                                        #   sysv
                                        #   windows
                                        #   mmap
                                        # use none to disable dynamic shared memory
synchronous_commit = off

wal_buffers = 256MB

checkpoint_timeout = 10min              # range 30s-1d

max_wal_size = 4096MB

min_wal_size = 3072MB

checkpoint_completion_target = 1.0      # checkpoint target duration, 0.0 - 1.0

random_page_cost = 4.0                  # same scale as above

default_statistics_target = 500         # range 1-10000