Re: [PERFORM] Same query doing slow then quick

2012-10-08 Thread Undertaker Rude
ion hadn't been answered. > > On Thu, Sep 27, 2012 at 11:33 AM, Undertaker Rude > wrote: > > Oh ok. But what is this command doing ? i'm gonna runn it today. I'll keep > > you posted. Here is some EXPLAIN ANALYZE from the querys : > > > > >

Re: [PERFORM] Same query doing slow then quick

2012-09-27 Thread Undertaker Rude
So i tried to run your pgbench command with the postgres user but it's stil telling me command not found Rude - Last Territory Ou écouter ?http://www.deezer.com/fr/music/last-territory/the-last-hope-3617781 (Post-apocalyptic Metal)http://www.deezer.com/fr/music/rude-undertaker (Pop-Ro

Re: [PERFORM] Same query doing slow then quick

2012-09-27 Thread Undertaker Rude
Oh ok. But what is this command doing ? i'm gonna runn it today. I'll keep you posted. Here is some EXPLAIN ANALYZE from the querys : Nested Loop (cost=0.00..353722.89 rows=124893 width=16) (actual time=261158.061..10304193.501 rows=99 loops=1) Join Filter: ((t2."X" >= (t1.x_min)::double pre

Re: [PERFORM] Same query doing slow then quick

2012-09-26 Thread Undertaker Rude
Ok i'm installing. Can't stop the server right now. I'm gonna have to get back to you tomorrow afternoon (have other tasks that need to run from now until tomorrow by 1pm) Rude - Last Territory Ou écouter ?http://www.deezer.com/fr/music/last-territory/the-last-hope-3617781 (Post-apocalyp