Re: Same query doing slow then quick

Поиск
Список
Период
Сортировка
От Nikolay Ulyanitsky
Тема Re: Same query doing slow then quick
Дата
Msg-id CA+MedixsJbhjPGsKiWsp3ENjAnR3r3Ajw_nVtYsWGDBgSeJAYA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Same query doing slow then quick  (FFW_Rude <FFW_Rude@hotmail.com>)
Ответы Re: Same query doing slow then quick  (Undertaker Rude <ffw_rude@hotmail.com>)
Re: Same query doing slow then quick  (Undertaker Rude <ffw_rude@hotmail.com>)
Список 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 по дате отправления:

Предыдущее
От: FFW_Rude
Дата:
Сообщение: Re: Same query doing slow then quick
Следующее
От: Robert Sosinski
Дата:
Сообщение: Inaccurate Explain Cost