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

Поиск
Список
Период
Сортировка
Искать
От
Bruce Momjian
Тема
Re: pgsql: pg_test_fsync: update output to show usecs/op clearer
Дата
в 16:08:48
Msg-id
20130502160845.GB24822@momjian.us
Ответ на
Список
Дерево обсуждения
pgsql: pg_test_fsync: update output to show usecs/op clearer Bruce Momjian <bruce@momjian.us>
Re: pgsql: pg_test_fsync: update output to show usecs/op clearer Peter Geoghegan <pg@heroku.com>
Re: pgsql: pg_test_fsync: update output to show usecs/op clearer Bruce Momjian <bruce@momjian.us>
Re: pgsql: pg_test_fsync: update output to show usecs/op clearer Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: pgsql: pg_test_fsync: update output to show usecs/op clearer Bruce Momjian <bruce@momjian.us>
Re: pgsql: pg_test_fsync: update output to show usecs/op clearer Andres Freund <andres@2ndquadrant.com>
Re: pgsql: pg_test_fsync: update output to show usecs/op clearer Bruce Momjian <bruce@momjian.us>
Re: pgsql: pg_test_fsync: update output to show usecs/op clearer Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: pgsql: pg_test_fsync: update output to show usecs/op clearer Bruce Momjian <bruce@momjian.us>
Re: pgsql: pg_test_fsync: update output to show usecs/op clearer Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: pgsql: pg_test_fsync: update output to show usecs/op clearer Bruce Momjian <bruce@momjian.us>
Re: pgsql: pg_test_fsync: update output to show usecs/op clearer Greg Stark <stark@mit.edu>
On Thu, May  2, 2013 at 08:38:39AM -0700, Peter Geoghegan wrote:
> On Thu, May 2, 2013 at 7:27 AM, Bruce Momjian  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          http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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

В списке pgsql-committers по дате отправления
От: Dimitri Fontaine
Дата:
От: Bruce Momjian
Дата:
FAQ