Re: cleanup temporary files after crash - Mailing list pgsql-hackers

From Euler Taveira
Subject Re: cleanup temporary files after crash
Date
Msg-id a26a35c6-8816-4c2b-91b9-7a428e430a57@www.fastmail.com
Whole thread Raw
In response to Re: cleanup temporary files after crash  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Responses Re: cleanup temporary files after crash  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
List 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

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: psql tab completion for \h with IMPORT FOREIGN SCHEMA
Next
From: "kuroda.hayato@fujitsu.com"
Date:
Subject: RE: [PATCH] pgbench: improve \sleep meta command