Re: pgbench - allow to specify scale as a size - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pgbench - allow to specify scale as a size
Date
Msg-id 22447.1518887837@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgbench - allow to specify scale as a size  (Alvaro Hernandez <aht@ongres.com>)
Responses Re: pgbench - allow to specify scale as a size  (Alvaro Hernandez <aht@ongres.com>)
List pgsql-hackers
Alvaro Hernandez <aht@ongres.com> writes:
> On 17/02/18 11:26, Tom Lane wrote:
>> Fabien COELHO <coelho@cri.ensmp.fr> writes:
>>> Here is a attempt at extending --scale so that it can be given a size.

>> I do not actually find this to be a good idea.  It's going to be
>> platform-dependent, or not very accurate, or both, and thereby
>> contribute to confusion by making results less reproducible.
>> 
>> Plus, what do we do if the backend changes table representation in
>> some way that invalidates Kaarel's formula altogether?  More confusion
>> would be inevitable.

>      Why not then insert a "few" rows, measure size, truncate the table, 
> compute the formula and then insert to the desired user requested size? 
> (or insert what should be the minimum, scale 1, measure, and extrapolate 
> what's missing). It doesn't sound too complicated to me, and targeting a 
> size is something that I believe it's quite good for user.

Then you'd *really* have irreproducible results.

            regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: missing toast table for pg_policy
Next
From: Alvaro Hernandez
Date:
Subject: Re: pgbench - allow to specify scale as a size