Re: Remove sort files

Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> One reasonable idea is
> cd pg_sorttemp ; rm -f *
>>
> OK, here is the new 'find' line:
>>
>> No, the point is not to use find at all.

> Actually, I can do:

>     rm -f */pg_sorttemp/*

> New command is:

>     snprintf(clear_pg_sorttemp, sizeof(clear_pg_sorttemp),
>             "rm -f \"%s\"/base/*/pg_sorttemp/*",
>             DataDir);

I said cd for a reason: if you do it that way, you've cut the maximum
number of files you can delete by at least an order of magnitude,
depending on how long DataDir is.

Why do we need per-database sorttemp areas anyway?  Seems better to have
an installation-wide one.

            regards, tom lane