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