Re: pgbench - allow to create partitioned tables - Mailing list pgsql-hackers

From Fabien COELHO
Subject Re: pgbench - allow to create partitioned tables
Date
Msg-id alpine.DEB.2.21.1909141430550.13770@lancre
Whole thread Raw
In response to Re: pgbench - allow to create partitioned tables  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: pgbench - allow to create partitioned tables
List pgsql-hackers
Hello Amit,

>>>> 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.
>
> Why can't we change it as attached?

I think that your version works, but I do not like much the condition for 
the normal case which is implicitely assumed. The solution I took has 3 
clear-cut cases: 1 error against a server without partition support, 
detect multiple pgbench_accounts table -- argh, and then the normal 
expected case, whether partitioned or not. Your solution has 4 cases 
because of the last implicit zero-row select that relies on default, which 
would need some explanations.

> I find using left join to always get one row as an ugly way to 
> manipulate the results later.

Hmmm. It is really a matter of taste. I do not share your distate for left 
join on principle. In the case at hand, I find that getting one row in all 
cases pretty elegant because there is just one code for handling them all.

> We shouldn't go in that direction unless we can't handle this with some 
> simple code.

Hmmm. Left join does not strike me as over complex code. I wish my student 
would remember that this thing exists:-)

> What is the need of using regress_pgbench_tap_1_ts in this test?

I wanted to check that tablespace options work appropriately with 
partition tables, as I changed the create table stuff significantly, and 
just using "pg_default" is kind of cheating.

> I think we don't need to change existing tests unless required for the 
> new functionality.

I do agree, but there was a motivation behind the addition.

> *
> - 'pgbench scale 1 initialization');
> + 'pgbench scale 1 initialization with options');
>
> Similar to the above, it is not clear to me why we need to change this?

Because I noticed that it had the same description as the previous one, so 
I made the test name distinct and more precise, while I was adding options 
on it.

> *pgbench(
> -
>  # given the expected rate and the 2 ms tx duration, at most one is executed
>  '-t 10 --rate=100000 --latency-limit=1 -n -r',
>  0,
>
> The above appears to be a spurious line change.

Indeed. I think that this empty line is a typo, but I can let it as it is.

> * I think we need to change the docs [1] to indicate the new step for
> partitioning.  See section --init-steps=init_steps
>
> [1] - https://www.postgresql.org/docs/devel/pgbench.html

The partitioned table generation is integrated into the existing create 
table step, it is not a separate step because I cannot see an interest to 
do something in between the table creations.

Patch v8 attached adds some comments around partition detection, ensures 
that 0 is returned for the no partition case and let the spurious empty 
line where it is.

-- 
Fabien.
Attachment

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: range test for hash index?
Next
From: "Daniel Verite"
Date:
Subject: Re: Create collation reporting the ICU locale display name