Re: [HACKERS] PATCH: pgbench - break out timing data for initializationphases - Mailing list pgsql-hackers

From Fabien COELHO
Subject Re: [HACKERS] PATCH: pgbench - break out timing data for initializationphases
Date
Msg-id alpine.DEB.2.20.1709252001520.24753@lancre
Whole thread Raw
In response to [HACKERS] PATCH: pgbench - break out timing data for initialization phases  ("Rady, Doug" <radydoug@amazon.com>)
Responses Re: [HACKERS] PATCH: pgbench - break out timing data forinitialization phases
List 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.


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

pgsql-hackers by date:

Previous
From: "Bossart, Nathan"
Date:
Subject: [HACKERS] Enhancements to passwordcheck
Next
From: Andres Freund
Date:
Subject: Re: [HACKERS] PATCH: pgbench - option to build using ppoll() forlarger connection counts