Improving pgbench to log index creation time etc.

Поиск
Список
Период
Сортировка
От Tatsuo Ishii
Тема Improving pgbench to log index creation time etc.
Дата
Msg-id 20130211.124031.1161065291829523889.t-ishii@sraoss.co.jp
обсуждение исходный текст
Ответы Re: Improving pgbench to log index creation time etc.  (Andres Freund <andres@2ndquadrant.com>)
Re: Improving pgbench to log index creation time etc.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi PostgreSQL hackers,

I often need to calculate time to spend for index creation and vacuum
to analyze PostgreSQL data load performance. Index creation and vacuum
will take non trivial time for large scale data and it is important
information of data loading benchmark.

So I would like to propose to add new options to be used with pgbenh
-i (initialize) mode:

--log-index-creation-duration: log duration of index creation in seconds
--log-vacuum-duration: log duration of vacuum in seconds

What do you think?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: performance regression in 9.2 CTE with SRF function
Следующее
От: Gurjeet Singh
Дата:
Сообщение: Re: Fwd: Successful post to pgsql-hackers