Reducing .local/share/akonadi

[Daniel Vrátil]

On Sunday, 23 July 2017 15:31:03 CEST solitone wrote:
> On Sunday, 23 July 2017 11:29:03 CEST you wrote:
> > This is called on-demand retrieval and you can configure how long
> > the email body should be cached in Akonadi in Folder properties ->
> > Retrieval.
> 
> Thank you!
> 
> I've checked on some folders, and they have the default, which is inherit
> from parent folder or account. So all my folders inherit from the account
> setting. I haven't found that setting at account level, though.
> 
> In any case, the default value seems just 60 minutes. So I shouldn't have
> much data on my disc, apart from headers, since bodies are deleted after
> just 60 minutes. More than 1 GB of headers seems so much, but maybe I'm
> mistaken.

On my system the average size of email headers is around 3.2 kB [0], so 
depending on how many emails you have, 1 GB does not sound as an entirely 
unreasonable number. Plus there's additional metadata for each email stored in 
Akonadi (the so called envelope, avg size 620 bytes on my system), and of 
course  there's an overhead from the database itself - mostly indexes.

Dan

[0] You can measure it yourself by running the following SQL query in the 
Akonadi Console's "DB Console":

SELECT AVG(datasize) FROM parttable WHERE parttypeid = (SELECT id FROM 
parttypetable WHERE ns = 'PLD' AND name = 'HEAD')

The result is an average size of all "header" parts, in bytes.

-- 
Daniel Vrátil
www.dvratil.cz | dvratil at kde.org
IRC: dvratil on Freenode (#kde, #kontact, #akonadi, #fedora-kde)

GPG Key: 0x4D69557AECB13683
Fingerprint: 0ABD FA55 A4E6 BEA9 9A83 EA97 4D69 557A ECB1 3683
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kdepim-users/attachments/20170723/0497beb4/attachment.sig>