Re: pgbench --tuple-size option

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: Andres Freund <andres(at)2ndquadrant(dot)com>
Cc: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pgbench --tuple-size option
Date: 2014-08-15 10:17:31
Message-ID: alpine.DEB.2.02.1408151206180.14344@andorre
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


>>> I don't think it's beneficial to put this into pgbench. There really
>>> isn't a relevant benefit over using a custom script here.
>>
>> The scripts to run are the standard ones. The difference is in the
>> *initialization* phase (-i), namely the filler attribute size. There is no
>> custom script for initialization in pgbench, so ISTM that this argument does
>> not apply here.
>
> The custom initialization is to run a manual ALTER after the
> initialization.

Sure, it can be done this way.

I'm not sure about the implication of ALTER on the table storage, thus I
prefer all benchmarks to run exactly the same straightforward way in all
cases so as to avoid unwanted effects on what I'm trying to measure, which
is already noisy and unstable enough.

--
Fabien.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2014-08-15 10:24:20 Re: pgbench --tuple-size option
Previous Message Andres Freund 2014-08-15 10:01:30 Re: pgbench --tuple-size option