Re: [PERFORM] Same query doing slow then quick

2012-10-08 Thread Ants Aasma
Sorry for the late answer, I was going through my e-mail backlog and noticed that this question 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 fr

Re: [PERFORM] Same query doing slow then quick

2012-10-08 Thread Undertaker Rude
:02 +0300 > Subject: Re: [PERFORM] Same query doing slow then quick > From: a...@cybertec.at > To: ffw_r...@hotmail.com > CC: lys...@gmail.com; pgsql-performance@postgresql.org > > Sorry for the late answer, I was going through my e-mail backlog and > noticed that this quest

Re: [PERFORM] Same query doing slow then quick

2012-09-27 Thread Undertaker Rude
(Pop-Rock) Ou acheter ?La Fnachttp://recherche.fnac.com/fmia14622213/Last-Territory http://recherche.fnac.com/fmia14770622/Rude-Undertaker iTuneshttp://itunes.apple.com/us/artist/last-territory/id533857009?ign-mpt=uo%3D4 > Date: Wed, 26 Sep 2012 19:30:30 +0300 > Subject: Re: [PERFORM] Same

Re: [PERFORM] Same query doing slow then quick

2012-09-27 Thread Undertaker Rude
er.com/fr/music/last-territory/the-last-hope-3617781 (Post-apocalyptic Metal)http://www.deezer.com/fr/music/rude-undertaker (Pop-Rock) Ou acheter ?La Fnachttp://recherche.fnac.com/fmia14622213/Last-Territory http://recherche.fnac.com/fmia14770622/Rude-Undertaker iTuneshttp://itunes.apple.com/us/a

Re: [PERFORM] Same query doing slow then quick

2012-09-26 Thread Nikolay Ulyanitsky
On 26 September 2012 19:09, FFW_Rude wrote: > Could you explain what you are asking me to do because i don't really know > what i'm doing... postgresql-contrib packages contains pgbench tool on Ubuntu. For example postgresql-contrib-9.1_9.1.3-2_i386.deb on Ubuntu 12.04 contains: /usr/lib/postgre

Re: [PERFORM] Same query doing slow then quick

2012-09-26 Thread FFW_Rude
so installing postgresql-contrib stopped my server and i don't have pgbench in it. It is still pgbench command not found... Could you explain what you are asking me to do because i don't really know what i'm doing... Rude - Last Territory Ou écouter ?http://www.deezer.com/fr/music/last-territor

Re: [PERFORM] Same query doing slow then quick

2012-09-26 Thread Undertaker Rude
4 > Date: Wed, 26 Sep 2012 18:52:27 +0300 > Subject: Re: [PERFORM] Same query doing slow then quick > From: lys...@gmail.com > To: ffw_r...@hotmail.com > CC: pgsql-performance@postgresql.org > > On 26 September 2012 18:38, FFW_Rude wrote: > > root@testBI:/etc/postgresql

Re: [PERFORM] Same query doing slow then quick

2012-09-26 Thread Nikolay Ulyanitsky
On 26 September 2012 18:38, FFW_Rude wrote: > root@testBI:/etc/postgresql/9.1/main# hdparm -tT /dev/sda > Timing cached reads: 892 MB in 2.01 seconds = 444.42 MB/sec > Timing buffered disk reads: 190 MB in 3.02 seconds = 62.90 MB/sec It's OK for single HDD. > Is fsync off by default ? I

Re: [PERFORM] Same query doing slow then quick

2012-09-26 Thread FFW_Rude
Hi, root@testBI:/etc/postgresql/9.1/main# hdparm -tT /dev/sda /dev/sda: Timing cached reads: 892 MB in 2.01 seconds = 444.42 MB/sec Timing buffered disk reads: 190 MB in 3.02 seconds = 62.90 MB/sec Is fsync off by default ? I have#fsync = on (so it's off right ?). pgbench is not found on my

Re: [PERFORM] Same query doing slow then quick

2012-09-26 Thread Nikolay Ulyanitsky
Hi, FFW_Rude 1. Benchmark the device with your PostgreSQL DB: # hdparm -tT /dev/sda /dev/sda: Timing cached reads: 6604 MB in 2.00 seconds = 3303.03 MB/sec Timing buffered disk reads: 1316 MB in 3.00 seconds = 438.18 MB/sec 2. Benchmark your PostgreSQL with pgbench: Set "fsync = off" on

Re: [PERFORM] Same query doing slow then quick

2012-09-26 Thread Julien Cigar
On 09/26/2012 16:41, FFW_Rude wrote: Ok done to 512Mb and 2048Mb I'm relaunching. See you in a few hours (so tommorrow) with 250 000 rows and proper indexes it should run in less than a second. be sure your indexes are set properly and that they're used (use EXPLAIN ANALYZE for that) within y

Re: [PERFORM] Same query doing slow then quick

2012-09-26 Thread FFW_Rude
My bad. Did not see that part. I tried to elevate buffer and SHMAX was a problem. I'll give it another try and will keep you posted. Thank you. Rude - Last Territory Ou écouter ?http://www.deezer.com/fr/music/last-territory/the-last-hope-3617781 (Post-apocalyptic Metal)http://www.deezer.c

Re: [PERFORM] Same query doing slow then quick

2012-09-26 Thread Julien Cigar
On 09/26/2012 16:14, FFW_Rude wrote: Thank for you answer. shared_buffer is at 24Mb effective_cache_size at 2048Mb What do you mean properly ? That's not really helping a novice... from my previous mail: before looking further, please configure shared_buffers and effective_cache_size prope

Re: [PERFORM] Same query doing slow then quick

2012-09-26 Thread FFW_Rude
Thank for you answer. shared_buffer is at 24Mb effective_cache_size at 2048Mb What do you mean properly ? That's not really helping a novice... -- View this message in context: http://postgresql.1045698.n5.nabble.com/Same-query-doing-slow-then-quick-tp5725486p5725505.html Sent from the Postg

Re: [PERFORM] Same query doing slow then quick

2012-09-26 Thread Julien Cigar
On 09/26/2012 15:36, FFW_Rude wrote: Hi, Thank you for your answer. It was already at 16MB and i upped it just this morning to 64MB. Still no change that's normal, please configure shared_buffers and effective_cache_size properly Rude - Last Territory *Ou écouter ?* http://www.deezer.

Re: [PERFORM] Same query doing slow then quick

2012-09-26 Thread FFW_Rude
Hi, Thank you for your answer. It was already at 16MB and i upped it just this morning to 64MB. Still no change 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 (

Re: [PERFORM] Same query doing slow then quick

2012-09-26 Thread Julien Cigar
On 09/26/2012 15:03, FFW_Rude wrote: Here is the answer to Ray Stell who send me the wiki page of Slow Query. I hope i detailed all you wanted (i basicly pasted the page and add my answers). Full Table and Index Schema: schema tables_adresses "Tables" tables_adresses.adresses_XX (id (serial), X

Re: [PERFORM] Same query doing slow then quick

2012-09-26 Thread FFW_Rude
Here is the answer to Ray Stell who send me the wiki page of Slow Query. I hope i detailed all you wanted (i basicly pasted the page and add my answers). Full Table and Index Schema: schema tables_adresses "Tables" tables_adresses.adresses_XX (id (serial), X(Double precision),Y (Double precision