Temp getting written to disk despite being smaller than temp_buffers?

Поиск

Список

Период

Сортировка

От	Wells Oliver
Тема	Temp getting written to disk despite being smaller than temp_buffers?
Дата	23 июня 2023 г. 21:20:02
Msg-id	CAOC+FBU+0O9cNT2294rXCH+pT2KpSDQ1YsbP1ZE_2VXUxb5yYA@mail.gmail.com обсуждение исходный текст
Ответы	Re: Temp getting written to disk despite being smaller than temp_buffers? (Julien Rouhaud <rjuju123@gmail.com>)
Список	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@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 по дате отправления:

От: jacob ndinkwa
Дата: 23 июня 2023 г., 20:03:47
Сообщение: Re: Why log_statement may not work for a particular database?

От: Julien Rouhaud
Дата: 24 июня 2023 г., 02:36:26
Сообщение: Re: Temp getting written to disk despite being smaller than temp_buffers?