Re: Improving pgbench to log index creation time etc.

Tatsuo Ishii <ishii@postgresql.org> writes:
> 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?

I would think if you wanted that, you could set up a custom script that
does CREATE INDEX and/or VACUUM.  The built-in scenario isn't all that
interesting...
        regards, tom lane