Re: PATCH: pgbench - break out timing data for initialization phases

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: "Rady, Doug" <radydoug(at)amazon(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PATCH: pgbench - break out timing data for initialization phases
Date: 2017-09-25 18:07:03
Message-ID: alpine.DEB.2.20.1709252001520.24753@lancre
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Hello Doug,

> total time: 316.03 s (insert 161.60 s, commit 0.64 s, vacuum 60.77 s, index 93.01 s)

Definitely interesting.

There is a "ready for committers" patch in the CF which extensively rework
the initialization: it becomes customizable, and this approach may not
work as is after that...

Maybe you could investigate how it may be implemented on top of that?

Either show times when the phases are performed computed, or maybe use
some auxiliary data structure to keep the information (hmmm...).

--
Fabien.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2017-09-25 18:07:40 Re: PATCH: pgbench - option to build using ppoll() for larger connection counts
Previous Message Bossart, Nathan 2017-09-25 18:04:25 Enhancements to passwordcheck