Re: pgbench - allow to create partitioned tables

Hello Amit,

>>> + res = PQexec(con,
>>> + "select p.partstrat, count(*) "
>>> + "from pg_catalog.pg_class as c "
>>> + "left join pg_catalog.pg_partitioned_table as p on (p.partrelid = c.oid) "
>>> + "left join pg_catalog.pg_inherits as i on (c.oid = i.inhparent) "
>>> + "where c.relname = 'pgbench_accounts' "
>>> + "group by 1, c.oid");
>>>
>>> Can't we write this query with inner join instead of left join? What
>>> additional purpose you are trying to serve by using left join?
>>
>> I'm ensuring that there is always a one line answer, whether it is
>> partitioned or not. Maybe the count(*) should be count(something in p) to
>> get 0 instead of 1 on non partitioned tables, though, but this is hidden
>> in the display anyway.
>
> Sure, but I feel the code will be simplified. I see no reason for
> using left join here.

Without a left join, the query result is empty if there are no partitions,
whereas there is one line with it. This fact simplifies managing the query
result afterwards because we are always expecting 1 row in the "normal"
case, whether partitioned or not.

>>> +partition_method_t partition_method = PART_NONE;
>>>
>>> It is better to make this static.
>>
>> I do agree, but this would depart from all other global variables around
>> which are currently not static.
>
> Check QueryMode.

Indeed, there is a mix of static (about 8) and non static (29 cases). I
think static is better anyway, so why not.

Attached a v7.

--
Fabien.