Re: speeding up planning with partitions

Imai-san,

On 2019/03/20 12:15, Imai, Yoshikazu wrote:
> Here the details.
>
> [creating partitioned tables (with 1024 partitions)]
> drop table if exists rt;
> create table rt (a int, b int, c int) partition by range (a);
> \o /dev/null
> select 'create table rt' || x::text || ' partition of rt for values from (' ||
> (x)::text || ') to (' || (x+1)::text || ');' from generate_series(1, 1024) x;
> \gexec
> \o
>
> [select1024.sql]
> \set a random (1, 1024)
> select * from rt where a = :a;
>
> [pgbench]
> pgbench -n -f select1024.sql -T 60

Thank you.

Could you please try with running pgbench for a bit longer than 60 seconds?

Thanks,
Amit