Skip to content

create AO table with(parallel_workers) doesn't take effect. #131

@avamingli

Description

@avamingli

Cloudberry Database version

No response

What happened

Alter AO's parallel_workers is ok, but set it when creating AO table doesn't take effect.

What you think should happen instead

No response

How to reproduce

Alter AO's parallel_workers is ok, but set it when creating AO table doesn't take effect..

gpadmin=# create table ao1(c1 int) using ao_row distributed by(c1);
CREATE TABLE
gpadmin=# alter table ao1 set(parallel_workers=3);
ALTER TABLE
gpadmin=# \d+ ao1;
                                           Table "public.ao1"
 Column |  Type   | Collation | Nullable | Default | Storage | Compression | Stats target | Description
--------+---------+-----------+----------+---------+---------+-------------+--------------+-------------
 c1     | integer |           |          |         | plain   |             |              |
Compression Type: None
Compression Level: 0
Block Size: 32768
Checksum: t
Distributed by: (c1)
Access method: ao_row
Options: parallel_workers=3
gpadmin=# create table ao2(c1 int) using ao_row with(parallel_workers=3) distributed by(c1);
CREATE TABLE
gpadmin=# \d+ ao2;
                                           Table "public.ao2"
 Column |  Type   | Collation | Nullable | Default | Storage | Compression | Stats target | Description
--------+---------+-----------+----------+---------+---------+-------------+--------------+-------------
 c1     | integer |           |          |         | plain   |             |              |
Compression Type: None
Compression Level: 0
Block Size: 32768
Checksum: t
Distributed by: (c1)
Access method: ao_row

No Options: parallel_workers info of ao2.

Operating System

Ubuntu

Anything else

No response

Are you willing to submit PR?

  • Yes, I am willing to submit a PR!

Code of Conduct

Metadata

Metadata

Assignees

Labels

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions