pgbench - allow to specify scale as a size

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: pgbench - allow to specify scale as a size
Date: 2018-02-17 09:20:14
Message-ID: alpine.DEB.2.20.1802171013110.20813@lancre
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


After Karel Moppel piece on pgbench scale/size conversion, it occured to
me that having this as an option would be nice.

https://www.cybertec-postgresql.com/en/a-formula-to-calculate-pgbench-scaling-factor-for-target-db-size/

Here is a attempt at extending --scale so that it can be given a size.

pgbench -i --scale=124G ...

The approximated database size is also shown in the end-of-run summary.

--
Fabien.

Attachment Content-Type Size
pgbench-scale-size-1.patch text/x-diff 6.5 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2018-02-17 09:24:39 Re: [HACKERS] path toward faster partition pruning
Previous Message Arthur Zakirov 2018-02-17 09:02:40 Re: [HACKERS] Bug in to_timestamp().