Horton

Re: [WIP] Zipfian distribution in pgbench

Alik Khilazhev <a.khilazhev@postgrespro.ru>

View thread View on postgr.es
From: Alik Khilazhev <a.khilazhev@postgrespro.ru>
To: Peter Geoghegan <pg@bowt.ie>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2017-07-14T13:37:50Z
Lists: pgsql-hackers

Attachments

> On 13 Jul 2017, at 23:13, Peter Geoghegan <pg@bowt.ie> wrote:
> 
> I just figured out that "result.txt" is only a 60 second pgbench run.
> Is the same true for other tests?

Yes, other tests ran 60 seconds too.

> 
> It would be much more interesting to see runs that lasted 10 minutes
> or more.


I am attaching results of tests for 32 and 128 clients that were running for 10 minutes, and TPS remains 305 and 115 ktps respectively. 

Tests was executed with configuration set for YCSB. And there is very aggressively autovacuum, this can be reason why there is no decline appears with increasing working time.
Autovacuum config:

	autovacuum_max_workers = 8 
	autovacuum_naptime = 10s
	autovacuum_vacuum_scale_factor = 0.1
	autovacuum_vacuum_cost_delay = 0ms
	autovacuum_vacuum_cost_limit = 10000

Commits

  1. Add approximated Zipfian-distributed random generator to pgbench.