Hello, On a test postgresql server I have set work_mem to 200MB, and I have stop/start postgressql. I have also enable the "log_temp_files = 0"
After restarting my server and executing some sql statements I see in the postgres log: LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp6655.10", size 122869324 So in what case temporary file of size less then work_mem are created on disk ? Yves D'Astous
