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;