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 ? Ou acheter ? La Fnac iTunes > Date: Wed, 26 Sep 2012 19:30:30 +0300 > Subject: Re: Same query doing slow then quick > From: lystor@xxxxxxxxx > To: FFW_Rude@xxxxxxxxxxx > CC: pgsql-performance@xxxxxxxxxxxxxx > > On 26 September 2012 19:09, FFW_Rude <FFW_Rude@xxxxxxxxxxx> 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 |