Temp getting written to disk despite being smaller than temp_buffers?

From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Temp getting written to disk despite being smaller than temp_buffers?
Date: 2023-06-23 18:20:02
Message-ID: CAOC+FBU+0O9cNT2294rXCH+pT2KpSDQ1YsbP1ZE_2VXUxb5yYA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Julien Rouhaud 2023-06-23 23:36:26 Re: Temp getting written to disk despite being smaller than temp_buffers?
Previous Message jacob ndinkwa 2023-06-23 17:03:47 Re: Why log_statement may not work for a particular database?