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 <t...@sss.pgh.pa.us> wrote: > Willy-Bas Loos <willy...@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 > -- Willy-Bas Loos
