Temp getting written to disk despite being smaller than temp_buffers?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 

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?

--
[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux