User Tools

Site Tools


Differences

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

Link to this comparison view

tips [2019-06-21 14:14] (current)
Line 1: Line 1:
 +=====Tips=====
 +
 +===ZFS===
 +<​file>​
 +sysctl vfs.zfs.resilver_min_time_ms=5000
 +sysctl vfs.zfs.resilver_delay=0
 +sysctl vfs.zfs.scrub_delay=0
 +sysctl vfs.zfs.top_maxinflight=128
 +sysctl vfs.zfs.scan_idle=2
 +</​file>​
 +
 +===PG===
 +<​file>​
 +SELECT pg_terminate_backend(pg_stat_activity.pid)
 +  FROM pg_stat_activity
 +  WHERE pg_stat_activity.datname = '​_DBNAME_';​
 +</​file>​
 +
 +----
 +[<>]
 +