Postgres Pro
Downloads
Home   >   mailing lists

Temp getting written to disk despite being smaller than temp_buffers? - Mailing list pgsql-admin

From Wells Oliver
Subject Temp getting written to disk despite being smaller than temp_buffers?
Date
Msg-id CAOC+FBU+0O9cNT2294rXCH+pT2KpSDQ1YsbP1ZE_2VXUxb5yYA@mail.gmail.com
Whole thread Raw
Responses Re: Temp getting written to disk despite being smaller than temp_buffers?
List pgsql-admin
Tree view
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?

--

pgsql-admin by date:

Previous
From: jacob ndinkwa
Date:
Subject: Re: Why log_statement may not work for a particular database?
Next
From: Julien Rouhaud
Date:
Subject: Re: Temp getting written to disk despite being smaller than temp_buffers?