pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Undertaker Rude <ffw_rude@hotmail.com>
To: lystor@gmail.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Same query doing slow then quick
Date: Thu, 27 Sep 2012 11:01:48 +0200
Message-ID: <SNT111-W20B3CDB3E80467A7F50855E1830@phx.gbl> (raw)
In-Reply-To: <CA+MedixsJbhjPGsKiWsp3ENjAnR3r3Ajw_nVtYsWGDBgSeJAYA@mail.gmail.com>
References: <SNT111-W18646B5C50D8B2D96AE68DE19C0@phx.gbl>
	<506307E2.4060504@ulb.ac.be>
	<1348668859243-5725505.post@n5.nabble.com>
	<50630E6F.5040605@ulb.ac.be>
	<SNT111-W245F4E05303F533C4356C2E19C0@phx.gbl>
	<506316B1.70900@ulb.ac.be>
	<SNT111-W28A5F2A90FEADAB0F881F9E19C0@phx.gbl>
	<CA+MedixJ3jH2q3HBRqDj54SJRq-hi_ktBofUvSspYqdyzuf41w@mail.gmail.com>
	<SNT111-W2025F9BE2B94A56FE1CE13E19C0@phx.gbl>
	<CA+Medix+6HXJT3F67c=Wn2XPtHeo+2qzB6f1YSS_XMNDA6xf6A@mail.gmail.com>
	<SNT111-W2098D2E9847FEE99A5828E19C0@phx.gbl>
	<CA+MedixsJbhjPGsKiWsp3ENjAnR3r3Ajw_nVtYsWGDBgSeJAYA@mail.gmail.com>


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@gmail.com
> To: FFW_Rude@hotmail.com
> CC: pgsql-performance@postgresql.org
> 
> On 26 September 2012 19:09, FFW_Rude <FFW_Rude@hotmail.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
 		 	   		  =

view thread (21+ messages)  latest in thread

Message-ID: <SNT111-W20B3CDB3E80467A7F50855E1830@phx.gbl>
Permalink:  ../SNT111-W20B3CDB3E80467A7F50855E1830@phx.gbl/
Also on:    postgresql.org/message-id/SNT111-W20B3CDB3E80467A7F50855E1830@phx.gbl

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: ffw_rude@hotmail.com, lystor@gmail.com
  Subject: Re: Same query doing slow then quick
  In-Reply-To: <SNT111-W20B3CDB3E80467A7F50855E1830@phx.gbl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox