Re: cleanup temporary files after crash

Поиск
Список
Период
Сортировка
От Euler Taveira
Тема Re: cleanup temporary files after crash
Дата
Msg-id a26a35c6-8816-4c2b-91b9-7a428e430a57@www.fastmail.com
обсуждение исходный текст
Ответ на Re: cleanup temporary files after crash  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Ответы Re: cleanup temporary files after crash  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Список pgsql-hackers
On Thu, Mar 18, 2021, at 8:34 PM, Tomas Vondra wrote:
Well, that's better, bit it still does not do the trick on the 32-bit
machine - in that case a 1000 rows with int4 still fit into work_mem, so
the temp file is not created. Per my experiments about 1040 rows are
needed - soooo close ;-) So let's make it 2000.
My 32-bit laptop needs some repairs so I blindly chose 1k rows.

We might as well check that the temp file actually exists, before
killing the backend. Just to be sure.
Do you mean with remove_temp_files_after_crash = on? New version attached.


--
Euler Taveira

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: psql tab completion for \h with IMPORT FOREIGN SCHEMA
Следующее
От: "kuroda.hayato@fujitsu.com"
Дата:
Сообщение: RE: [PATCH] pgbench: improve \sleep meta command