Re: pgsql: pg_test_fsync: update output to show usecs/op clearer

On Thu, May  2, 2013 at 08:38:39AM -0700, Peter Geoghegan wrote:
> On Thu, May 2, 2013 at 7:27 AM, Bruce Momjian <bruce@momjian.us> wrote:
> > pg_test_fsync: update output to show usecs/op clearer
>
> I don't think that this is an improvement. Not everyone knows that
> usec is shorthand for microsecond. If I Google usec, I see something
> about the United States Enrichment Corporation, but that's about it.

Well, we use 'usecs' all over our code, and in pg_test_timing:

    Histogram of timing durations:
    < usec   % of total      count
         1     95.86499   69510498
         2      4.13395    2997478
         4      0.00062        453
         8      0.00042        301
        16      0.00001          8
        32      0.00000          1

Microseconds just isn't going to fit there.  Postgres understands usec:

    test=> select '1 usec'::interval;
        interval
    -----------------
     00:00:00.000001
    (1 row)

I think the people running these tools are going to know usec.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +