Re: pgbench - allow to create partitioned tables

Fabien COELHO <[email protected]>
Newsgroups gmane.comp.db.postgresql.devel.general
Message-ID <alpine.DEB.2.21.2001031302110.3482@pseudo>
Hello Peter,

>>> 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.

Yep. Optionnal stuff would be in [], where () is used for choices.

Would the attached have improved your understanding? It is somehow more 
consistent with other help lines.

-- 
Fabien.
pgbench-help-part-1.patch (text/x-diff, 757 B)
diff --git a/src/bin/pgbench/pgbench.c b/src/bin/pgbench/pgbench.c
index a1e0663c8b..8d4f5f0866 100644
--- a/src/bin/pgbench/pgbench.c
+++ b/src/bin/pgbench/pgbench.c
@@ -639,7 +639,7 @@ usage(void)
 		   "  --index-tablespace=TABLESPACE\n"
 		   "                           create indexes in the specified tablespace\n"
 		   "  --partitions=NUM         partition pgbench_accounts in NUM parts (default: 0)\n"
-		   "  --partition-method=(range|hash)\n"
+		   "  --partition-method=range|hash\n"
 		   "                           partition pgbench_accounts with this method (default: range)\n"
 		   "  --tablespace=TABLESPACE  create tables in the specified tablespace\n"
 		   "  --unlogged-tables        create tables as unlogged tables\n"
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.