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-27 09:01:48 |
Message-ID: | SNT111-W20B3CDB3E80467A7F50855E1830@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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-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 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 19:09, FFW_Rude <FFW_Rude(at)hotmail(dot)com> 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/postgresql/9.1/bin/pgbench
>
>
> > i don't have pgbench in it. It is still pgbench command not found...
>
> You need to run pgbench as postgres user.
> For example on CentOS:
> # su - postgres
> $ pgbench -i pgbench && pgbench -c 10 -t 10000 pgbench
>
>
> --
> With best regards,
> Nikolay
From | Date | Subject | |
---|---|---|---|
Next Message | Matthias | 2012-09-27 10:48:24 | Re: [GENERAL] Inaccurate Explain Cost |
Previous Message | Undertaker Rude | 2012-09-27 08:33:33 | Re: Same query doing slow then quick |