Re: temporary data after diskspace error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Willy-Bas Loos <willybas(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: temporary data after diskspace error
Date: 2020-01-27 21:15:03
Message-ID: 20278.1580159703@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Willy-Bas Loos <willybas(at)gmail(dot)com> writes:
> Will there be a lot of downtime to delete those 90GB of temp files?
> Will postgres just delete those files without processing them or should I
> brace for some downtime?

It's just a directory scan and an unlink() for each file that has
the right filename pattern to be a temp file. If you've got a
reasonable filesystem I wouldn't expect it to take long.
Maybe a minute? (but don't quote me on that)

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message basti 2020-01-27 21:27:34 Re: How to transfer databases form one server to other
Previous Message Adrian Klaver 2020-01-27 20:47:52 Re: How to transfer databases form one server to other