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(at)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?
--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>