Page 1 of 1

Database Compaction

PostPosted: Sat Jan 28, 2012 7:31 pm
by zforgetaboutit
a.b.boneless had a 4+ GB storage*.db3 file. Hadn't been updated since 2011-Aug. I set my display age to 30 (I know), and then requested a 'Post Storage' -> 'purge to display Age'. It ran for 5-10 minutes. Afterwards I saw there was no change in space usage. I then requested a compaction. This ran for a few seconds and still no change in size.

I set DisplayAge = 2 and went through everything again. No change in folder size - still using 4+ GB. Finally I deleted all records, with a compaction, and folder shrunk to 27 MB.

I started a compaction and it claimed it recovered 160000 TB. I restarted Newsbin and compacted again. It says 0MB reclaimed. Still 27MB used.

Unexpected by me.

Re: Database Compaction

PostPosted: Sat Jan 28, 2012 9:40 pm
by Quade
I just tested this the other day with 6.3B4.

Looked at the size, set my local "display age" to 1/2 what it was, then "Purge to Display Age" then compacted. I ended up with 2 smaller DB files.