Re: few ideas for pgbench
От | Fabien COELHO |
---|---|
Тема | Re: few ideas for pgbench |
Дата | |
Msg-id | alpine.DEB.2.22.394.2105071121430.3131420@pseudo обсуждение исходный текст |
Ответ на | Re: few ideas for pgbench (Pavel Stehule <pavel.stehule@gmail.com>) |
Ответы |
Re: few ideas for pgbench
|
Список | pgsql-hackers |
>> Finally it is unclear how to add such a feature with minimal impact on the >> source code. > > > It is a question if this is possible without more changes or without > compatibility break :( Probably not. All output should be centralized. Yes and no. For some things we could have "void report_sometype(file, name, data)" which append "data," under csv but "name = data\n" under text, but this does not work for nested data (eg -r -b/-f), which would rather require some json/yaml/whatever format which can embed a hierarchy. >> What I usually do is to put each pgbench run output in a separate file and >> write a small shell/perl/python script to process these, possibly >> generating CSV on the way. > > The goal of my proposal was a reduction of necessity to write auxiliary > scripts. The produced document should not be "nice", but should be very > easy to import it to some analytical tools. Yes, I understood that. I tend to use CSV for that, import results in pg or sqlite and analyse with SQL. > There is an analogy with Postgres's CSV logs. It is the same. We can see > the result of pgbench like some log. Sure, but this works for simple flat data, not changing structures. -- Fabien.
В списке pgsql-hackers по дате отправления: