Re: Remove sort files

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Remove sort files
Date: 2001-05-23 18:02:58
Message-ID: 16111.990640978@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
>> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2001-05-23 18:08:26 Re: Remove sort files
Previous Message Tom Lane 2001-05-23 18:00:39 Re: Remove sort files