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@sss.pgh.pa.us> wrote:
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)