Re: Same query doing slow then quick

From: Nikolay Ulyanitsky <lystor(at)gmail(dot)com>
To: FFW_Rude <FFW_Rude(at)hotmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Same query doing slow then quick
Date: 2012-09-26 16:30:30
Message-ID: CA+MedixsJbhjPGsKiWsp3ENjAnR3r3Ajw_nVtYsWGDBgSeJAYA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Shiran Kleiderman 2012-09-26 16:41:48 Re: Memory issues
Previous Message Scott Marlowe 2012-09-26 16:29:07 Re: Memory issues