meta data for this page
postgresql tuning
- If the database resides on a Btrfs file system, you should consider disabling Copy-on-Write for the directory before creating any database.
- If the database resides on a ZFS file system, you should consult ZFS hints for databases before creating any database.
Parallel queries
SHOW max_parallel_workers_per_gather; SHOW max_parallel_workers; SET max_parallel_workers_per_gather = 0; SET max_parallel_workers = 0;