-
PostgreSQL Deep Dive: Temporary Files and log_temp_files — When Your Queries Secretly Write Gigabytes to Disk
PostgreSQL Deep DivePostgreSQLPerformanceTemporary Fileswork_memDiskIO -
PostgreSQL Deep dive: Work_mem — what it actually controls (and why your sorts keep spilling to disk)
PostgreSQL Deep DivePostgreSQLwork_memmemoryperformancetuningquery-planning