Horton

Re: pgbench - allow to create partitioned tables

Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

View thread View on postgr.es
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: Fabien COELHO <coelho@cri.ensmp.fr>, Alvaro Herrera <alvherre@2ndquadrant.com>, Asif Rehman <asifr.rehman@gmail.com>, PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2020-01-03T10:51:15Z
Lists: pgsql-hackers 
On 2020-01-03 11:04, Amit Kapila wrote:
> On Fri, Jan 3, 2020 at 3:24 PM Peter Eisentraut
> <peter.eisentraut@2ndquadrant.com> wrote:
>>
>> The documentation and pgbench --help output that accompanied this patch
>> claims that the argument to pgbench --partition-method is optional and
>> defaults to "range", but that is not actually the case, as the
>> implementation requires an argument.  Could you please sort this out?
>>
> 
> AFAICS, if the user omits this argument, then the default is range as
> specified in docs.  I tried by using something like 'pgbench.exe -i -s
> 1 --partitions=2 postgres' and then run 'pgbench -S postgres'.

Ah, the way I interpreted this is that the argument to 
--partition-method itself is optional.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Commits

  1. pgbench: add --partitions and --partition-method options.