Sean,
What Nuria said. It seems we've missed this one. Sorry for the trouble.
Leila
On Mon, Nov 10, 2014 at 8:01 AM, Nuria Ruiz wrote:
> cc-ing leila as we were experimenting with these some weeks back in SF, I
> think they can be killed w/o problems. I did not know they were still
> runnin
On Tue, Nov 11, 2014 at 8:44 AM, Dan Andreescu
wrote:
> Sean what came of your discussion with Coren about limiting time or memory
> of queries? I think we should totally start enforcing those kinds of
> limits as it seems any queries running longer than a few days are usually
> accidents.
Tha
Sean what came of your discussion with Coren about limiting time or memory
of queries? I think we should totally start enforcing those kinds of
limits as it seems any queries running longer than a few days are usually
accidents.
On Monday, November 10, 2014, Dario Taraborelli
wrote:
> Let's kil
Let's kill them (Leila is OoO today and tomorrow).
> On Nov 10, 2014, at 08:01, Nuria Ruiz wrote:
>
> cc-ing leila as we were experimenting with these some weeks back in SF, I
> think they can be killed w/o problems. I did not know they were still
> running, we run a faster version of those qu
cc-ing leila as we were experimenting with these some weeks back in SF, I
think they can be killed w/o problems. I did not know they were still
running, we run a faster version of those queries and got the data we were
interested in a while back.
On Mon, Nov 10, 2014 at 1:55 AM, Sean Pringle
wrot
Three identical queries from the 'research_prod' user have just passed one
month execution time on s1-anlytics-slave:
select count(*)
from staging.ourvision r
where exists (
select *
from staging.ourvision r1
inner join
staging.ourvision r2
on r2.sha1 = r1.sha1
w