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; | ||
| + | </ | ||