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