Deleting stored posts

[usmarinecpl]

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.

[richy99]

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

[usmarinecpl]

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

[itimpi]

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.

[richy99]

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