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

From Alvaro Hernandez
Subject Re: pgbench - allow to specify scale as a size
Date
Msg-id f8572028-4c08-1069-611f-b38367ff5911@ongres.com
Whole thread Raw
In response to Re: pgbench - allow to specify scale as a size  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pgbench - allow to specify scale as a size
Re: pgbench - allow to specify scale as a size
List pgsql-hackers

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.


     Álvaro


-- 

Alvaro Hernandez


-----------
OnGres



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: missing toast table for pg_policy
Next
From: Tom Lane
Date:
Subject: Re: missing toast table for pg_policy