meta data for this page
  •  

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

linux:databases:psql:tuning [2021/03/25 15:00] – created niziaklinux: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;
 +</code>