Re: Same query doing slow then quick - Mailing list pgsql-performance

From Nikolay Ulyanitsky
Subject Re: Same query doing slow then quick
Date
Msg-id CA+MedixsJbhjPGsKiWsp3ENjAnR3r3Ajw_nVtYsWGDBgSeJAYA@mail.gmail.com
Whole thread Raw
In response to Re: Same query doing slow then quick  (FFW_Rude <FFW_Rude@hotmail.com>)
Responses Re: Same query doing slow then quick
Re: Same query doing slow then quick
List pgsql-performance
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


pgsql-performance by date:

Previous
From: FFW_Rude
Date:
Subject: Re: Same query doing slow then quick
Next
From: Robert Sosinski
Date:
Subject: Inaccurate Explain Cost