Page 1 of 1

Shift Delete in local search

PostPosted: Mon Apr 16, 2012 9:28 pm
by flat_beer
If I do a local search then a Shift-Delete does that purge those records from the local spool?

The main reason I'm wondering this is that I have my spool on a 48GB partition and I'm down to only 3.7GB free. Using search to find spam that is crossposted to multiple groups and nuke it all at once. That way freeing up space for real posts.

Hum. Looks like I have 6GB wasted on the Image DB. I guess I'll blow that away.

Having newsbin use a separate partition for the spool is helpful in keeping the drive defragmented. (This was much more important back when newsbin used a separate file for each day for each newsgroup. I know there were 30,000+ files in that partition.)

Re: Shift Delete in local search

PostPosted: Mon Apr 16, 2012 10:19 pm
by Quade
Shift-delete deletes but, won't get you any space back till you "Compact Database" which is under "Post Storage"/

Re: Shift Delete in local search

PostPosted: Mon Apr 16, 2012 11:13 pm
by flat_beer
I was under the impression that after the Shift-delete but before the compact the space will get reused by new headers as they arrive. Is this correct? If that is correct then I see no reason to do a compact. At least not very often to most of the groups.

If compacting does something in addition to freeing up drive space (like sorting or something else that speeds up access) then that may be a reason to do it.

BTW. Does compacting take a lot of space when it is doing the compaction? (my current a.b.multimedia spool takes 7.7GB. Will it take about another 7GB while the compaction is running?)

PS. I assume I can just shut off Image DB feature and just delete the .SFE files?

Re: Shift Delete in local search

PostPosted: Tue Apr 17, 2012 8:18 am
by Quade
I was under the impression that after the Shift-delete but before the compact the space will get reused by new headers as they arrive. Is this correct? If


1 - Yes it free's up pages that eventually get re-used.

2 - Compaction does more than free up space. It makes insertion and loading faster.

3 - I'd assume compaction would take about 3 times or more the size of the the existing DB3.

4 - Yes on the image DB.