Hi Eike, hi. Eike Lantzsch ZP5CGE / KY4PZ - 18.12.24, 22:35:27 MEZ: > Thanks, > so I reckon that I can go on using PostgreSQL and if I like can migrate > to SQLite3 later - is that right?
Exactly. I'd recommend that even. Do one step at a time. Test KDEPIM 24.12 for some weeks and then, if you like, do the migration. My latest setup with PostgreSQL was PostgreSQL 15. I was happy to migrate to SQLite 3, cause I got fed up having to upgrade PostgreSQL cluster every now and then. I do not like to be a database administrator just to use a mail program. I was surprised by the immense improvement of the performance. I did not expect that. I have more than one and a half million of local mails and for the first time ever akonadi_indexing_agent actually completed the job to full text index them without bogging down even a very powerful ThinkPad T14 AMD Gen 5 laptop with Samsung 990 Pro SSD to an extent I gave up by stopping the indexing and chmod'ing akonadi indexing agent to 000. Also during daily use it is a difference as night and day. Akonadi SQLite3 database is currently 2,4G, Xapian based search database is 12 GiB. Best, -- Martin
