https://www.safaribooksonline.com/blog/2015/05/05/exploring-postgresql-temporary-table-with-docker/ 1- Temp file sismesini onlemek icin query basina ayrilan mem_work artirmak gerek. work_mem = 4MB # min 64kB 2- Sonra temp file yerini degistirmek icin farkli fiziksel disk uzerinde tablespace olusturmamiz lazim. CREATE TABLESPACE tmpSpace LOCATION '/storage/tmpTablespace' 3- Sonra actigimiz bu tablespace postgresql.conf icinde map edecegiz. temp_tablespaces = 'tmpSpace' 4- Controls logging of temporary file names and sizes. Temporary files can be created for sorts, hashes, and temporary query results. A log entry is made for each temporary file when it is deleted. A value of zero logs all temporary file information. log_temp_files = -1 # log temporary files equal or larger if log_temp_files sets to 0. This handy configuration value will tell Postgres to log each time it writes to the temporary table space on disk.Not in memory. This increases the size of temp. log_temp_files = 0 # log temporary files equal or larger
