Skip site navigation (1) Skip section navigation (2)

Re: Same query doing slow then quick

From: Undertaker Rude <ffw_rude(at)hotmail(dot)com>
To: <lystor(at)gmail(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Same query doing slow then quick
Date: 2012-09-26 16:05:11
Message-ID: SNT111-W33F40E695B490C3012EF54E19C0@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-performance
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-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/artist/last-territory/id533857009?ign-mpt=uo%3D4


> Date: Wed, 26 Sep 2012 18:52:27 +0300
> Subject: Re: [PERFORM] Same query doing slow then quick
> From: lystor(at)gmail(dot)com
> To: FFW_Rude(at)hotmail(dot)com
> CC: pgsql-performance(at)postgresql(dot)org
> 
> On 26 September 2012 18:38, FFW_Rude <FFW_Rude(at)hotmail(dot)com> wrote:
> > root(at)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 have
> > #fsync = on (so it's off right ?).
> 
> Disable fsync for pgbench temporarily.
> 
> 
> > pgbench is not found on my server. Do i have to apt-get install pgbench ?
> 
> Install the postgresql-contrib deb:
> http://pkgs.org/download/postgresql-contrib
> 
> # sudo apt-get update
> # sudo apt-get install postgresql-contrib
> 
> 
> --
> With best regards,
> Nikolay
 		 	   		  

In response to

pgsql-performance by date

Next:From: FFW_RudeDate: 2012-09-26 16:09:17
Subject: Re: Same query doing slow then quick
Previous:From: Nikolay UlyanitskyDate: 2012-09-26 15:52:27
Subject: Re: Same query doing slow then quick

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group