Switched to PostgreSQL
martin at lichtvoll.de
Thu Apr 11 08:39:19 BST 2019
So after 2/3rd's of a day and letting it scan through the local maildir
collection throughout the night, after at some point during the day I
stopped akonadi_indexing_agent to accelerate the scanning process, I
have my private KDEPIM/Akonadi setup on PostgreSQL.
So far the performance is really quite a bit better. The stalls during
filtering are gone. About the crashes I am not sure yet. Also I found
that there are no stalls anymore on deleting a mail.
So far it looks like this:
~/.local/share/akonadi> LANG=en du -sch *
Did anyone with PostgreSQL setup did any tuning on the database?
I see that the various PostgreSQL processes do not take all that much
RAM yet. They take quite a bit of RSS, but apparently share lots of it,
so the PSS is quite a bit lower (see in atop, memory display with "m",
enable PSIZE gathering with "R").
Is there something like mysqltuner for PostgreSQL? Otherwise I can use
my own training slides or official documentation.
However, as long as it stays as fast as it currently is, I might just
let the configuration alone for now.
Let's see how this goes.
Thanks again for the hint to switch to PostgreSQL and the instructions
for how to do it.
More information about the kdepim-users