Re: Same query doing slow then quick

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