Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TH9yj-000740-0e for pgsql-performance@postgresql.org; Thu, 27 Sep 2012 09:01:53 +0000 Received: from snt0-omc4-s15.snt0.hotmail.com ([65.55.90.218]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TH9yh-0004Cn-A2 for pgsql-performance@postgresql.org; Thu, 27 Sep 2012 09:01:52 +0000 Received: from SNT111-W20 ([65.55.90.199]) by snt0-omc4-s15.snt0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Thu, 27 Sep 2012 02:01:48 -0700 Message-ID: Content-Type: multipart/alternative; boundary="_8f9653ab-167a-4538-af44-57fb9eee2748_" X-Originating-IP: [92.103.148.121] From: Undertaker Rude To: CC: Subject: Re: Same query doing slow then quick Date: Thu, 27 Sep 2012 11:01:48 +0200 Importance: Normal In-Reply-To: References: , <506307E2.4060504@ulb.ac.be>, <1348668859243-5725505.post@n5.nabble.com>, <50630E6F.5040605@ulb.ac.be>, , <506316B1.70900@ulb.ac.be>, , , , , , MIME-Version: 1.0 X-OriginalArrivalTime: 27 Sep 2012 09:01:48.0727 (UTC) FILETIME=[BA3A1470:01CD9C8E] X-Pg-Spam-Score: -1.7 (-) X-Archive-Number: 201209/154 X-Sequence-Number: 47900 --_8f9653ab-167a-4538-af44-57fb9eee2748_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 =E9couter ?http://www.deezer.com/fr/music/last-territory/the-last-hope-3= 617781 (Post-apocalyptic Metal)http://www.deezer.com/fr/music/rude-un= dertaker (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= =3Duo%3D4 > Date: Wed=2C 26 Sep 2012 19:30:30 +0300 > Subject: Re: [PERFORM] Same query doing slow then quick > From: lystor@gmail.com > To: FFW_Rude@hotmail.com > CC: pgsql-performance@postgresql.org >=20 > On 26 September 2012 19:09=2C FFW_Rude wrote: > > Could you explain what you are asking me to do because i don't really k= now > > what i'm doing... >=20 > postgresql-contrib packages contains pgbench tool on Ubuntu. >=20 > For example postgresql-contrib-9.1_9.1.3-2_i386.deb on Ubuntu 12.04 conta= ins: > /usr/lib/postgresql/9.1/bin/pgbench >=20 >=20 > > i don't have pgbench in it. It is still pgbench command not found... >=20 > You need to run pgbench as postgres user. > For example on CentOS: > # su - postgres > $ pgbench -i pgbench && pgbench -c 10 -t 10000 pgbench >=20 >=20 > -- > With best regards=2C > Nikolay = --_8f9653ab-167a-4538-af44-57fb9eee2748_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
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 =E9couter ?
http://www.dee= zer.com/fr/music/last-territory/the-last-hope-3617781  =3B =3B  =3B  =3B(<= /span>Post-apocalyp= tic Metal)

Ou acheter ?
La Fnac

iTunes


>=3B Date: Wed= =2C 26 Sep 2012 19:30:30 +0300
>=3B Subject: Re: [PERFORM] Same query = doing slow then quick
>=3B From: lystor@gmail.com
>=3B To: FFW_Ru= de@hotmail.com
>=3B CC: pgsql-performance@postgresql.org
>=3B >=3B On 26 September 2012 19:09=2C FFW_Rude <=3BFFW_Rude@hotmail.com&g= t=3B wrote:
>=3B >=3B Could you explain what you are asking me to do= because i don't really know
>=3B >=3B what i'm doing...
>=3B <= br>>=3B postgresql-contrib packages contains pgbench tool on Ubuntu.
&= gt=3B
>=3B For example postgresql-contrib-9.1_9.1.3-2_i386.deb on Ubu= ntu 12.04 contains:
>=3B /usr/lib/postgresql/9.1/bin/pgbench
>=3B=
>=3B
>=3B >=3B i don't have pgbench in it. It is still pgben= ch command not found...
>=3B
>=3B You need to run pgbench as pos= tgres user.
>=3B For example on CentOS:
>=3B # su - postgres
&= gt=3B $ pgbench -i pgbench &=3B&=3B pgbench -c 10 -t 10000 pgbench>=3B
>=3B
>=3B --
>=3B With best regards=2C
>=3B N= ikolay
= --_8f9653ab-167a-4538-af44-57fb9eee2748_--