Re: Query running for 12 hours

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