Re: [WIP] Zipfian distribution in pgbench

From: Alik Khilazhev <a(dot)khilazhev(at)postgrespro(dot)ru>
To: Peter Geoghegan <pg(at)bowt(dot)ie>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [WIP] Zipfian distribution in pgbench
Date: 2017-07-14 13:37:50
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

> On 13 Jul 2017, at 23:13, Peter Geoghegan <pg(at)bowt(dot)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

Attachment Content-Type Size
pgbench_index_after_128_10min.txt text/plain 17.9 KB
pgbench_index_after_32_10min.txt text/plain 17.9 KB
unknown_filename text/plain 119 bytes

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Marina Polyakova 2017-07-14 13:41:49 Re: WIP Patch: Pgbench Serialization and deadlock errors
Previous Message Haribabu Kommi 2017-07-14 13:35:56 Re: Pluggable storage