Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement)

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: Greg Smith <greg(at)2ndQuadrant(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement)
Date: 2013-06-30 06:04:15
Message-ID: alpine.DEB.2.02.1306300749020.2808@localhost6.localdomain6
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> [...] Why? I don't know exactly why, but I am sure that pgbench isn't
> doing anything weird. It's either libpq acting funny, or the OS.

My guess is the OS. "PQfinish" or "select" do/are systems calls that
present opportunities to switch context. I think that the OS is passing
time with other processes on the same host, expecially postgres backends,
when it is not with the client. In order to test that, pgbench should run
on a dedicated box with less threads than the number of available cores,
or user time could be measured in addition to elapsed time. Also, testing
with many clients per thread means that if any client is stuck all other
clients incur an artificial latency: measures are intrinsically fragile.

> I need to catch up with revisions done to this feature since I started
> instrumenting my copy more heavily. I hope I can get this ready for
> commit by Monday.

Ok, thanks!

--
Fabien.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabien COELHO 2013-06-30 06:07:34 Re: New regression test time
Previous Message Michael Paquier 2013-06-30 05:29:20 Re: pg_ctl and -h/help