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
: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
(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
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
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
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
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
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
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
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
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
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
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
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
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.
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
(
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
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
18 matches
Mail list logo