Tomas Vondra wrote: > I've been thinking about this a bit more, and do propose to use an > option that determines "logging step" i.e. number of items (either > directly or as a percentage) between log lines. > > The attached patch defines a new option "--logging-step" that accepts > either integers or percents. For example if you want to print a line > each 1000 lines, you can to this > > $ pgbench -i -s 1000 --logging-step 1000 testdb
I find it hard to get excited about having to specify a command line argument to tweak this. Would it work to have it emit messages depending on elapsed time and log scale of tuples emitted? So for example emit the first message after 5 seconds or 100k tuples, then back off until (say) 15 seconds have lapsed and 1M tuples, etc? The idea is to make it verbose enough to keep a human satisfied with what he sees, but not flood the terminal with pointless updates. (I think printing the ETA might be nice as well, not sure). -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers