meta data for this page
Differences
This shows you the differences between two versions of the page.
linux:databases:psql:tuning [2021/03/25 15:00] – created niziak | linux:databases:psql:tuning [2021/10/11 10:54] (current) – niziak | ||
---|---|---|---|
Line 3: | Line 3: | ||
* 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 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. | * If the database resides on a ZFS file system, you should consult ZFS hints for databases before creating any database. | ||
+ | |||
+ | |||
+ | ====== Parallel queries ====== | ||
+ | |||
+ | <code sql> | ||
+ | SHOW max_parallel_workers_per_gather; | ||
+ | SHOW max_parallel_workers; | ||
+ | SET max_parallel_workers_per_gather = 0; | ||
+ | SET max_parallel_workers = 0; | ||
+ | </ | ||