Re: temporary data after diskspace error - Mailing list pgsql-general

From Tom Lane
Subject Re: temporary data after diskspace error
Date
Msg-id 20278.1580159703@sss.pgh.pa.us
Whole thread Raw
In response to Re: temporary data after diskspace error  (Willy-Bas Loos <willybas@gmail.com>)
Responses Re: temporary data after diskspace error
List pgsql-general
Willy-Bas Loos <willybas@gmail.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



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to transfer databases form one server to other
Next
From: basti
Date:
Subject: Re: How to transfer databases form one server to other