Dinesh Kumar: ALTER FUNCTION SET work_mem: Fixing PostgreSQL Disk Spills Without a Global Change

T2Covered by 1 source · first reported by Planet PostgreSQL at 29 Sept, 00:00 UTC

Use PostgreSQL ALTER FUNCTION SET work_mem to stop one function's sorts spilling to disk without a global change. A production fix: 150 GB a day to 0.

cloud

Sources

• T2Dinesh Kumar: ALTER FUNCTION SET work_mem: Fixing PostgreSQL Disk Spills Without a Global ChangePlanet PostgreSQL29 Sept, 00:00