Hi, On Fri, Jun 23, 2023 at 11:20:02AM -0700, Wells Oliver wrote: > Probably reading my logs wrong or misunderstanding something basic but my > temp_buffers is 512MB and I see things in the log like: > > 2023-06-23 18:02:44 UTC:172.31.21.22(40866):woliver@db:[25473]:LOG: > temporary file: path "base/pgsql_tmp/pgsql_tmp25473.135", size 255107072 > > Wondering why 255mb is being written to disk rather than using RAM? temp_buffers is for temporary tables, while those temporary files are used for node operations that consume more than work_mem.
