Tatsuo Ishii <is...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers