Re: pgbench - compute & show latency consistently

Поиск
Список
Период
Сортировка
От Kuntal Ghosh
Тема Re: pgbench - compute & show latency consistently
Дата
Msg-id CAGz5QCKixmkSQeeU1F+Nnwesq+zh5h6AAqgsogtCbDT61va_2A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pgbench - compute & show latency consistently  (Fabien COELHO <coelho@cri.ensmp.fr>)
Список pgsql-hackers
On Wed, Sep 21, 2016 at 6:53 PM, Fabien COELHO <coelho@cri.ensmp.fr> wrote:
> In front of the tps line. Well, the performance displayed could also be
> improved... On my dual core SSD laptop I just got:
>
>  sh> ./pgbench -c 10 -t 1000
>  starting vacuum...end.
>  transaction type: <builtin: TPC-B (sort of)>
>  scaling factor: 100
>  query mode: simple
>  number of clients: 10
>  number of threads: 1
>  number of transactions per client: 1000
>  number of transactions actually processed: 10000/10000
>  latency average = 9.527 ms
>  tps = 1049.665115 (including connections establishing)
>  tps = 1049.890194 (excluding connections establishing)
>
> Which is about 10 times better.

Yes, you are right. In the documentation, the above example has not
been updated across different pg versions. Although this is just an
example, it should reflect the current performance.

-- 
Thanks & Regards,
Kuntal Ghosh
EnterpriseDB: http://www.enterprisedb.com



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Rushabh Lathia
Дата:
Сообщение: Re: Confusing docs about GetForeignUpperPaths in fdwhandler.sgml
Следующее
От: Yury Zhuravlev
Дата:
Сообщение: Re: File system operations.