Re: temporary data after diskspace error

I did the restart and it took seconds.
This was on a SSD.
BTW on ubuntu and debian i never use pg_ctl directly, postgresql-common has
a very nice CLI for this.
For the restart i used: sudo pg_ctlcluster --force 9.4 main restart

Thanks for all the good advice!

On Mon, Jan 27, 2020 at 10:15 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> 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
>

--
Willy-Bas Loos