newsbin.com

Previously, when I did a shift+del for the posts, it would reflect on the folder size of the posts folder. Now, when I do a shift+del, it seems to just delete it from view and for future searches, but are the posts deleted from the folders? The folder size doesn't change.

the db3 file doesnt shrink, it gets toa size then when you delete stuff that space is re allocated for future use such as when you update headers

I was referring to the spool file. That doesn't change?

In v6 the headers are initially downloaded into a rv4 file and then processed into a .db3 database. The .rv4 files are removed after being processed. The processed header information is stored in the .db3 databases. This .db3 file does not shrink as headers are removed - instead the space merely gets marked internally for re-use. This means that for a given group it tends to grow until the number of headers in the database reaches a steady value and then the database stays at that size. This is the trade-ff that v6 makes - the additional space required to store the information in a database to get the extra speed of access and reduced memory footprint at a later stage when loading and processing Post lists.

I guess one could run a sqlite3 "vacuum" command on the database and that would reclaim any unused space, but it could take a long time to run on a large database.

and the spool is a db3 file, no it grows to a size and then if things are deleted the space doesnt just shrink it just puts new data there