On 05/30/2018 07:00 AM, Melvin Davidson wrote:
>
>
>
> T*wo things:
> *
> *From your explain, it looks like you need an index on this_.tarih,
> since it is doing a sequential scan when it should be using an index.*
> *
> *
> *Also, your main problem is that when you have two exact same queries
> executing at the same time, they will cause contention in*
> *the disk, and neither one will make much progress.
I am having a hard time seeing how two SELECT queries that on average
take ~6 secs each can stay in contention for 12+ hours, especially with:
waiting | f
> *
>
> --
> *Melvin Davidson**
> Maj. Database & Exploration Specialist**
> Universe Exploration Command – UXC***
> Employment by invitation only!
--
Adrian Klaver
adrian.klaver@aklaver.com