[kdepim-users] akonadi fsck fails

J. Roeleveld joost at antarean.org
Wed Aug 26 18:01:48 BST 2015

On 26 August 2015 18:45:27 CEST, Pablo Sanchez <pablo at blueoakdb.com> wrote:
>[ Comments below, in-line ]
>On 08/26/2015 12:23 PM, J. Roeleveld wrote:
>>>     DELETE FROM pimitemflagrelation
>>> >                LEFT JOIN pimitemtable
>>> >                   ON pimitemflagrelation.pimitem_id =
>>> >    WHERE  pimitemtable.id IS NULL;
>>> >
>>> >I'm not sure whether MySQL supports a LEFT JOIN in the DELETE but
>>> >should be able to give it a whirl.  :)
>> Personally, I don't care about MySQL. So someone who uses that will
>need to test it.
>> Can that be easily built using QueryBuilder?
>> I will try this week (end) and get back on this.
>> --
>> Joost
>Hi Joost,
>Are you using Postgres?  If so, once it works, please try running an 
>EXPLAIN and send me the output.  We can see what PG thinks.
>What would be awesome is if you ran an EXPLAIN, saved the results, then
>run an ANALYZE on the two objects: [pimitemflagrelation] and 
>[pimitemtable].  Then re-do the EXPLAIN.

Yes, running a standalone server. Found that performs better compared to running it started by akonadi.
Also means I only run 1 instance. (Use that for development work as well)

I will do the explains later today or tomorrow. Don't have my laptop with me atm.


Sent from my Android device with K-9 Mail. Please excuse my brevity.
KDE PIM users mailing list
Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users

More information about the kdepim-users mailing list