[kdepim-users] akonadi fsck fails

[J. Roeleveld]

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 =
>pimitemtable.id
>>> >    WHERE  pimitemtable.id IS NULL;
>>> >
>>> >I'm not sure whether MySQL supports a LEFT JOIN in the DELETE but
>you
>>> >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.

--
Joost 


-- 
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